
Originally Posted by
zoomtronic
Now i need to enter date automatically into cell on new data entry,
any idea?
Refering to my MSDN code, OpenExcelWriteData in OpenWorkSheets.vb shows how to write data to a cell, in this case strings but you can so this with a Date too i.e.
Code:
xlRange1.Value = Now.ToString("d")