Macro

[Marian]

I have any problem.

I have some(more as 20) spreadsheet files and I want to connect their to one spreadsheet file last options: each spreadsheet file is being individual worksheet in new spreadsheet file.


I use button for action click with code: Workbooks("old1.xls").Worksheets("sheet1").Copy after:=Workbooks("New.xls").Worksheets("Sheet1")

But is not correct
Can yuo help me, please!!!!!

[mudraker]

Pleased read forum rules - see blue link below
Use valid thread title
Wrap all VBA code - see red link for instructions

Closing thread