"Processing" indicator while running macro
"Processing" indicator while running macro
(OP)
I've made a macro to do some manipulation of BOM information that can take about a minute to run, depending on assembly size. while it's working in the background, there's no way to tell if it's working, or if it's crashed completely.
is there any way to show a status bar or even a form that says "Processing" or something along those lines while the code is running? I tried making a form, but showing the form stops the code until the user clicks on 'ok'.
any recommendations?
is there any way to show a status bar or even a form that says "Processing" or something along those lines while the code is running? I tried making a form, but showing the form stops the code until the user clicks on 'ok'.
any recommendations?






RE: "Processing" indicator while running macro
Making the best use of this Forum. FAQ559-716
How to get answers to your SW questions. FAQ559-1091
Helpful SW websites every user should be aware of. FAQ559-520
RE: "Processing" indicator while running macro
http://www.j-walk.com/ss/excel/tips/tip34.htm
Killswitch
RE: "Processing" indicator while running macro
RE: "Processing" indicator while running macro
i'll take a look at that progress meter, and see if i can get something out of that...
RE: "Processing" indicator while running macro
before i couldn't get the code to keep running while the form was open... i was missing the option of using the form's activation event to trigger the rest of the code.
thanks for the help.
RE: "Processing" indicator while running macro
In the end of the macro you can have another MsgBox informing that the macro was successfuly completed.
Regards
RE: "Processing" indicator while running macro
The last one should have an OK to click.
Regards
RE: "Processing" indicator while running macro
Make sure the form is non-modal. Put a timer on the form. Use the timer to trigger reading of key variables and updating of information on your form.
RE: "Processing" indicator while running macro
Private Sub cmdExit_Click()
Set swApp = CreateObject("SldWorks.Application") ' attach to SolidWorks
Set Part = swApp.ActiveDoc ' get the PartDoc for the current Part
Set swApp = Nothing
Set Model = Nothing
Set drawing = Nothing
Set DwgDoc = Nothing
Set Part = Nothing
Unload frmSfInfo
Unload Me
End
End Sub
Bradley
RE: "Processing" indicator while running macro
i've gone through the code to make sure that all objects have been set to nothing, and all documents closed, but it still seems to stay in memory... maybe i missed something...
RE: "Processing" indicator while running macro
Bradley
RE: "Processing" indicator while running macro
RE: "Processing" indicator while running macro
Bradley
RE: "Processing" indicator while running macro
RE: "Processing" indicator while running macro
RE: "Processing" indicator while running macro
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
RE: "Processing" indicator while running macro
i'm not clear on the different versions of VB, really. according to the 'about MS VB' page, it's VB 6.3, VBA: Retail 6.4.9972, forms3 11.0.6254
TheTick Wrote:
Also, make sure to close the workbook generated by your SW BOM editing.
not sure what you're referring to. my BOM is SW-table based, and i'm copying from that into just one workbook, which i'm closing properly (as far as i know)