Move from one file to another

  • Thread starter Thread starter JT
  • Start date Start date
J

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.
 
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
 
Back
Top