Results 1 to 2 of 2

Filename variable

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2007
    Posts
    60

    Filename variable

    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?
    Last edited by elfvis; 01-05-2012 at 10:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1