|
Linda, As a sanity check, I successfully tried: Sub myScript3() Dim D1 As New DataStation, d2 As New
DataStation D1.Open_
"C:\Bss6\Learn\DataStation\Samples\Excel.xls", ftExcel D1.Next_ d2.Open_
"C:\Bss6\Learn\DataStation\Samples\ExcelLeft.xls", ftExcel d2.Next_ End Sub I was able to access D1 and D2
variables. However, the results aren’t visible to the
WorkStation. Also there may be issues with opening the same Excel file
twice. Any help? Rich McNeil 866 653 5105 x813 -or- 508 318 5327 www.bostonworkstation.com From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Linda Ralston Hi, I am trying to open 2 spreadhsheets at the
same time. Using Version 8 BWS. I've tryed following the directions I
found below and as soon as I change the name of the "D" datastation
object to something else it no longer reads the data. I'm using a D1 and D2. I've added
DIM D1 as new Datastation and Dim D2 as new datastation to the General
Declarations. Then I've changed all the D's to either D1 or D2 where
necessary. Is there a trick to this? Linda Linda Ralston, ISP -----Original Message----- You will need to create another
datastation object Dim DD (or whatever you name it as new
datastation Then any statements that currently use
d.open etc. (the d.) you will replace with the name of the new object You can use the datastation and then go in
and replace all of the object names or you could build manually Thanks, Corinna Robertson The Essential Tool for
Healthcare Integration 866-653-5105 ext. 5 508-653-5105 |
Title: Dialog Boxes in Meditech
- [Talk] Data Station question, opening two files at the same ... Roy Hayward
- RE: [Talk] Data Station question, opening two files at ... Corinna
- FW: [Talk] Data Station question, opening two files at ... Linda Ralston
- RE: [Talk] Data Station question, opening two files... Rich McNeil
