RE: [Talk] DataStation and VB 6

[Roger Tack]

Corinna,   I tried what you suggested.  Removed the reference to BostonDataStation, filed the script, selected the reference BostonDataStation using the Browse button. The DataStation now works in my VB6 script. How strange that the Browse Vs. clicking the box made the difference.   Thanks.   Roger Tack Sr. Programmer/Analyst St. Joseph Regional Medical Center 208-799-5721 -----Original Message----- From: Corinna Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 12:55 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] DataStation and VB 6   Roger, I am pasting in code from a test vb6 project, I have tested it and it works, the only thing I can think of is that perhaps you did not reference the DataStation.exe object in the project's references. Please double check this. If you are still having an error please display err.description and let me know what the actual error is. Please give me a call if you need assistance with this.   Dim D As New DataStation Sub Scripts() '     If DoScript("Boston DataStation") Then myScript1 End Sub Sub myScript1() D.Open_ "C:\Bss65\MySamples\LoadExcel.xls", ftExcel D("fStatus") = "" Do     tstField1 = D("1")     D("fStatus") = "Done"     D.Next_ Loop Until D.EOF End Sub   Thanks, Corinna Robertson   Boston Software Systems [EMAIL PROTECTED] www.bostonworkstation.com The Essential Tool for Healthcare Integration  866-653-5105 x 8 603-598-5122     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Tack Sent: Tuesday, March 02, 2004 3:04 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] DataStation and VB 6 Rich,   I have tried:   Dim D as New BostonDataStation  and Dim D as BostonDataStation and Dim D as New DataStation and Dim D as DataStation   I have had these defined in the declarative section as well as the sub routine.   The error happens every time the only difference is how quickly.     Roger Tack Sr. Programmer/Analyst St. Joseph Regional Medical Center 208-799-5721 -----Original Message----- From: Rich McNeil [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 5:07 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] DataStation and VB 6   Try:        Dim D as New DataStation   Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com       From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Tack Sent: Monday, March 01, 2004 6:23 PM To: [EMAIL PROTECTED] Subject: [Talk] DataStation and VB 6 Has anyone been able to get the DataStation to work in VB 6.0 not VBA?   I’m getting the error: Expected user-defined type, not project.   I have the BostonDataStation checked in References I also have the statement Dim D as New BostonDataStation in the sub routine.   Any ideas?   Roger Tack Sr. Programmer/Analyst St. Joseph Regional Medical Center 208-799-5721   NOTE: This e-mail message may contain information that may be privileged, confidential, and exempt from disclosure. It is intended for use only by the person to whom it is addressed. If you have received this message in error, please do not forward or use this information in any way. Delete it immediately, and contact the sender as soon as possible by the reply option or by telephone at the telephone number listed (if available). Thank you. NOTE: This e-mail message may contain information that may be privileged, confidential, and exempt from disclosure. It is intended for use only by the person to whom it is addressed. If you have received this message in error, please do not forward or use this information in any way. Delete it immediately, and contact the sender as soon as possible by the reply option or by telephone at the telephone number listed (if available). Thank you.