Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro excel save
I had recorded a macro to get my audit sheet based on 3 reports.
I am having 4 tabs in my macro sheet, namely Audit, Report1,Report2,Report3. I will be pasting my 3 reports in the respective Report tabs and I will run the macro. With my macro I will get the overall Audit Report in the Audit sheet and also that sheet will be copied in to a new excel say Sheet1. Also in the Audit Tab, which is copied in to a new excel sheet I have my Job number in the cell C13. I want to save that sheet in the name as "Report_O01393698" where O01393698 is the Job Number from the Cell C13. Job Number will change for every Report. So Lets say my existing Macro as "Audit". Whether I can save the sheet which is copied from the Sheet Audit in to the Desktop with the given naming format using a macro. |
#2
|
|||
|
|||
You need to be a little clearer about what you want to name and how.
Your macro can certainly rename worksheets based on cell values etc. Dim New_wksname as string New_wksname = Worksheets("Audit").range("C13").text Worksheets("name of worksheet that you want renamed").name = New_wksname Quote:
Last edited by Jules : May 12th 05 at 06:30 PM Reason: Missed a bit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
record an excel macro, save on network so that everyone can access | Excel Discussion (Misc queries) | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel | |||
Excel crashing on save as | Excel Discussion (Misc queries) | |||
Turning a Macro into an add-in for Excel? | Excel Worksheet Functions |