VB not VBA?
Posted by Gary Hewitt-Long on January 06, 2002 7:34 AM
I would like to create a stand alone application using Visual Basic 6.0 as opposed to Visual Basic for Applications that edits and controls an excel file.
Is this possible?
All machines that would run the application would have excel 2000 installed on them.
In VBA the following code would put the value of of text1 text box into cell A1 when Command1 was clicked:
Private Sub Command1_Click()
ActiveCell.Formula = Text1.Value
How do I get VB to do this?
.Value isn't available after Text1 in the last line.
Also Windows("Book1.xls").Activate doesn't work??