Converting Application.ActiveWorkbook.Path to Application.ActiveWorkbook.FullName in specific line of VBA

[SkywardPalm]

How should I go about converting this path to a dynamic path with file name that could be changing.

activeWorkbookPath = "'" & ActiveWorkbook.Path & "\[Variance Analysis Template v5.xlsm]temp_data'!R1C1:R" & LastRowCurrent & "C3"

I've read that I can use

Application.ActiveWorkbook.FullName

to accomplish this, but am not sure how to convert this specific line of VBA to incorporate it with the other specifics within the line.

 

[Dan_W]

Hi. I wouldn't use ActiveWorkbook.FullName in this instance because it includes the directory path as well, which you've already captured in the above formulation with Activeworkbook.Path. Instead, I'd suggest just replacing the file name part above with ActiveWorkbook.Name as follows:

activeWorkbookPath = "'" & ActiveWorkbook.path & "\[" & ActiveWorkbook.Name & "]temp_data'!R1C1:R" & LastRowCurrent & "C3"

Note that this retains the temp_data sheet name, if that's what you're intending.