opening excel files from access 2003, win xp, office 2003
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 |
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 |
opening excel files from access 2003, win xp, office 2003
Hi Mike, thanks for your help. I should have made it clearer that I need this
to happen automatically because the database will be used by others who can't use code. The worksheet is created on the fly as the data is exported from access. The path and filename are saved and then application.followhyperlink strPath is called. I need a way to maximize the worksheet window, the actual excel window is already maximized. The worksheet opens at a small size within a maximized Excel window. My testing shows that it is the code - - - - - - - application.followhyperlink strPath - - - - - - - that causes the worksheet to open restored down to a small size insode a maximized excel application window. If anyone can help with this, it would be much appreciated. "Mike" wrote: 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 |
All times are GMT +1. The time now is 12:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com