Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open workbook in the same Excel app
ToolsOptionsView
Windows in Taskbar -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Jeff Armstrong" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |