The following works well in local share network drive. However, when the file is transfer over to the open network (view from internet), the following excel file will show error: Run-time error: 52. Bad file name or number.
I have change the fpath to the following instead of fpath = ThisWorkbook.pa th & "\" but still having the same error.
Can anyone help? which code should I amend?
---------------------------------------------------------...
Sherrin
Last Activity: Mar 1 '16, 12:47 PM
Joined: Feb 29 '16
Location:
-
How to fix Run-time Error 52 for Microsoft Excel 2003?
Last edited by zmbd; May 7 '16, 07:23 AM. Reason: [Rabbit{Please use [code] and [/code] tags when posting code or formatted data.}][Z{altered code tags to show procedures}]
No activity results to display