Sheet activation working fine for me, but not for others?

I've got a bit of a macro that opens a second workbook, copies its contents, pastes it into the workbook from which the macro was run, then closes the workbook that was opened.

Please Login or Register  to view this content.

This all runs fine on my own PC, but at the starred activation line it errors out for others on our LAN. Any inclination as to why that may be, or alternatively would there be a good way to perform this copy without opening or activating the sourceofcopy.xlsx workbook? The aim is simply to copy the entire contents of a single worksheet to the open workbook for analysis. VBA is definitely not my line of work, so please have patience with the newb!

Hi seed and welcome to the forum,

Without seeing your machine or others on the net, I'd expect you have a local copy of the file and it can find and open it while others don't have a local copy of that .xlsx file. Perhaps you need to put a path in front of the location of that file and stick it on your net somewhere. Then when others (and you also) try to open it, it will search on the net instead of your local machine.

My answer is a simple guess. Without being on your net or seeing your machine and local files, I'm not sure it my suggestion is even close.

Something like this?? http://excelexperts.com/VBA-Tips-Get-A-File-Path

Sorry - There is a path to the file, which is located on our company's LAN. The line actually reads

Please Login or Register  to view this content.

Just to be sure, I'll go ahead and write a tiny macro to simply open the file and see if that works for them, then get back to report the result. I would think that if the path to the file was the problem, though, that it would have errored out at that workbooks.open line rather than the windows.activate line? I wish I had more time to learn all this stuff...

Thank you for your reply.

Perhaps you need to do a
application.workbooks("sourceofcopy.xlsx").Activate
instead of your
Windows("sourceofcopy.xlsx").Activate

In the VBA immediate window do these two commands
application.FindFile
?application.ActiveWorkbook.path

The Application.FindFile will open a dialog and allow you to look for the file. When you find it and press enter it will open that file. Then the
?Application.ActiveWorkbook.Path will do a Debug.Print (?) of the path to where that sucker is.

Is there a chance others on the net have their drive maps different than yours? Some may have a directory mapped as F: while others G: or K:? That is the old Novell method. You should do the above on their machines to see where they think the file is located on the net.

Could the problem be that some people have Windows set to display file extensions and other's don't?

By the way, the code could be tidied up a bit.

Please Login or Register  to view this content.

Actually that might help with the original problem because it doesn't involve referring to workbooks with their names.

seed

You would think it wouldn't matter but it sometimes does.