Excel won't open maximized from URL

jdanton · #1 03-06-2009, 11:17 AM

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 · #2 04-12-2009, 09:33 AM

Quote:

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

Code:

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 · #3 09-24-2009, 08:11 AM

Quote:

Originally Posted by Bird_FAT

try adding

Code:

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
Open DOCX in Word 2007 & Open DOC in Word 2003	wilde_37	Office	0	02-03-2009 12:37 AM
"open" or "open using" option not availa	ccd	Outlook	0	09-22-2006 01:23 AM
Excel document won't open from Outlook	shinobi89	Office	0	06-01-2006 02:10 PM
How do I use an Excel form to populate and Excel spreadsheet	apostht	Excel	0	05-21-2006 11:17 AM