Application.Workbook.Path issue

[acarrigan]

I am moving an application from a PC to Server
I have a macro that runs the Application.Workbook.Path command.
On the PC, I get this result: H:\SAPReports
On the Server, I get this result: \\merfile-01\is\SAPReports
Even crazier to me. I've been running the macro on the server for weeks without issue.
I only started getting different results today.
What is the "standard" result supposed to be?
Drive Path or UNCPath?

 

[Micron]

AFAIK you can't go wrong using a UNC path. Drive letters are only volume labels on a drive. You can have H mapped to one server, and a colleague can have H mapped to a different server. So how do you code for each one referring to the same path to a file/reference? By using a UNC path - then the drive letter doesn't matter. So if you used the server name/path in both scenarios there would be no need to change anything wrt file paths when you publish your app to where everyone can use it.

 

[acarrigan]

Just to clarify the command I am dunning is Application.ActiveaWorkbook.Path

 

[acarrigan]

Thanks for the reply perhaps I wasn't clear enough on the problem. I agree UNCPath is the best course and that is what I am trying to do.
My question is why does ActiveWorkbook.Path return the drive letter on one machine and on another machine the UNCPath.
I have already addressed the issue by testing what is returned and converting to the proper UNCPath.
Now just curious as to how ActiveWorkbook.Path can return different results - machine based? excel version?
What's worse one day it was returning the drive letter the next day the UNCPath.
I may ne naieve but doesn't seem like that should happen.
Thanks

 

[Micron]

Sorry, I don't know the reason, especially if it flip flops on the same pc/server. If you're using the result in code I suspect it would not matter what was returned if you passed the string to a variable - unless it matters to you if it starts with H or not. Perhaps test using ServerName. I would have tried that before suggesting it, but I have no access to a network.