This block of code replaces a worksheet with one from a file. It runs fine when I'm at work, but trying to run it remotely using VMWare, it fails. Can I fix this?
I get a runtime error 9/subscript out of range on the line below
Set wsnew = wbnew.Sheets("Sheet1")
Please Login or Register to view this content.
Well, that must mean there is no "Sheet1" in the workbook being opened. You need to step through the code and determine a) what the filepath is, then b) check what filename is selected from the dialogue and then finally c) check that the file opened does have the Sheet1 in it.
It may be that, in the Virtual Machine, the filepath takes you somewhere other than where you think it does.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Well, the sheet name now has the name "Data" rather than "Sheet1", and I don't know how that came about, but Data works as well as Sheet1. Thanks for the tip.
You're welcome.
You could use the Sheet's Code Name which would most likely be Sheet1. Then it doesn't matter if it gets renamed.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks