Hi VBA Programmers.

I have a macro, where in it will open a form when i click on Activex control button in the sheet and the form have a combo box which will list all the files in the path (mentioned in Cell C8) of same workbook. The macro is executing in the local drive for example in C:\ without any issues. However, when i changed the path from C:\ to some network path, it throws me a error as

Run-time Error '1004':
Microsoft Excel cannot access the file
'\\networkpath\filename'. There are several possible reasons:

The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a

Any help here is really appreciated.