Hi folks,
Im a very newbie in excel macro, so Im seeking your help in writing the code for the following:
- Macro code is in an active workbook. say workbooks("1.xls")
- I need a code to open workbook 2.xls, which includes many links. Then pop up change source dialogue to let users choose files/sources to update. Reason to do this: A new data source file is available every week, therefore, each week, user will have to change the source for this file 2.xls.
- Then close this workbook 2.xls, and the save as dialogue pops up to have user save as to a new file at a different location. Reason: the workbook 2.xls is only used as the template, and should be read only. Each week, a new version of workbook 2.xls (after links are updated) is saved to a designated folder.
Thank you in advance.
Bookmarks