Move Excel Spreadsheet Using OLE2

[krindler]

Hello...

Does anyone have any example OLE2 code that moves an Excel spreadsheet. I am trying to create a report that inserts a new spreadsheet for every new location. What is currently happening, is the new sheet is put in front of the old sheet, and I would like it to insert the sheet after the current sheet. My location ids are then ending up in descending alphabetical order instead of alphabetical.

Thanks In Advance...

 

[dmarnerou]

Hi krindler,
I am having a similar situation as the one you're describing. I am trying to move a worksheet from one workbook to another. Did you manage to solve your problem and if so could you tell me how?

Thanks and regards,
Demetra