Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems Automating Excel

Status
Not open for further replies.
DerekAOE

DerekAOE

Programmer
Aug 16, 2001
19
0
0
GB
I am using VB to automate conversion of Spreadsheets to HTML files using Excel 2000. Problem is, when I've created my (hidden) instance of Excel using GetObject (complicated story, but using Shell then GetObject is the only way I could load the add-ins I need) if the user opens an xls file by double clicking it, Windows seems to grab my (hidden) instance of Excel to open it with, so the user see's my worksheets being opened and closed, etc.

Is there any way of stopping Windows grabbing my Excel instance?
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
63
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
183
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
312
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
83
Niki_S
Niki_S
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
101
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top