Filenames and changing from 1 wrbk to another

[Zebadiah]

I'm writing a macro that will let me export data from one file into a template file, but the source file name will change each time.

How do I pass the workbook filename to a variable so that I can call the variable in workbook.select?

 

[acron]

Try something lik ethe following :

Dim strWBName As Srting
strWBName = ThisWorkbook.Name,

or if you want the full path,
strWBName = ThisWorkbook.FullName

regards