Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an excel macro to open and save sheets to a different directory
Hey-
I am hoping for some help as I have never created a macro in excel before and was just asked to work on one. We have about 90 files saved in different subfolders on a server. The files are accessible through a webpage and I have the path. I would like to save each of these folders to a network drive. i.e. I would run the macro and it would copy all of the files in the same directory structure to a folder on a network drive. Thanks in advance for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - Open all word files in a directory | Excel Worksheet Functions | |||
How do I save macro so it's there for all Excel sheets? | Excel Discussion (Misc queries) | |||
open in old directory save in new directory | Excel Programming | |||
ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
Creating a macro that lists directory names within a directory.... | Excel Programming |