Greetings,
I suspect you may be doing is opening the same spreadsheet and using different worksheets and your D.Open commands are not specifying a BDS file. The worksheet to be opened is stored within the BDS file. Each time you use the DataStation toolbar to open the file - you are modifying the "default" BDS file - the one that is named after the spreadsheet. What you need to do for each worksheet you need to script from: 1. Use the toolbar to open one of the worksheets. 2. Set up a DataStation report (if desired) 3. Find the newly edited BDS file - it will be in the same directory as your spreadsheet and will be named "your spreadsheet name".XLS.bds 4. Rename this to something you will remember - WorkSheet1.bds 5. Reference this newly "created" bds file within your open command: D.Open "..my.xls",ftExcel, ".worksheet1.bds" And this would cause the script to use the BDS file that specifies to retrieve worksheet #1 D.Open "..my.xls",ftExcel, ".worksheet2.bds" Etc. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx> up for my weekly webinar! LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Brian Sent: Thursday, July 31, 2008 11:03 AM To: '[email protected]' Subject: [Talk] Spreadsheets Good Morning. Working with excel and BWS is not much of a problem. However, I do have one small problem. I know you can have BWS open an excel document to a certain worksheet if you use the Datastation open file command. But, is there a way to do this with a rule with out having to use the datastation toolbar to do so? Is this something that can only be done with the BDS file? Thanks. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [EMAIL PROTECTED]
