Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default problem with macro opening second instance

Hi all..

I have a series of macros that
open a second instance of Excel and
transfer data from a .txt file into the first instance.
When these macros are run individually they
run fine. When I combine the macros into a
"run-all" macro it opens the wrong workbook,
even tho the path and workbook name is hard-coded.

any ideas ?
thx
Bob
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default problem with macro opening second instance

The code would help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Wenner" wrote in message
om...
Hi all..

I have a series of macros that
open a second instance of Excel and
transfer data from a .txt file into the first instance.
When these macros are run individually they
run fine. When I combine the macros into a
"run-all" macro it opens the wrong workbook,
even tho the path and workbook name is hard-coded.

any ideas ?
thx
Bob



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel docs opening in their own instance - not all in one jcsfny Excel Discussion (Misc queries) 3 September 23rd 08 07:30 PM
opening a new instance of Excel gb4 Setting up and Configuration of Excel 0 April 10th 08 04:48 PM
keep Excel from opening 2nd instance widman Excel Discussion (Misc queries) 0 April 30th 06 01:35 PM
Keep Excel from opening new instance widman Excel Discussion (Misc queries) 7 October 1st 05 01:53 AM
Opening multiples instance of Excel VooDoo Excel Discussion (Misc queries) 1 March 9th 05 03:38 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"