ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting file path (https://www.excelbanter.com/excel-programming/400744-getting-file-path.html)

Bryan

getting file path
 
In a template, How can I get the full file path of a document?
I can get the document name and the template but, would like to get the path.

Thanks,
Bryan

RB Smissaert

getting file path
 
What is your code?
Can you do Fullpath?

RBS


"bryan" wrote in message
...
In a template, How can I get the full file path of a document?
I can get the document name and the template but, would like to get the
path.

Thanks,
Bryan



Jim Rech

getting file path
 
A workbook has no path until it is saved. The path of the templates folder
can by gotten from this :

Application.TemplatesPath

--
Jim
"bryan" wrote in message
...
| In a template, How can I get the full file path of a document?
| I can get the document name and the template but, would like to get the
path.
|
| Thanks,
| Bryan



Bryan

getting file path
 
I got it.
Using the following code in Normal.dot template
'
Dim fFname As String
With ActiveDocument
fFname = .Path
End With
'
Thanks,
Bryan

"RB Smissaert" wrote:

What is your code?
Can you do Fullpath?

RBS


"bryan" wrote in message
...
In a template, How can I get the full file path of a document?
I can get the document name and the template but, would like to get the
path.

Thanks,
Bryan





All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com