ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with ActiveWorkbook

Mon
Apr 13
2009

VBA to show excel path name with server path?

Currently I am trying to have VBA paste the file and path to cell A1 of the current file I am using. The problem I keep having is that I get which includes the mapped drive letter instead of the server path:

H:\FILES-Excel\testbook001.xls

but what I need to get is the server name path instead i.e.

\\ServerXYZ\FILES-Excel\testbook001.xl…

Does anyone have code to do this?


Answer

You will need to UNMAP the server path, open the file and run the command that will give you the full path as you required

OR try this command, if you are not using it anyway

Path1 = ActiveWorkbook.Path

Try it

VBAXLMan

Monday 4/13/2009 9:35:21 PM

Tags

History