open excel

[cram]

using office2003

I want to open a specific tab in an excel application from access
What I did so far in my macro:
runapp excel c:\data\name.xls
This works fine, but excel always opens the last-used-sheet
As there are different types of calculations (different sheets), I would
always open the "marge"-sheet with this instruction.
I think this possibility exists, but I can't find how to write te correct
rupapp-link.

Thanks
Cram

 

[bhicks11 via AccessMonster.com]

Hi Cram,

FollowHyperlink "\path\to\workbook.xls", "SheetName!$A1:$A1"

Works like a dream.

Bonnie
http://www.dataplus-svc.com