Anyone have sample code for reading/editing/writing excel spreadsheets?

 

Terry M Evans, CPHIMS

Chief Information Officer

985 435-4820

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Rich McNeil
Sent: Monday, October 20, 2003 8:59 PM
To: [EMAIL PROTECTED]
Cc: 'Linda Ralston'
Subject: RE: [Talk] Boston Software and VBA Forms

 

Linda,

 

I have good news and bad news.  The good news is, you can add Microsoft Windows Common Controls to a form in VBA just as you’d add it to a VB project’s UserForm object (Insert the UserForm and give it focus.  It takes all the usual components this way.  The bad news is that VBA uses “Forms2” a more “advanced” version of VB’s forms.  VBA’s Forms2 is quite different from VB’s, and I think it’s pretty bad.  You’ll probably have to start your Form design from scratch although a lot of your code can be transported between them.  Two major differences…no Timer component and an odd reliance on Modal forms. 

 

Sorry, I missed your message.

 

Rich McNeil

Boston Software Systems

866 653 5105

www.bostonworkstation.com

 

-----Original Message-----
From: Linda Ralston [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:59 PM
To: [EMAIL PROTECTED]
Subject: Boston Software and Visual Basic

 

Hi there.  I sent an e-mail through [EMAIL PROTECTED] and wasn't able to get help on my question.

 

I'll rephrase the question. 

 

When I use Boston Workstation the Visual Basic that comes with it is limited. VBA  rather than Visual Basic.  I am used to using Visual Basic and have written programs that access Microsoft Windows Common Controls.  Specically I am trying to allow the user to open the "File Open" dialog box to pick the file they need to work with.  I can't figure out how to do this with VBA?  Is this a stupid question?

 

Can you help me?

 

By the way,  please pass on a Thankyou to your company for the cookies that were sent to our office from Boston Workstation.  They were very much appreciated.

 

Thanks.

 

Linda Ralston, ISP
Applications Analyst
Peace Country Health
Grande Prairie, AB
Canada

Reply via email to