I did some research on this, and I don't believe that it is possible to change the name of the excel file without saving it. Have you checked to see if your PDF converter allows you to change the default savename option? Maybe to the sheet instead of the filename? If so, that's an easy change in the code without saving anything. The only other option is to somehow reduce the size of your file so that your save takes place in a reasonable time. Try removing all formating prior to doing the save, this might help reduce the time invovled.
HTH
Cal





by: flickimp1717Posted on 2009-07-03 at 09:35:48ID: 24773353
Hi Any help please?