Scott, If you are using the objects then it is oWrkBook.Saveas filename, I do believe Brian is doing this.
-----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." > >
