I was wondering if I had to open up a workbook in order to extract data,
filter, sort, delete rows etc.?
I already use the workbook().Worksheets() notation to deal with open
workbooks.
I was wondering if I had to open up a workbook in order to extract data,
filter, sort, delete rows etc.?
I already use the workbook().Worksheets() notation to deal with open
workbooks.
Well I dont believe there is any way you can do data manipulation while
the workbook is closed...but you could have your macro do the opening
of the file...so you dont have to open up the workbook...would that
help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks