We do this in our Excel demo script with a: Workbooks(1).Save
Since this is probably a new file you might try: Workbooks(1).SaveAs filename which has a lot of additional parameters to indicate how you want to save it. Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zimmerman, Scott Sent: Friday, November 07, 2003 1:05 PM To: '[EMAIL PROTECTED]' Subject: [Talk] Saving a .txt type file into an excel using object code commands Hello everyone, One of my scripts imports a text file into excel, parses it and saves as an .xls. I do the saving portion just as a user would however, I was wondering if anyone is doing this by calling the object commands. thanks in advance, Scott Zimmerman, LIS Analyst UMass Memorial LIS Department Phone: 508-334-7237 Pager: 508-426-2178 > "The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, transmission, re-transmission, dissemination or > other use of, or taking of any action in reliance upon this information by > persons or entities other than the intended recipient is prohibited. If > you received this in error, please contact the sender and delete the > material from any computer." > >
