Macro - Set 'GetOpenFileName' to default NETWORK location

[brad999]

Morning,

I have the following code below that prompts a user to select a file from the active workbook drive and directory. However, when the active workbook is placed on a network drive, runtime error '5' comes up. Or alternatively, if Chdrive/Chdir is removed, the code can be run, but the default location for the user prompt is set to where the last open file location was. Id like the default user prompt directory to either be the current directory of where this workbook is placed on the network, or specified in the code as '//network/share' as this location does not change.

Can anyone help with this? Thanks in advance!

Please Login or Register  to view this content.

[slx]

ChDrive and chDir cannot be used for network paths.

You can either map the path to a drive and access it that way, or you have to create a function to pull it.

[brad999]

How can I create a function to pull it exactly? Thanks for the help!

[robert12345]

Does anyone can help with this problem ?

Thank you ,
Rb