I would like to pass a variable between workbooks, but I run into two errors. I can remedy the error's by creating more then one input, but it is most likely annoying for the end user.
Dim vReply as string
vReply input = ("stuff")
Application.Run ("vReply & !MacroName")
Requires that I ask the user to put single qoutes around their response. I was looking into the filedialog but I believe it would fail in the same way. Additionally if I activate that work book.
Dim vReply as string Workbooks(vReply).Activate
It can not have quotes so if I set the variable and need to activate and run.
With that being said how could I set the input to force the user to browse to the file, and then have it pass in both instances presented above?
Bookmarks