SteveL13
asked on
How open Excel hyperling from Access form maximized
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
--Steve
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?
ASKER
Yes. Doesn't help.
if your file is in read-only attribute then it will not maximized.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<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
<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