New topic: Excel - Opening and Saving Files
<http://forums.realsoftware.com/viewtopic.php?t=24928> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message mandala Post subject: Excel - Opening and Saving FilesPosted: Thu Oct 23, 2008 10:36 am Joined: Wed Jun 25, 2008 7:41 am Posts: 5 Location: Ottawa, Canada I have an application that parses some XML into a Listbox and then writes the data to a NEW MS-Excel spreadsheet. So far, so good. Now I want to choose an existing Spreadsheet file by filename and write the data to this file and then save the spreadsheet with a new filename (invoke SaveAs). How do a OPEN a specific spreadsheet using the excelApplication class? How do I SaveAs to a specific filename using this same class? _________________ Kenneth Matthew McGrath Otawa, CANADA Top mrebar Post subject: Re: Excel - Opening and Saving FilesPosted: Thu Oct 23, 2008 4:57 pm Joined: Wed Feb 15, 2006 1:30 pm Posts: 2229 Location: U.S.A (often) Spokane, Eugene, Pago Pago Quote:How do I SaveAs to a specific filename using this same class? Code:excel.ActiveWorkbook.SaveAs("Macintosh HD:Users:someuser:Desktop:Workbook111.txt",Office.XLTEXTMSDOS) or Code:Excel.Save... Quote:Now I want to choose an existing Spreadsheet file by filename Code:Excel.GetOpenFilename Michael Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 900 classes with 18000 functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v8.1. <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml> [email protected]
