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