serveral excel file problem?

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

Guest

I want to use data of unopen another excel file.how do?must use data of file
after openning?
 
You can link to a file with formulas. You can access it using ADO.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246335
How To Transfer Data from an ADO Recordset to Excel with Automation

http://support.microsoft.com/kb/257819/EN-US/
How To Use ADO with Excel Data from Visual Basic or VBA

http://support.microsoft.com/kb/278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/kb/247412
INFO: Methods for Transferring Data to Excel from Visual Basic

http://support.microsoft.com/kb/172267/EN-US/
SAMPLE: RECEDIT.VBP Demonstrates File I/O in Visual Basic
 
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

Immediately run macro when import text data. 3
How to get file's current directory path to a string in VBA? 1
worksheet to be moved 1
how can i get data from an un_opened excel file using codes 2
Adding Data from EXCEL to a TEXT file 3
windows xp screen saver 1
Select range from unopened workbook 7
save as w/sheet 4

Back
Top