How To Save File With User Enter path with Input BOX
Results 1 to 5 of 5

Thread: How To Save File With User Enter path with Input BOX

  1. #1
    New Member
    Join Date
    Oct 2018
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post How To Save File With User Enter path with Input BOX

    Hello Every one


    Dim T as Variant
    T = InputBox("Enter Your CORP ID")

    ChDir "\\Client\C$\Users\T\Desktop"
    ActiveWorkbook.SaveAs Filename:= _
    "\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _
    FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

    I have above code but code notrun , I get Run Time Error 76 Path not found
    Last edited by Fluff; Oct 13th, 2018 at 03:46 PM.

  2. #2
    Board Regular
    Join Date
    May 2017
    Posts
    52
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How To Save File With User Enter path with Input BOX

    A way to get the path of the file is to place a file in that directory and then right click on it, then click "properties". Under location you can see the path. Check if that is the same.

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,822
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: How To Save File With User Enter path with Input BOX

    Hi & welcome to MrExcel
    Try
    Code:
    Dim T As Variant
    Dim Pth As String
    T = InputBox("Enter Your CORP ID")
    Pth = "\\Client\C$\Users\" & T & "\Desktop\"
    
    ActiveWorkbook.SaveAs filename:= _
    Pth & "From Application to MIS_V.0.1.xlsm", _
    FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
    Last edited by Fluff; Oct 13th, 2018 at 03:48 PM.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #4
    New Member
    Join Date
    Oct 2018
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How To Save File With User Enter path with Input BOX

    Thank you bro

  5. #5
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,822
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: How To Save File With User Enter path with Input BOX

    You're welcome
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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