pcsparky
02-07-2009, 02:27 AM
I'm trying to get this snippet of code to work (which updates a cell in the first workbook from the second workbook using the variable thisWbName instead of the actual name of of the workbook) but I don't know the correct way to get Excel to understand the variable thisWbName instead of the word.
Workbooks("~Dog Training Reports & Handler Information").Sheets("Dog and Handler Data").Range(cell).Offset(0, 5).Formula = "='[(thisWbName)]Overview'!$E$28"
Any ideas please.
Workbooks("~Dog Training Reports & Handler Information").Sheets("Dog and Handler Data").Range(cell).Offset(0, 5).Formula = "='[(thisWbName)]Overview'!$E$28"
Any ideas please.