View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
GainesvilleWes GainesvilleWes is offline
external usenet poster
 
Posts: 2
Default Macro to create a folder and copy files

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