paste worksheet into existing wirkbook 1

[funkmonsteruk]

I'm running some reports which create a new workbook each day, the workbook contains a single worksheet.

I'm trying to run some code when the new workbook is produced which will insert it into an existing workbook which contains reports from previous days.

Any suggestions?

 

[jimbo62]

Try the DoCmd.TransferSpreadsheet [Transfer type],[Fullpathincluding filename] Be sure to rename the file before exporting. Look in the VBA Editor and search for the object library for syntax.

Thanks,

Jim

 

[RobBroekhuis]

Assuming the new workbook has just one sheet, and you don't want to keep it after it's added to the summary workbook, use:

LastSheet=workbooks("summary&quot.sheets.count
Sheets(1).Move After:=Workbooks("summary&quot.Sheets(lastsheet)

This moves the sheet to the end of the summary workbook, and automatically activates the summary workbook. If you do want to keep the single-sheet workbook use "copy" instead of "move".
Rob

 

[funkmonsteruk]

Fantastic Rob, cheers for your help again