starting Excel from Access

[JeroenNL]

Hi there,

Inside an Access macro, I start Excel with this line:

d:\blabla\excel.exe "e:\blabla\myworkbook.xls"

The workbook contains various worksheets. I want to be able to show one of these sheets when the workbook is opened. I thought about writing macros in the Excel workbook and call them from the commandline like this:

d:\blabla\excel.exe "e:\blabla\myworkbook.xls /m mymacro"

But this doesn't seem to work. How can I achieve what I want?




Bye,
Jeroen

A 3d level editor in Delphi

http://www.gamefortress.com/~delgine

 

[RamziSaab]

This is from an old thread where i asked nearly the same question (credit goes to xlbo)

Private Sub Command0_Click()
Dim objExcelApp As New Excel.Application
Dim objExcel As Object
'create Excel
Set objExcelApp = New Excel.Application
'open file
Set objExcel = objExcelApp.Workbooks.Open("PATH OF UR FILE&quot
objExcelApp.Visible = True
objExcelApp.Sheets("NAME OF UR SHEET&quot.Select
Set objExcel = Nothing 'clears memory

End Sub

 

[JeroenNL]

Excellent, that did the trick. Thanks to both Xlbo and yourself, RamziSaab.

Btw, I added

Set objExcelApp = nothing

to the code.

Bye,
Jeroen

A 3d level editor in Delphi

http://www.gamefortress.com/~delgine