View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Armstrong Jeff Armstrong is offline
external usenet poster
 
Posts: 20
Default How to open workbook in the same Excel app

Hello,

I have a list of hyperlinks to other Excel files in column
A and I have a macro that opens each file through a loop.
The thing I don't like is when the file is opened, it
opens another Excel app at the bottom of the taskbar. I
have the Screenupdating = False but this doesn't prevent
this. Is there a way to open the file in the current
window? Below is the code I am currently using.

Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

Any help would be greatly appreciated.

Thanks,
Jeff