GetFile - Set default folder using network path

Hi All,

I'm trying to code a macro that prompts the user to select a file to open, but I'd like it to default to a certain folder and network path.

for instance,

ChDrive "Z"
ChDir "Z:\New Folder"

Is an example of what I want, but not all users have the network mapped as Z:\, so I'd ike to use the path:

\\thisserver.example.testing.com\something\somewhere\here\

Can this be done?

Thanks!

I believe ChDrive and ChDir only work for local and mapped drives. See https://social.technet.microsoft.com...ba?forum=excel

You're welcome.