98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Saving macro generated reports
Saving macro generated reports
Resolved · Low Priority · Version 2003
Fri 22 Jan 2010, 16:08Delegate Simon said...
Simon has attended:
Excel VBA Intro Intermediate course
Saving macro generated reports
Can you show me the code for saving the report in a new file / folder rather than in the data worksheet. Thanks
Sun 24 Jan 2010, 19:39Trainer Anthony said...
RE: Saving macro generated reports
Hi Simon, thanks for the query. Here's the code you need. Make sure the mynewfilename variable is set your desktop (it's set to mine in the example below). The code copies strName to a new file, then saves that file to the desktop.
***
Dim mynewfilename As String
mynewfilename = "C:\Documents and Settings\User10\Desktop\" & strName & ".xls"
Sheets(strName).Select
Sheets(strName).Copy
ActiveWorkbook.SaveAs Filename:=mynewfilename
ActiveWorkbook.Close
***
Hope this is useful!
Anthony
Sun 31 Jan 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use the SUBTOTAL function in ExcelYou can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this: |
