Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to create "path" for save
Hi
I am using a template spreadsheet to do the payroll for various clients. When it comes to saving it on out system I would like to save it automatically in a specific folder for each client. In the sheet I have 3 cells with the following info: Company (A1) Month (A2) Year (A3) I would like to create a macro to save the file under \payroll\COMPANY\YEAR\MONTH\file.xls Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you create a macro on a protected sheet? | Excel Discussion (Misc queries) | |||
How do I create a macro that will automatically input lines? | Setting up and Configuration of Excel | |||
Macro to create mulitple files | Excel Discussion (Misc queries) | |||
create autosum macro along with notation on the side | Excel Worksheet Functions | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |