I am writing a macro that is essentially taking information from one column in Workbook A and copying and pasting it in another column in Workbook B. All of that works just fine- I'm running into issues with how I've declared my workbooks.
"Book Name" is the name of Workbook B and "FileName" is the name of Workbook A. For example: If Workbook B is "Sample1" then Workbook A is "Sample1 (proc)". My issue is that Filename is seeing "BookName" as me wanting to write book name instead of seeing its actual value. That is, instead of getting "Sample1 (proc)", I'm getting "BookName (proc)".
Help would be much appreciated! This code was working this morning exactly as it's written below, but I guess the stars have realigned and it's no longer working
Please Login or Register to view this content.
Bookmarks