I think this is a simple question but I cant seem to work it out. I have a main Sub that calls a Function, and I want to pass the value of a variable from my main Sub to my Function.
Here's what i'm doing, the whole code is rather long so here is a condensed version:
'-open excel workbook-
dim oExclN as Integer
'-gather lots of information-
'-open inventor file-
private function NewDocUpdater()
'-call another function-
I am trying to use "ByVal 'myvariable' as Integer". If I attach that to my Function, I get a "argument is not optional" error on the 'call NewDocUpdater' in my Sub. If i attach it to my Sub it wont run anymore. I've tried changing it to public and private on both Sub and Function but no change. And i'd like to pass this value along when my Function calls another routine.