Newbie question. I set a variable name (wbname=thisworkbook.fullname), but when I go to use the variable in a subroutine called right after it is set the debugger says the variable is "empty". What am I doing wrong. Thanks in advance.
How did you declare the variable? It needs to be at the top of the module, before any procedures. Then it is public and available to all procedures. Otherwise it is only available to the procedure in which it is declared.