ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy worksheet from one file to another (https://www.excelbanter.com/excel-programming/426701-copy-worksheet-one-file-another.html)

JT

Copy worksheet from one file to another
 
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 to add a code to copy or move the worksheet Month from
File1.xls to File1.xls.
Please help me.
Thanks.

AltaEgo

Copy worksheet from one file to another
 
Lot's of sample code he

http://support.microsoft.com/kb/288402

Come back if you have a problem.
--
Steve

"JT" wrote in message
...
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 to add a code to copy or move the worksheet Month from
File1.xls to File1.xls.
Please help me.
Thanks.



AltaEgo

Copy worksheet from one file to another
 
Also:
http://en.allexperts.com/q/Excel-105...rkbook-new.htm

--
Steve

"JT" wrote in message
...
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 to add a code to copy or move the worksheet Month from
File1.xls to File1.xls.
Please help me.
Thanks.




All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com