VBA: Load Excel in background from VBA

pkwu · Oct 21st 2003

Hi,

I need to load an existing Excel file in background using either VBA or VB, which means user will not be able to see Excel. Also, I need to be able to access the cells in Excel as well.

Any help will be appreicated.

Thanks

Pesky Weasel · Oct 22nd 2003

pkwu,

try this:

Code

Option Explicit


Sub loadXL()


Dim obXL As Object


Set obXL = New Excel.Application
obXL.Visible = False
obXL.Workbooks.Open "C:\Documents and Settings\Administrator\My Documents\book1.xls"


End Sub

Display More

pkwu · Oct 23rd 2003

Hi,

I am sorry I wasn't clear on my question. The Excel file I need to load have some macro on it, it always makes the screen popup even though I set the visible = FALSE. Any help will be appreicated. Thanks

XL-Dennis · Oct 23rd 2003

pkwu,

To override the security settings is not recommended at all, especially if You plan that other will take part of Your solution.

You may consider to set the security level to low in XL as standard or re-write the code so it exist in Your Word-project and remote-control the actions taken in the XL-workbook.

Kind regards,
Dennis

pkwu · Oct 24th 2003

Hi Dennis,

I am not planning to change any setting in the Excel because I got no control on it. This Excel file is coming from 3rd party. What I am planning to do is to use Word to call this Excel file. However, the problem is that that Excel file keep popping up (I believe the XLA keeps the Excel file visible all the time) even though I set the visible = FALSE on Word macro. My question is: Is there a way to suppress the Excel popup from Word Macro.

Thanks

Peter

Pesky Weasel · Oct 24th 2003

Peter,

Its a little hard for me to tell without seeing both your code and the .xla code.

Regards
Weasel

VBA: Load Excel in background from VBA

Participate now!

Share