I'm trying to write a program that will switch between workbooks. However, the current code gives me a type mismatch. I tried Variant and Object for my variables but those don't work.
Please Login or Register to view this content.
I'm trying to write a program that will switch between workbooks. However, the current code gives me a type mismatch. I tried Variant and Object for my variables but those don't work.
Please Login or Register to view this content.
This is a string, it's not a workbook or a reference to a workbook.
If you want to set wk to refer to workbook you could try this.Please Login or Register to view this content.
Mind you the workbook Book1.xlsm would need to be open for that to work.Please Login or Register to view this content.
If posting code please use code tags, see here.
Great thanks. For future viewers check out this.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks