Board index MS EXCEL

Link multiple spreadsheets to one central spreadsheet using a macro

Link multiple spreadsheets to one central spreadsheet using a macro

Post by Amand » Fri, 20 Aug 2004 04:38:04


Is it possible to write a macro using visual basic editor
for applications that will search for all files within
one file folder, automatically create canned links to the
same cells within each file and return or update the data
to one central excel file. Each new row would have links
to the same cell numbers but different file names.

Please help!
 
 
 
Top

Link multiple spreadsheets to one central spreadsheet using a macro

Post by GJone » Fri, 20 Aug 2004 05:59:29

Hi Amanda;

It is possible to do what your asking about but it most
likely a consulting job.

Thanks,

Greg
XXXX@XXXXX.COM

 
 
 
Top

1. Spreadsheet: how can I store test results from different tests in the same central spreadsheet?

2. VB macro to load/copy/paste multiple files into one spreadsheet.

3. Macro to copy and append spreadsheet changes to new spreadsheet

4. Macro to copy all spreadsheets into 1 spreadsheet

5. Macro to save excel XP spreadsheet to excel 97 spreadsheet format

6. SPREADSHEET CRASHES WHEN I USE MACROS ON DATABASE SPREADSHEET

7. one column listbox, multiple bookmarks, spreadsheet link

8. Trying to import multiple spreadsheets using macro

9. How do I link an excel spreadsheet or spreadsheet like data to a f

10. Program link to Excel spreadsheet opens Excel but not spreadsheet

11. How do I link an excel spreadsheet or spreadsheet like data to

12. Appending data from one spreadsheet to another using a macro

13. Importing Spreadsheet/Linking spreadsheet

14. A spreadsheet will not link to cells in another spreadsheet?

15. link a local spreadsheet to a network shared spreadsheet

All times are UTC
Board index