VBaQuestion
New Member
- Joined
- Feb 2, 2017
- Messages
- 13
Hi forum,
it seems easy enough...NOT.
With the following code I intend to
-move a sheet to another workbook,
-rename it (actually, with a name consisting of cells "A9" and "_" and "H8" of said sheet)
-place the sheet at the beginning of the workbook it was moved to,
-and continue with the userform in which the code was running.
-the workbook, the sheet get moved to, ("InvoicesBU_2017") remains closed
"My" code doesn't work, your code solving my challenges would be very appreciated!
it seems easy enough...NOT.
With the following code I intend to
-move a sheet to another workbook,
-rename it (actually, with a name consisting of cells "A9" and "_" and "H8" of said sheet)
-place the sheet at the beginning of the workbook it was moved to,
-and continue with the userform in which the code was running.
-the workbook, the sheet get moved to, ("InvoicesBU_2017") remains closed
"My" code doesn't work, your code solving my challenges would be very appreciated!
Code:
Worksheets("InvForm1").Move before:=Workbooks("InvoicesBU_2017.xlsm").Tabelle1
