I am creating a userform that will prompt for the .xls filename to be used in another macro.
The code below works on my local drive.
If I want it to go out to the company's network, it says path not found.
However, if I go into Excel and go File / Open, and cut and paste the same network path, the path is found and files displayed.
Since Excel itself will recognize the path,it doesn't seem like it should be a permissions problem.
Calling code:Works:
Call ListFilestoListBox("C:\Users\xxxx\Documents\Company\Excel/", False)
Does Not work:
Call ListFilestoListBox("http://xshare.xxx.com/Groups/Operations/XXXInfrastructure/Weekly Data/", False)
Subroutine in Userform
Bookmarks