|
-
Nov 17th, 1999, 09:05 AM
#1
Thread Starter
Fanatic Member
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.
-
Nov 17th, 1999, 02:40 PM
#2
Lively Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|