I am experiencing issues related to the thread below. I have used both the URL (https) and network addresses (\\server\...) and am experiencing the same problems.
Users are able to save 2 or 3 times normally and then they receive
Getting_List.jpg
The box never goes away and when you cancel, the code gives 1004 error on the saveas command.
I have added a 3 second pause before the save command as suggested by an internal IT guy and am using the FileFormat attributes on all saveas commands.
http://www.excelforum.com/excel-prog...ent-types.html
Code is below...
Please help.
Bookmarks