Worksheet Reference Returns Type Mismatch Error when Using Network Drive

Hi all,

I have a series of macros used for data processing that uses various folders/files. These macros all work fine on my computer. I am having an issue when I move the files to a network drive mapped to a user's computer and run the macros from the user's computer. The type mismatch error is returned on the first code that would set a workbook such as the last line in the code below. This happens on every macro. All of the folder and file structures/names look exactly the same, the only differences are the user has Excel 2010 and I have Excel 2013 and the new filepath being on a network drive. The user has full access to the drive. The updated filepaths are being input correctly. Thanks for the help.

Please Login or Register  to view this content.

you might want to try

Please Login or Register  to view this content.

Not sure if it will solve your problem as I can't test it here, but worth a shot.

On second thought that won't work...
what about just

Please Login or Register  to view this content.