Excel VBA Crashing -

-

my company computer upgraded office 2010 office 2013. had several workbooks large macros outputting various reports. after upgrade having problems. biggest issue excel crashing ("microsoft excel has stopped working."), on code ran fine in 2010.

i tried copying sheets , code new workbook, , reassigning buttons correct macros in new workbook. runs fine, when try edit code, starts crashing excel again.

code compiles fine, without errors. changed options "notify before state loss" , "break on errors", still cannot prevent crash.

i have vba opens spreadsheet data, before read data code looks column headers. array escarray has column headers stored in position 0 (zero) , when finds matching column header, replaces column name column number, can pull data correct column (in case columns shift don't have change code). below code checks make sure column names found , replaced number. if array position not have number value (representing column number), should msgbox, code exit. excel crashes when gets "if val(escarray(0, cnt)) < 1 , escarray(0, cnt) <> "blank" then" line, ran fine past year (until 2013 upgrade)...

    'check columns found...     cnt = 1 gklen       if val(escarray(0, cnt)) < 1 , escarray(0, cnt) <> "blank"          workbooks(filename).saved = true          workbooks(filename).close          workbooks(thistool).activate          msgbox ("column " & escarray(0, cnt) & " not found.  exiting macro.")          exit sub       end if     next

lastly, did vba6.dll error after upgrade when running macros. online investigation error suggested registration issue (it said not touch registry). downloaded vba6.dll file , placed in windows/system32 folder , stopped getting error.

any suggestions?


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more