| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Script to use any open file when copying and pasting
I have a VBA script that copys data from a particular excel sheet into a new
workbook. Currently, if the file name changes, the script does not work. For the code below, what do I need to enter that ANY file name will work. Workbooks.Add Windows("SpecificFile.xls").Activate Sheets("Assumptions").Select What would replace Windows("SpecificFile.xls").Activate such that if a file opened called File1.xls, or File9.xls, etc, woudl work. Charles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying and pasting to a different xls file in a different directo | Excel Programming | |||
| copying and pasting to a different xls file in a different directo | Excel Programming | |||
| copying from one file pasting in another | Excel Programming | |||
| Pasting formulas without copying file ref. | Excel Programming | |||
| How do I add a File Open box to this script??? | Excel Programming | |||
Threaded Mode
