runtime 9 error

R

Rpettis31

I run a macro that runs fine on my machine and some of the others in my
office. Yet for some reason this error continually occurs on certain
machines. Scenario is the workbook is open and clears data from sheets opens
another file copies the data. However, when it returns to the orginal
workbook it gives the runtime 9 error.
This does not occur on my pc and some of my coworkers yet on others it does.

' Go Back to inventory analysis and paste data
Windows("Inbound inventory Analysis").Activate {Error is on this line}
Sheets("$ Analysis").Select
ActiveSheet.Paste
ActiveWindow.ScrollColumn = 2
 
J

Jim Rech

It appears that you've opted to "hide extensions of known file types" (a
Windows Folder Options setting) while the user where the macro failed did
not. It's better to use the workbook name rather than the window name if
possible:

Workbooks("Inbound inventory Analysis.xls").Activate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top