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
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]
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