Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello,
Any help would be greatly appreciated: I am attempting to write a macro to do the following once a specific .xls file is opened: 1) Prompt the user to enter a folder name 2) Close that .xls file 3) Create a folder with the user entered name in a specific location 4) Copy the .xls file into the folder 5) Copy three (3) other .doc files to that folder 6) Open the copied .xls file As I said, any assistance would be greatly appreciated. Thank you, Wes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a copy of a folder having five files in it, & rename | Excel Worksheet Functions | |||
Save copy of folder with linked files | Excel Worksheet Functions | |||
Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
Copy files from spreadsheet into folder | Excel Discussion (Misc queries) |