Copy workbook, don't copy macro

C

CongroGrey

Is it possible to copy a workbook but not the macro?

Backround - I have created a workbook which receives transferspreadsheet
data from Access. I have an Excel macro which formats the sheet, then
deletes the transferspreadsheet sheet. I want the user to be able to save
this report with the current date, but not copy the macro to the new sheet.

Is this possible?
 
K

Kevin B

Add code to your macro to move the formatted sheet into a new workbook,
change the MyNewWorkbook.xls to the name you want the new file to have and
the FormattedSheet.xls name to the name of the workbook that contains the
macro:

Application.Workbooks.Add
ActiveWorkbook.SaveAs "MyNewWorkbook.xls"
Application.Workbooks("FormattedSheet.xls").Sheets(1).Activate
Sheets(1).Activate
ActiveSheet.Move Before:=Workbooks("MyNewWorkbook.xls").Sheets(1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems getting this macro to work 23
Excel Move or Copy Stopped Working? 0
VBA Copy values only onto new workbook 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Merge Multiple workbook sheets into one workbook 0
Saving a worksheet 2
macro to copy last sheet in workbook 3
Copy Sheet to new Sheet and clear cells on original sheets 7

Top