Macro button generates "run time error 1004 [FileName] could not be found' msg

Hi All (especially those who are Excel Macro Guru Extraordinaires!)

I have a situation where I have a Macro File (used to go and grab and consolidate excel files) that was developed for an end-user and while the file works great for me, she gets the following error:

VB error msg.JPG

The code for the button is as follows:

Please Login or Register  to view this content.

We both use Excel 2010, but need the files to be in 97-2003 format

I noticed that while the file sizes in my C drive is 205 KB and 203 KB, hers is 200KB. Don't know if this matters. Right now I am grasping at straws since she has everything set up exactly as I do (for purposes of running the macro) She cannot her her files to run. Does the macro need to be modified? Any suggestions on how to resolve this issue?

Thanks

Dawn (Guru wannabe)

Ok, I will try to answer the questions!

1. The files are located in the same directory/ folder
Directory Folder image.JPG

2. When I run the macro, I don't have the "IS_OU_File_Consolidator_2.xls" file open

3. Does the order that the file is listed in the folder make a difference?

Backstory: I will open the "IS_OU_File_Consolidator.xls" file, run the macro and the finshed product is generated.

Is there any other information I can provide to be of better assistance?

Thanks so much for putting extra eyes on this. (Let me know if the jpg file doesn't show, I am a visual person and I like to "See" what the other person is seeing, hence, I am big on screen shots)

Hi p24leclerc,
The reason for the 2 files is due to the way the macro was set up. I will provide a sample of the macro that may provide some clues.

Please Login or Register  to view this content.

I modified this file from another user to be used for another division. All applicable changes were made and tested before I sent the 2 consolidator files. I provided explicit instructions as to how to "install" the files. I did a line by line compare with the macro from her files (ones I sent her) to mine and cannot seem to find out why it won't work. I had her go to the Windows Explorer>Tools>Folder Options>View and uncheck the "Hide extensions for known file types" so that perhaps maybe that was why the macro couldn't find the file.(That didn't work either) Is it possible she may need to "re-do" the macro button itself? (I also told her NOT to have any other excel files opened when she runs the "macro" from the IS_OU_Consolidator.xls file.) sigh..... Hope this info helps

Originally Posted by Firefly2012

Do you know that on this other user's computer, the two files are within exactly the same directory? Have you physically checked rather than taking their word for it?

If you look I posted (Comment #4) the image (Directory Folder image.jpg)showing that both files are in the same directory. So the answer is "Yes". Frustrating isn't it? ughhhh.... at least I am not the only one stumped!

What about the possibility of "redoing" the macro button and "refreshing" if you will?

Hi Firefly,

I modified the macro per your example, sent to my end user to see if this does the trick (keep your fingers crossed!). FYI, no way I would have figured this one out on my own! While I am relatively handy with macros I still consider myself such a noob!

HOORAY HOORAY!!!! Just received notification that the macro change did the trick!! Firefly, I bow down before the master! Thank you so much for helping me with this. I can now "Close" the ticket!