get data from a workbook which is not open 1

[sunnytahir]

Dear Sirs,

I want to get data from some workbooks which are not open.
is it possible?

Thanks.
Tahir

 

[PHV]

You may consider ODBC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[byundt]

John Walkenbach shows VBA code to retrieve data from a closed workbook in

http://j-walk.com/ss/excel/tips/tip82.htm

This method is much faster than opening the workbook, but you do have to know the Path, file name, worksheet name, and cell address of the desired information.

 

[byundt]

Code examples using DAO are shown at

http://www.experts-exchange.com/Applications/MS_Office/Q_20815824.html

ADO/DAO can put revised information back into a closed workbook. See the Answer by Suat (smozgur) near the bottom of the page.

 

[SkipVought]

Tahir,

Take a look at ths spreadsheet feature in Data/Get External Data -- Excel Files -- Your Closed Workbook.

The data must be in Table Format, best with one sheet per table. You can design queries in a QBE Grid. You can also have parameters to pass to the queries.

I often set up the initial query, then macro record editing the query, and use that code as the basis for making a fully interactive report application.

However, if you need to update the external Excel file, it must be done via DAO or ADO. In that case, I recommend putting your Excel database in a real database instead.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[sunnytahir]

Dear Sirs,
Thanks all for giving attention to my question. it helped me very much.

i want to ask dear PHV that what is ODBC (a some breif note) or sites where i can find help about ODBC. i will be very thankful to you.

Best regards.
Tahir

 

[PHV]

The ODBC (Open DataBase Connectivity) way is quite the same as the Skip's suggestion.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sunnytahir]

Dear PHV,
Thanks for your prompt reply.

i am new to vba and i could not understand the SKIP's about DAO, ADO, and QBE Grid. So please give me any examples to how i can understand the ODBC.

Best regards.
tahir

 

[fredericofonseca]

Tahir,

Search

http://www.amazon.com

and you will find many books on the subject.

Search

http://www.deja.com

and

http://www.microsoft.com

and these forums



for ODBC, ADO, DAO in both cases and you will find plenty of stuff to help you.

Note that these forums are not a helpdesk, and you need to research this for yourself, and after that if you have specific issues with a piece of code THEN we will be able to help you with it.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[xlbo]

Also try searching the excel VBA help files - there's lots of useful info in there

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question