Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Emily Diaz on Oct 13 In MS Office Category.

Extract data without opening workbook

Question Answered By: Volker Fischer on Oct 13

I wonder if your users are opening/extracting/closing by hand, or if it's
all happening with VBA?

In any case, it is possible to use ADO and refer to each file as a database.
I never did timing tests of the two methods to see which one is faster.

This Question has 3 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Extract data without opening workbook Or get search suggestion and latest updates.

Related Topics:

Making a Workbook as an Active Workbook without opening it
Opening a workbook without being shown
Prob running workbook activate code when workbook is opened by anot
Prevent Workbook open runing when opening another Excel Doc
Copy, then email workbook without macro attached
Run Macor in a closed workbook and refer to the closed workbook
Next Workbook or Previous Workbook
Read in Data Without Opening The File
Change Workbook's Name
Can't show a Workbook opened by GetObject()
Using Exvba can I open an outlook message and then its excel workbook
Can't save/close workbook opened with GetObject using VBA
Opening a workbook, and setting it as a variable
Delete open workbook
reconcile data from samew workbook but in different sheet
Searching for data in workbooks
code for saving the data in another workbook while entering in one
write data from one workbook to another
Linking data from one Workbook to another
how upate daily datewise data form one workbook to another

Tagged:extract data without opening workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us