Copying a sheet within the workbook to another folder's after adding a sheet

[LeapingLizard]

Hi VBA gurus,


I have a workbook that I am opening up and inserting another worksheet into it then trying to copy a sheet from the exiting workbook, that contains the code, into the sheet I just inserted. I hope that makes sense? In other words, I have a workbook that runs code through a command button as it copies all the data from LinenData sheet into a folder Name 2013 after it has opened and inserted another sheet.

Here is the code and I will include a sample of the workbook;

Please Login or Register  to view this content.

Thank You, LeapingLizard

[patel45]

I did not understand your problem

[HaHoBe]

Hi, LeapingLizard,

why insert a sheet first and then copy another one`s contents into the new one and not take the original one and copy that? Is there any particular reason you copy Sheets("LinenData") anyhow no matter what the response from the MsgBox is?

Please Login or Register  to view this content.

Some words on your modules: you should delete the empty ones to make it clear where to find any code (and not just bulk through empty modules) and maybe add where to find your code. The Code in Module16 should reside in ThisWorbook as only from there the Workbook_Open-Event will get triggered. And if you could get used to indent the code this could help a quite a bit on recognising what you are after.

Ciao,
Holger