How open Excel hyperling from Access form maximized

SteveL13
SteveL13 used Ask the Experts™
on
I have a hyperlink on an Access form that opens an Excel file.  But the Excel file does not open maximixed.  Is there a way to make it open maximized?

--Steve
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
might be a silly answer but worth a shot, a lot of ms applications remember what state they were last closed in and will re open in the same state.  have you tried opening the file (not through access) and closing it maximized and then trying it from access?

Author

Commented:
Yes.  Doesn't help.
if your file is in read-only attribute then it will not maximized.
Top Expert 2016
Commented:
you have to open the excel file using Shell

dim xlPath as string
xlPath= "c:\folderName\yrExcel.xls"

shell chr(34) &  SysCmd(acSysCmdAccessDir) & "Excel.exe" & Chr(34) & " " & Chr(34) & xlPath & Chr(34), vbmaximizedFocus

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<No Points wanted>

<I have a hyperlink on an Access form that opens an Excel file.>
Hyperlinks cannot really have open "Options"
This is why capricorn1's post contains no hyperlinks.

In your situation, (AFAICT) there is no need for the hyperlink.

You can also do this through a Shortcut and setting the "Run" option to Maximized, ...but capricorn1's post is fairly straightforward and should work well

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial