Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating closed excel files
I have a list of data, let say from A1 to A20.
I want to update them into A1 of 20 files namely file1.xls, file2.xls ..... file20.xls. The A1 will goto file1.xls A1 A2 will goto file2.xls A1 ...... A20 will goto file3.xls A1. Is there any macro to update closed file's cells? regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating closed excel files
This file might be a help:
http://www.bygsoftware.com/examples/...SqlRequest.zip It's in the "Excel with Access Databases" section on page: http://www.bygsoftware.com/examples/examples.htm This workbook demonstrates how to get data direct from an MS Access table, or from an open or closed MS Excel workbook using the workbook function SQL.REQUEST. Recently updated to show the use of SQL.REQUEST in the same workbook. The code is open and commented. The nice thing about SQL.REQUEST is that you can structure it to use replacable filenames parameters (the "missing" feature of INDIRECT), and you can also run UPDATE queries which will update data in closed Excel files. The downside is that it's slow. -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy wrote in message oups.com... I have a list of data, let say from A1 to A20. I want to update them into A1 of 20 files namely file1.xls, file2.xls .... file20.xls. The A1 will goto file1.xls A1 A2 will goto file2.xls A1 ..... A20 will goto file3.xls A1. Is there any macro to update closed file's cells? regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula help linking closed excel files | Excel Discussion (Misc queries) | |||
Updating Closed External Refs | Excel Discussion (Misc queries) | |||
Lookup function Closed files Excel | Excel Worksheet Functions | |||
why do all files get closed when i only close one in excel? | Excel Discussion (Misc queries) | |||
Can you recover Excel files accidently closed using autosave? | Excel Discussion (Misc queries) |