QM2 & Excel - Move a tab to a different file

[pgomez]

I think I may have figured out a way that works. Both of these modifications are working for me now:

Macro Combine Excel files

Code:

Copy      Help

;attempt 1
int i = wb2.Sheets.Count
wb1.DialogSheets.Move(@ wb2.Sheets.Item(i)) ;; works

;attempt 2
wb1.Sheets.Move(@ wb2.Sheets.Item(i)) ;; works

I'm not sure exactly why they are working, but I'm glad they are.

Thanks anyway!
--Phil