Excel SaveAs not working

I am running an Excel 2007 vba program from dos (using cscript). The program opens an Excel file that has a fileformat of txt. It uses the data in the file to create two charts for each day. So far everything works except when saving the file. I would ultimately like to save it back with the same name, but needing to use a different fileformat so that the charts will display. I have tried several combinations of the saveas command. The weird thing is, when I use the := in the saveas command, the program doesn't even open Excel - but when I use only = in the command it opens the file and creates the charts. Here is the program:

Please Login or Register  to view this content.

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.