Excel won't open maximized from URL

[jdanton]

I have a hyper link to an Excel file on my webpage. The problem is when Excel opens neither the app nor the file are opened in a maximized state. Is there a way for me to control the state Excel opens in by passing a parameter of some sort or is there a setting I don't see in Excel to tell the file to always open maximized when opened from a browser? It opens maximized when I just open the file by itself (not from the url).

[Bird_FAT]

Originally Posted by jdanton

I have a hyper link to an Excel file on my webpage. The problem is when Excel opens neither the app nor the file are opened in a maximized state. Is there a way for me to control the state Excel opens in by passing a parameter of some sort or is there a setting I don't see in Excel to tell the file to always open maximized when opened from a browser? It opens maximized when I just open the file by itself (not from the url).

try adding

Option Explicit 
 
Private Sub Workbook_Open() 
    Application.WindowState = xlMaximized 
End Sub

to the 'ThisWorkbook' Microsoft Excel Object in the VBA window (it should be visible in the tree on the left and the icon is the same as an excel document)

Then it will Maximize the Excel app upon opening!


Bird

[silly_2b_me]

Originally Posted by Bird_FAT

try adding

Option Explicit 
 
Private Sub Workbook_Open() 
    Application.WindowState = xlMaximized 
End Sub

to the 'ThisWorkbook' Microsoft Excel Object in the VBA window (it should be visible in the tree on the left and the icon is the same as an excel document)

Then it will Maximize the Excel app upon opening!


Bird

And if this doesn't work? I even added in a second command (after the above one) in the workbook_Open procedure (the one from the Help Creating a VBA Procedure for the open event in a workbook)
The second one runs, but the suggestion above doesn't appear to work when coming from a link from SharePoint?
Any other ideas?