Runcommand for Analyse with Excel

[startacc]

Hello all!
In the pre '97 version of Access you could use DoMenuItem to open Excel (Office Links, Analyse with Excel) so what happened to this command with Runcommand. OutputtoExcel still exists but does not open Excel. Any ideas how to open Excel from Access with a report open?

Thanks
Claire

 

[garysc]

Hi, have you tried the Shell command in Access VB? There may be a more appropiate way as I am not that familiair with Access, but this does open a particular excel spreadsheet. Regards Gary

 

[B827]

This code will transfer a table / query into a folder then open the file in Excel (either an open session or opening Excel)

Dim mno As String, TemplateFile As String
Dim XLApp As Object
TemplateFile = "C:\My Documents\AccessData.XLS"
On Error Resume Next 'ignore error if Excel not running
Set XLApp = GetObject("Excel.Application&quot
If Err <> 0 Then
Set XLApp = CreateObject(&quot;Excel.Application&quot
End If
On Error GoTo 0
XLApp.Visible = True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, &quot;OneBillSummary&quot;, TemplateFile, True
XLApp.workbooks.Open TemplateFile

 

[tlbroadbent]

Application.RunCommand acCmdAnalyzeTable Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com