How to open spreadsheet from workbook

[daffelito]

Hi, i have this button within Access that opens a workbook in excel. I have this code.

Dim stAppName As String stAppName = "Excel.exe c:\workbook.xls " Call Shell(stAppName , 1)

What i want is to ad an command to open a specific spreadshhet within that workbook, how do i do that?

[trevor glover]

Hi what you need to do in your dim statement is specify the sheet name as follows:

dim wkbk as excel.application
set wkbk = createobject("excel.application")
with wkbk
.visible=true
.workbook.open ("The path and name of the workbook")
.sheets("The name of the sheet to activate").select

end with

Enjoy

[NeoPa]

Check out Application Automation.