- Oct 31, 2008
I have a main QC workbook that as it opens the first time it gets renamed as it is saved. I am trying to write a macro that opens a trend data workbook, transfers data and then switches back to the main QC workbook. How do I specify this workbook in code when the name will be different from one workbook to another? This is also critical as the user may have more than this main QC workbook open.