XLT needs to pull data from a DBF in current subdir 1

[JCreamerII]

I have an XLT that needs to pull data from a DBF located in the subdirectory where it gets opened. It appears to try to find the DBF in another subdirectory. I have to put this XLT in a number of subdirectories so the users can just open it and have the resulting DBF populate the template. I assume there must be a way to use a macro to call out the current path?

Thanks,

Jim C.

 

[PHV]

a macro to call out the current path
MsgBox ThisWorkbook.Path

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JCreamerII]

PHV,

Thanks for the info, that cleared up that issue. Still working a couple of issues out, but the actual path is getting set properly.

Thanks,

Jim C.