VB 6

[Varne]

Hello

Everyone says do it on VB 6 instead of VBA. I like to try. Can someone help
me to start? All I want now is to select cells(1,1) in an Excel workbook
through VB 2008 Express edition. I have given below the VBA equivalents.

Opening an Excel file.

Opening Visual Basic Editor

Inserting a module.

Write the following in it;
Sub Testing ()
Workbooks("Book1").cells(1,1).select
End Sub

Running Testing.

Thank You

Varne M

 

[Rick Rothstein \(MVP - VB\)]

Code written for VB6 will more than likely not run in VB2008 (part of
Microsoft's .NET world). When Microsoft introduced VB2008, they broke
backward compatibility with the "classic" line of VB. There are things you
are supposed to be able to do to make some VB6 code run inside VB2008, but
not being a .NET programmer, I am not able to tell you how to proceed. You
could ask in one of the .NET newsgroups (they all have "dotnet" in their
names), such as this one...

microsoft.public.dotnet.languages.vb

Rick

 

[Varne]

Hello Rick

Sorry for replying late. I have just downloaded a version of VB 6 compiler.
Could you just show me how to do the following;

Sub Testing ()
Workbooks("Book1").cells(1,1).select
End Sub

Thank You
M Varnendra

 

[Lashio]

Try this

Sub Testing()
Workbooks("Book1.xls").Activate
Cells(1, 1).Select
End Sub

 

[Varne]

Hello Lashio

Could you please tell me how to access the VB 6 code writing space? For VBA
I open an Excel workbook and go to the space through Visua Basic Editor and
then insert a public module and on there I write my codes? Sorry this is the
first time I am going to try VB 6. Thank You.


Thank You

Varne M