| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
serveral excel file problem?
I want to use data of unopen another excel file.how do?must use data of file
after openning? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
serveral excel file problem?
You can link to a file with formulas. You can access it using ADO.
http://support.microsoft.com/default...b;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 -- Regards, Tom Ogilvy "hedia.chen" wrote in message ... I want to use data of unopen another excel file.how do?must use data of file after openning? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| data in serveral cells | Charts and Charting in Excel | |||
| file save problem in excel | Excel Discussion (Misc queries) | |||
| how do i lookup and sum from serveral wkshts to a recap sht? | Excel Worksheet Functions | |||
| problem with insert Excel file in another Excel file | New Users to Excel | |||
Hybrid Mode
