Can I perform tasks on a closed Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying cells and formula from closed workbook to all sheets in open workbook 0
How to append data from different sheet and different workbook? 2
Can scientific notation be turned off? 1
Unwanted workbooks on startup 2
Cell values to an array, then array transpose to another workbook 8
Access Data from Workbook without seeing the workbook open. 1
Remotely close a workbook 1
Changing a csv file opened as hidden workbook 13

Back
Top