FollowHyperlink

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

i am using Application.FollowHyperlink to open an Excel file. It does open
however, it always open with the workbook in a restore size (I'd don't even
think it is the true restore size of the workbook either). This only happens
when I open it this way. When I go an open the file manually is is
maximized. Is there a command variable or something I can do so that once
opened it will maximize the active workbook to avoid the user having to do so
everytime they open the file?

Thank you,

QB
 
Hi,
I asked this question myself some years ago. I have since given up hope of
ever finding a way round this.
Sometimes, even after I have closed both the access database and excel, when
I open excel again and select a workbook, it is also restored down.
It annoys me sometimes. If anyone has an answer, I would love to hear it.

PS I also asked this several times on the excel group, but I never got a
sensible answer - it seemed as if the people there did not even understand
my problem.


Jeanette Cunningham
 
What baffles me even more about the whole thing is that I even added

ActiveWindow.WindowState = xlMaximized

in the workbook_open even but it doesn't work. If I do it manually in the
immediate window it maximizes the workbook. But it is like access it
overruling it.

If I ever find an answer I will post it back!

QB
 
Yes,
I tried coding solutions too.
As it now even happens without my opening access first, I think it is
something to do with Excel - although it doesn't make sense.
I never saw this behavior before I began opening excel while access was
open - using either follow hyperlink, automation, or Tools | Anaylze it with
excel.

Now it occurs with follow hyperlink, automation, or Tools | Anaylze it with
excel, and even just opening a new workbook in Excel while access is closed.

Jeanette Cunningham
 
Shell <Path>,<Windowstyle>

Type shell and press F1 to get help file to open to see the different
Windowstyles.
 
I don't understand it, but the shell command works for me and does have the
issue that FollowHyperlink has been exhibiting.

Thank you,

QB
 
Back
Top