i have a macro and .csv file, i run the macro every monday on the same file (file gets downloaded from outlook and file name remains the same, only the data in it changes. and it has only a single sheet of data) i am trying to automate this process using a third party tool.
how to refer to the sheet in the macro instead of using the Activesheet and ActiveWorkbook, since i don't want to open the datafile each and every time i run the macro.
Sub test()
Workbooks.open Filename ="c:\test"
iRowCount = ActiveSheet.UsedRange.Rows.Count 'How do i refer my data file here instead of using active sheet?
Any help appreciated
Bookmarks