vba - ByRef Argument Type Mismatch while calling function -


i writing small vba code, , getting error byref argument type mismatch when function loopthroughnamesandpopulatevalues() called main()

sub main()     call loopthroughquotenamesandpopulatevalues("sheet2", 1, 1) end sub  sub loopthroughquotenamesandpopulatevalues(byval sheetname string, byval row integer, byval column integer)     dim sheet excel.worksheet     set sheet = thisworkbook.sheets(sheetname)      = row 10000         if sheet.cells(i, column).value = ""             exit         else             call finder_get_query(sheetname, i, column)         end if     next end sub

option explicit: add "option explicit" top of module , compile. guess code won't compile because not declared. maybe not issue though, unless finder_get_query choking on i.

error handling: put error handler in finder_get_query , 1 in loopthroughnamesandpopulatevalues , see 1 catches error. narrow down code.

many simple problems can solved following these 2 steps. here preferred error handler, handy debugging because allows resume @ runtime if want:

sub sampleerrorhandler()      on error goto eh      'code      goto finish  eh:     err         msgbox "error:" & vbtab & .number & vbcrlf _             & "source" & vbtab & .source & vbcrlf _             & .description     end      'for debugging purposes     debug.assert 0     goto finish     resume  finish:      'clean up, release resources  end sub

Comments

Post a Comment

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

im trying write component admin side , need add user creation. dont want duplicate existing codes add link. know how add task not simple link toolbar. thx help. if wanting button opens new user screen can try in component: $bar = jtoolbar::getinstance('toolbar'); $bar->appendbutton('link', 'users', 'new user','index.php?option=com_users&task=user.add'); you need add view.html.php file wherever you're creating toolbar. is need?
Read more

linux - disk space limitation when creating war file -

i have 1 gb disk space limitation hosting app , have used 700mb of it. however want create war file directory big (around 600mb) using command : jar -cvf root.war folderpath that's why encounter quota limitation , can't following. i'm looking way delete folder content when it's applying archive conserve disk space take note can't install zip tool in ssh shell ~ the code works on test directories, test first anyway, deletes files. it's not efficient. assumptions: 300mb free space, in destructively compress 600mb folderpath directory. none of files big -- if file in folderpath 300mb or larger, fail. notes: if ' $out ' file exists, nothing. first find pipes file list while , if ' $out ' doesn't exist in loop, create it, don't update -- if does exist, update it. each pass adds 1 more file, deletes unless file directory. after loop finishes delete empty directories too. unset u ; in=folderpath ; out=roo...
Read more