Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Interactions between Communicator and Excel causing Macros to stop

I have macros within many excel workbooks that open files on another server,
extract the data I want and save it in my "master" workbook. They take a
while to run because of network speed. I believe we've started to see an
interaction with Communicator in that when we send IM's when the macro is
running, the macro stops. Has anyone else seen this issue and what do you
do to get around it (besides shutting down communicator)

Thanks,
Barb Reinhardt
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Interactions between Communicator and Excel causing Macros to stop

Barb,
Can't see how it would directly Excel/VBA related.
If your network is slow already, could be the network just grinds to a halt.
Need to configure the OSes/network better and/or upgrade something.

NickHK

"Barb Reinhardt" wrote in message
...
I have macros within many excel workbooks that open files on another

server,
extract the data I want and save it in my "master" workbook. They take a
while to run because of network speed. I believe we've started to see an
interaction with Communicator in that when we send IM's when the macro is
running, the macro stops. Has anyone else seen this issue and what do

you
do to get around it (besides shutting down communicator)

Thanks,
Barb Reinhardt



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Interactions between Communicator and Excel causing Macros to

The network is EXCEEDINGLY slow. That's why I started to learn how to use
Excel macros. I wish I could do something about it.

Thanks,
Barb

"NickHK" wrote:

Barb,
Can't see how it would directly Excel/VBA related.
If your network is slow already, could be the network just grinds to a halt.
Need to configure the OSes/network better and/or upgrade something.

NickHK

"Barb Reinhardt" wrote in message
...
I have macros within many excel workbooks that open files on another

server,
extract the data I want and save it in my "master" workbook. They take a
while to run because of network speed. I believe we've started to see an
interaction with Communicator in that when we send IM's when the macro is
running, the macro stops. Has anyone else seen this issue and what do

you
do to get around it (besides shutting down communicator)

Thanks,
Barb Reinhardt




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
How can you log users' interactions with MS Office applications? [email protected] Excel Programming 0 July 13th 07 07:08 PM
Excel bogs down when running my macros, what is causing it? Rakmup Excel Discussion (Misc queries) 2 March 19th 07 09:03 PM
causing macros to run at insertion point Inobugs Excel Worksheet Functions 3 February 1st 06 06:19 AM
Excel and Office Communicator Nigel Excel Programming 0 December 29th 05 04:45 PM
If then statement causing value issues in Macros ssciarrino Excel Programming 2 November 29th 05 06:06 PM


All times are GMT +1. The time now is 11:52 PM.

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

About Us

"It's about Microsoft Excel"