Is it possible to open Microsoft Excel from VB and automaticaly open a file in it?
I hope you know what I mean
------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.
Printable View
Is it possible to open Microsoft Excel from VB and automaticaly open a file in it?
I hope you know what I mean
------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.
yes here is the code
using early binding
Dim objexcel As Excel.Application
Set objexcel = New Excel.Application
objexcel.Workbooks.Open ("f:\dep2.xls")
objexcel.Visible = True
using late binding
Dim objexcel As Object
Set objexcel = createobject("excel.application")
objexcel.Workbooks.Open ("f:\dep2.xls")
objexcel.Visible = True
Thanx Manish