Another thing to remember is that code does "just stop" when it is
running in an event handler, such as a change event. An error under
these circumstances will cause the execution to be abandoned, rather
than producing an error report. We need more information about the
code, including what action causes it to run.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of 1z
Sent: Tuesday, 1 May 2012 23:24
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] VBA stops to run
Hi Derek,
PMJI.
I do a lot of coding for the VBE. I can assure you, code can "just stop"
... but there is usually a reason :-)
One of the most usual reasons is... it hasn't.. it just looks like it.
This usually means a loop you aren't coming out of.
Flavio, what is the break on error setting in your project?
Also, have you tried tracing execution with Debug.Print?
... and Dereks question is a good one... do you get any indication of an
error at all????
... have you tried stepping through the code as in Davids suggestion?
... Is there an open dialog box that you can't see below a open window?
HTH
Lisa
Sent: Tue, May 1, 2012 11:47 am
Subject: Re: [ExcelVBA] VBA stops to run
Dear Flavio, Dear All
Surely code does not 'just stop'.
When there is an error the execution stops in the line with the error
and this
s highlighted in yellow.
A dialog box appears with a message describing the error. The clue to
the error
s in the message.
Flavio - Is this not happening. ?
Derek +++
Sent: Monday, 30 April 2012, 19:00
Subject: Re: [ExcelVBA] VBA stops to run
David's about right. All I can see is either permissions or
there is some code that doesn't work. In my experience, if
code doesn't finish running it's because there is something
wrong or not quite right with it. If you rely on recording and
then modifying macros, the code that Excel creates may not
do EXACTLY what you intended, or it may do only the
specific commands you gave while recording. Adding loops
and conditions is always something to do carefully, and to
really do it right always make sure you understand the
generated code (IF you recorded it). It usually takes me a
while to not only figure out what it's doing, but how to go
about changing it. If you are NOT recording the macro, it
might help to try it and get a better idea of how XL thinks
about it. Given what you have shown, it could be a number
of things, which is why I would just record a separate macro
to see what commands it generates.
For me, it would be worth a try anyway!
G.
>Sent: Monday, April 30, 2012 7:36 AM
Subject: RE: [ExcelVBA] VBA stops to run
Possibilities are:
The workbook is opened as read-only
You do not have write permissions in the directory holding the workbook
There is a macro in the workbook which is triggered when you save it
The workbook is not the active workbook at the time you issue the
command
The code saves the workbook but the next command is defective
Try stepping through the code and checking what happens then.
Best Regards
David Grugeon
Excel VBA Group Moderator
>Sent: Saturday, 28 April 2012 1:00 AM
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Subject: [ExcelVBA] VBA stops to run
Good morning gentlemen, i need some support..
I did a code to import the content from some spreadsheets. Those
spreadsheets that i'm importing has macros. I opened, and imported the
data.
The problem is that after that i need to do one change, save, and close
the
spreadsheet.
When i try to save the spreadsheet, the codejust stops to work. Just
stop.
I already tried some things, but none of them really worked.
Detail: I'm working with excel 2010, but saved my spreadsheet in the
format
.xls. The spreadsheets that i'm opening also have this format.
In the first version that i did, it shown the compatibility checker
screen,
warning me about "significant loss of funcionality". I clicked in
continue.
So after that the code stops, as soon as i execute the instruction
ActiveWorkbook.Save
After that i created a second version from my program, with 3 lines
before i
save:
Application.DisplayAlerts = False
Application.EnableEvents = False
ActiveWorkbook.CheckCompatibility = False
The compatibility checker message was gone, but the code still stops to
run,
in the same line ActiveWorkbook.Save.
I appreciate any help about. I tried to think in different solutions,
but
right now i dont have a clue why this is happening.
Regards to all
Flavio
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar