Excel won't open in full window.

  • Thread starter Thread starter SHIPP
  • Start date Start date
S

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
 
Back
Top