+ Reply to Thread
Results 1 to 4 of 4

saveas filename=inputbox value?

  1. #1
    Forum Contributor
    Join Date
    12-08-2005
    Location
    Silicon Valley, CA USA
    MS-Off Ver
    2013 - Using 64 bit system
    Posts
    271

    saveas filename=inputbox value?

    Hi,
    How can I do this"

    HTML Code: 
    ActiveWorkbook.SaveAs Filename:= _
            "P:\Technology\Project-Phase1\Reports\[COLOR="Red"][B]Filename[/B][/COLOR]", FileFormat:=xlExcel2 _
            , Password:="", CreateBackup:=False
        Range("I21").Select
    How can I pass the value for filename through input box?
    Please help me.
    thank you
    Jaz

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677
    Instead of using InputBox, you might look at
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-01-2008
    Posts
    4

    Store the user input in a variable first

    choice = InputBox (Prompt,Title,...)
    filename = "P:\Technology\Project-Phase1\Reports\" + choice + ".xls"

    ActiveWorkbook.SaveAs Filename:= filename

  4. #4
    Forum Contributor
    Join Date
    12-08-2005
    Location
    Silicon Valley, CA USA
    MS-Off Ver
    2013 - Using 64 bit system
    Posts
    271
    Gulaoye & Shg,
    Thanks for your help. I did succeed with both methods.
    Thank you
    Jaz

+ Reply to Thread

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