Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming worksheet from within macro
I have a daily bookwork sheet that containes employee names. This file changes as employees come and go. I am writing a macro so that a person doing my daily books can select the day of the month from a list in excel. When they select the day, it will copy the original file... is there a way to do a "save as" from inside a macro. ex. on june 1st, hit the excel macro for that day, it will bring up the master file, rename it and save it as june 1. Doing the same with each day during the month. Therefore the master file with names can change to affect all days forward.
Open to any suggestions Thanks for the help, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming worksheet from within macro
Private Sub Macro1( ) If Not Listbox1.Text = "" Then ActiveWorkbook.SaveAs Filename:= Listbox1.Tex End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming worksheet from within macro
To Chris
Thanks for the help. To be honest i don't really know how to use this info. Where can i learn more about this. Is this stuff actually done inside the worksheet? Don't expect you to teach me this, but would like some help with where to learn. I get computer stuff pretty quickly. Thanks again, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Renaming | Excel Discussion (Misc queries) | |||
Worksheet Renaming | Excel Worksheet Functions | |||
Get macro to run on any worksheet without renaming the sheet? | Excel Discussion (Misc queries) | |||
need help renaming a worksheet | Excel Discussion (Misc queries) | |||
Renaming the Worksheet through VBA | Excel Programming |