Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

Hi

I have written a procedure for formatting some Excel CSV download data which
works fine for almost all users.

However, for one user on their first run in the given Excel session, the
macro stops at the same point as it is is on a break point (there is no
error message). There is no break point shown and the macro will continue to
run properly if {F5} or {F8} is pressed. The error occurs for that one user
on different machines. On the second run, all is fine.

Can anyone shed any light on this?

Thanks

Tim


  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

Maybe check their "break on error" setting in the VBE ?

Tim



"Tim Childs" wrote in message
...
Hi

I have written a procedure for formatting some Excel CSV download data
which
works fine for almost all users.

However, for one user on their first run in the given Excel session, the
macro stops at the same point as it is is on a break point (there is no
error message). There is no break point shown and the macro will continue
to
run properly if {F5} or {F8} is pressed. The error occurs for that one
user
on different machines. On the second run, all is fine.

Can anyone shed any light on this?

Thanks

Tim




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

Hi

thanks for that

in a Windows XP network environment, is that a user-specific setting or part
of the Project itself?

Also, there is no real error - it just stops and highlights the VB line in
yellow: it's weird!

Thanks

Tim

"Tim" <tim j williams at gmail dot com wrote in message
...
Maybe check their "break on error" setting in the VBE ?

Tim



"Tim Childs" wrote in message
...
Hi

I have written a procedure for formatting some Excel CSV download data
which
works fine for almost all users.

However, for one user on their first run in the given Excel session, the
macro stops at the same point as it is is on a break point (there is no
error message). There is no break point shown and the macro will

continue
to
run properly if {F5} or {F8} is pressed. The error occurs for that one
user
on different machines. On the second run, all is fine.

Can anyone shed any light on this?

Thanks

Tim



  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs


"Tim Childs" wrote in message
...
Hi

thanks for that

in a Windows XP network environment, is that a user-specific setting or
part
of the Project itself?



Not absolutely sure, but I think it's at the user level.

Tim




Also, there is no real error - it just stops and highlights the VB line in
yellow: it's weird!

Thanks

Tim

"Tim" <tim j williams at gmail dot com wrote in message
...
Maybe check their "break on error" setting in the VBE ?

Tim



"Tim Childs" wrote in message
...
Hi

I have written a procedure for formatting some Excel CSV download data
which
works fine for almost all users.

However, for one user on their first run in the given Excel session,
the
macro stops at the same point as it is is on a break point (there is no
error message). There is no break point shown and the macro will

continue
to
run properly if {F5} or {F8} is pressed. The error occurs for that one
user
on different machines. On the second run, all is fine.

Can anyone shed any light on this?

Thanks

Tim





  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Intermittent Pseudo "Break Point" on First Run but not Subsequent Runs

many thanks - Tim

"Tim" <tim j williams at gmail dot com wrote in message
...

"Tim Childs" wrote in message
...
Hi

thanks for that

in a Windows XP network environment, is that a user-specific setting or
part
of the Project itself?



Not absolutely sure, but I think it's at the user level.

Tim




Also, there is no real error - it just stops and highlights the VB line

in
yellow: it's weird!

Thanks

Tim

"Tim" <tim j williams at gmail dot com wrote in message
...
Maybe check their "break on error" setting in the VBE ?

Tim



"Tim Childs" wrote in message
...
Hi

I have written a procedure for formatting some Excel CSV download

data
which
works fine for almost all users.

However, for one user on their first run in the given Excel session,
the
macro stops at the same point as it is is on a break point (there is

no
error message). There is no break point shown and the macro will

continue
to
run properly if {F5} or {F8} is pressed. The error occurs for that

one
user
on different machines. On the second run, all is fine.

Can anyone shed any light on this?

Thanks

Tim







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 "pseudo" ranges JonH Excel Discussion (Misc queries) 1 March 2nd 10 06:32 PM
Break a link between workbooks when there is no "break" option FruitNLoops Excel Discussion (Misc queries) 2 January 31st 09 05:16 AM
"Automatic Calculation" option intermittent Renny Bosch Excel Discussion (Misc queries) 2 October 19th 08 10:38 PM
Run-time error "5" after range().delete runs before querytable.add [email protected] Excel Programming 5 September 7th 06 05:04 PM
Macro that runs entered value through "low" and "high" range Vika.F Excel Programming 5 August 14th 05 08:35 AM


All times are GMT +1. The time now is 01:28 AM.

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"