LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need formula help linking closed excel files Steven Excel Discussion (Misc queries) 6 July 10th 07 05:50 PM
Updating Closed External Refs [email protected] Excel Discussion (Misc queries) 5 May 7th 07 05:16 PM
Lookup function Closed files Excel [email protected] Excel Worksheet Functions 3 January 12th 07 04:41 PM
why do all files get closed when i only close one in excel? carrie Excel Discussion (Misc queries) 1 November 28th 05 06:45 PM
Can you recover Excel files accidently closed using autosave? Mazamban Excel Discussion (Misc queries) 2 June 6th 05 05:40 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"