+ Reply to Thread
Results 1 to 7 of 7

VB script for file name

  1. #1
    Registered User
    Join Date
    05-20-2023
    Location
    West Midlands
    MS-Off Ver
    Excel 365 V2304 Build 16.0.16327.20200 64-bit
    Posts
    10

    VB script for file name

    Greetings all.
    I am looking for some help with the following script.
    The script work well and saves the pdf in the correct folder but i have failed to get the saved file name to work
    The file name is held in cell M1

    Please Login or Register  to view this content.

    Any help would be good please.
    Last edited by Alan-53; 11-05-2023 at 04:28 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: VB script for file name

    Administrative Note:

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: VB script for file name

    Thanks for trying - you got the tags wrong, though, so I've corrected them for you. Click to edit the opening [ost to see how I added them for future reference.

  4. #4
    Registered User
    Join Date
    05-20-2023
    Location
    West Midlands
    MS-Off Ver
    Excel 365 V2304 Build 16.0.16327.20200 64-bit
    Posts
    10

    Re: VB script for file name

    Thanks for that i see how its done now when entering code onto the forum
    Last edited by Alan-53; 11-04-2023 at 07:18 AM.

  5. #5
    Registered User
    Join Date
    10-16-2023
    Location
    Poland
    MS-Off Ver
    Excel 2019 32bit WIN10
    Posts
    98

    Re: VB script for file name

    Check this:
    Please Login or Register  to view this content.
    Last edited by Tajan; 11-04-2023 at 07:07 PM.

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: VB script for file name

    Please Login or Register  to view this content.
    The inherent weakness of the liberal society: a too rosy view of humanity.

  7. #7
    Registered User
    Join Date
    05-20-2023
    Location
    West Midlands
    MS-Off Ver
    Excel 365 V2304 Build 16.0.16327.20200 64-bit
    Posts
    10

    Red face Re: VB script for file name

    Greetings Tajan & Jolivanes.
    Many thanks for your input.
    Everything is now working as required.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. script to run the macro from Vb script with out opening the excel file
    By chandanp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2021, 03:33 AM
  2. [SOLVED] Need to Adapt VBA Script for my file
    By MermaidNiki in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2017, 07:23 PM
  3. Script/macro to save a copy as tab delimited text file and then close original file
    By Merlin803 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2015, 01:34 PM
  4. need help in writing a vba script to run a macro (.xlam file) on a .csv file
    By NeoDasari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2015, 02:02 PM
  5. Script or .bat needed to open office file file located in LAN
    By 823 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2015, 11:06 AM
  6. Replies: 4
    Last Post: 10-17-2014, 09:31 AM
  7. Replies: 1
    Last Post: 12-20-2009, 09:17 PM

Tags for this Thread

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