VBA to VBasic6.0 
Author Message
 VBA to VBasic6.0

You probably know this already if you have written code to drive excel, but
there is a nice excel object model help file with a hot-image tree of the
full excel object hierarchy.

When I wrote code in VB five, I had to hunt around... I think it was maybe
either not installed by default from the Office CD, or was installed and
sitting in a directory, but with no shortcuts or indication it was there
until I found it.

But it was a nice visual map, as well as analytic tool with properties and
methods described.

have fun,
Dave Marx


>I've written some code with an Excel file and now I'd like
>to transform it as an ".exe" file.
>For exemple, VB6.0 doesn't know ActiveWorkbook.Sheets

>Is it possible ?

>Thank you for answering.

Mon, 20 Sep 2004 03:32:34 GMT  
 VBA to VBasic6.0


> Hi,

> You can call the Excel object model from VB (Excel has to be installed on
> the target machine).  To do this you add a Project Reference to Microsoft
> Excel (via the Project Menu).  You may then do anything from VB that you
> could have done from VBA.  The syntax may vary slightly, but not require any
> changes that should take more than a few minutes, I'd think.

Thats not true. The listbox in VBA has columns, VB not.
In vba you can init the multi colum lisstbox with

dim array(3, 6)
'fill array here, and than


Probably the syntax isn't perfect.

Mon, 20 Sep 2004 05:48:02 GMT  
 [ 2 post ] 

 Relevant Pages 

1. VBA to VBasic6.0

2. HELP!!!!!! Vbasic6


4. I Want to write a CD Ripper(convert to MP3) in VBasic6 - any clues how it's done

5. VBA 97 to VBA 2K/2002/2003

6. Access VBA Calling MSWord/Excel VBA?

7. VBA Analysis Tookpack- Excel In Access VBA

8. Access 97 VBA v Access 2K VBA - different ?

9. ACCESS VBA - why different from other vba?

10. convert vba 2000 to vba 97

11. Access 2000 VBA Handbook vis a vis Access 97 VBA Handbook

12. vba access vs vba excel (alguien sabe?)


Powered by phpBB® Forum Software