Hi,
I feel really stupid asking this question but I cannot get this part of my macro to work.
In essence, I am opening one file that contains data that I need to copy to 50 other files (paste special values to the same location in all 50 files).
I open the source file (it is always the same name and located in the same folder).
It does not like Windows(mfileprs).Activate but using this same variable to open the file works fine.Please Login or Register to view this content.
What is it that I'm not understanding
Bookmarks