Launching Excel from Access

[Rendezvous]

I noticed a similar posting in November, but I do have a more specific question. I know that I can launch excel from a line of code within Access, but is there a way to launch Excel hidden so that the user does not see Excel open, format a report, print it to a pdf and then close, returning to Access? If not, what's my next best choice, run this process minimized?

thanks in advance,
Doug

 

[bat17]

Welcome to the board.

Normally when you open XL by code it is not visible unless you use code to make it visible so you should be OK.

HTH

Peter

 

[mdmilner]

Here are some things to research for you. Obviously you don't have to use the object variable names, but I wanted to include the Declarations/Set commands as reference.

Dim objXL As Excel.Application
Dim objWkb As Workbook
Dim objSht As Worksheet
Dim strFile  As String

strFile = "path to file include drive designation"
Set objXL = New Excel.Application
Set objWkb = objXL.Workbooks.Open(strFile)
Set objSht = objXL.Workbooks.Add(strFile)

objXL.Visible = True
objXL.DisplayAlerts = False
objXL.UserControl = True
objWkb.Close True, strFile
objXL.Quit

.Visible makes the Application visible
.DisplayAlerts is a method to suppress or enable xls dialog boxes
.Usercontrol - default is False, needs to be True to save changes and also before any .Close/.Quit methods

Mike