Move from one file to another

[JT]

In MS Access I have command button where I do run module to load data to
excel file “File1.xls†and worksheet “Monthâ€.
The next I need add a code to copy or move the worksheet “Month†from
‘File1.xls’ to “File1.xls†as a new tab.

 

[Mr. B]

JT,

I did some searching over in the Excel newsgroup and there are a couple of
threads there that might help you with some code.

Sorry, but I do not have an example.

HTH
Mr. B
askdoctoraccess dot com