Excel won't open in full window.

[SHIPP]

I am working in Office 2003. I am trying to open an Excel spreadsheet through
Access. I am using the following code:

Application.FollowHyperlink Me.strImportPath


It only opens the top 2 - 3" of the spreadsheet. Does anybody know what
might be the problem?

Then once the spreadsheet is opened how do I reference a cell? The following
does not seem to work.

Range("D1").Select
dtePO = ActiveCell.Value

 

[Alex Dybenko]

hi,
if you use Shell execute - then you can specify to open window maximized:
http://www.mvps.org/access/api/api0018.htm

as for referencing cells - look at:
http://www.mvps.org/access/modules/mdl0006.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com