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).
mfileprs = Cells(mstart, 2) & Cells(mstart, 3)
Workbooks.Open FileName:=Chr(34) & mfileprs & Chr(34)
Windows("Exchange Rates.xlsx").Activate
Worksheets("Sheet1").Range("A1:B9").Copy
Windows(mfileprs).Activate
Worksheets("Rates").Range("AA1:AB9").PasteSpecial Paste:=xlPasteValues
It does not like Windows(mfileprs).Activate but using this same variable to open the file works fine.
What is it that I'm not understanding
Bookmarks