View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default opening excel files from access 2003, win xp, office 2003

Paste this into the thisworkbook module of the excel file
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub

"Nugimac" wrote:

I am opening excel files from access using application.followhyperlink.
The excel file always opens with the workbook restored down.
Is there any way to open the file with the workbook maximized using
application.followhyperlink from access?
One annoying thing is that after using application.followhyperlink from
access, after I have closed both access and excel, the next time I open excel
from the desktop, it opens with the workbook restored down.

Thanks