Hello All,
The purpose of the macro I am working on is to batch produce pdf customs documents, by copying the values from the variable workbook (it changes name every time I take a fresh download from the database), pasting them into the fixed workbook where the relevant customs info is produced from a lookup sheet, and then copying the value of the results back into the original workbook, which will then save the sheet as a pdf and loop through any remaining. I am very new at using VBA and I haven't been able to find any info on how to copy/paste or use a 'value' formula alongside the 'ThisWorkbook' feature, so if anyone can explain to me where to start with this that would be hugely appreciated!
Thanks!
C
The purpose of the macro I am working on is to batch produce pdf customs documents, by copying the values from the variable workbook (it changes name every time I take a fresh download from the database), pasting them into the fixed workbook where the relevant customs info is produced from a lookup sheet, and then copying the value of the results back into the original workbook, which will then save the sheet as a pdf and loop through any remaining. I am very new at using VBA and I haven't been able to find any info on how to copy/paste or use a 'value' formula alongside the 'ThisWorkbook' feature, so if anyone can explain to me where to start with this that would be hugely appreciated!
Thanks!
C
