Thanks, here is what i have. This is off a shared drive. It seems to be only affecting one user. Everyone else is fine. FYI, i change the path names and file names for this post but it is essentially just like this.
RUN-TIME ERROR '1004'; Method 'SaveAs' of object '_Workbook' failed
We will be doing parallel integrity testing for a new system for several months and I'm trying to make it easier by programmatically generating a text file from an excel spreadsheet which is shared. My understanding is that you may run code from a shared spreadsheet, but some options are disallowed. I did not believe 'SaveAs' to be one of them, but...
I do not have the problem when the workbook is not shared, and since I can't step through the code (in shared mode) to determine exactly where it's failing, I am assuming it is here when I try to output the file:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.