| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file from the value of cell in different opened file
Dear Expert,
I have asked this question before. Want to save the file name in accordnace to value in cell A1 Activeworkbook.Saves fileName:= Range("A1").Value But that was supposed to be in same worksheet and file. Say, if I want to save a file called ABC.XLS to ABC_20090430.XLS via VB script, the file contains ABC_20090430.XLS is in file OPENFILE.XLS Cell V2 rather than ABC.xls. So how to fine-tune the VB scripts please ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opened excel file from email & clicked save after modify . Where i | Excel Discussion (Misc queries) | |||
| Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
| Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
| Save file with different name and dont update the links when opened again | Excel Discussion (Misc queries) | |||
| save to same file as opened | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
