+ Reply to Thread
Results 1 to 3 of 3

Check file name

  1. #1
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    179

    Check file name

    Gurus,

    I need help understanding how to write this code.

    I want to have the macro save a file, but if the file name is "Master Quote Worksheet", I will run it through my Save As code that I have written. I just don't know how to check what the name of the file is so I don't overwrite my "Master Quote Worksheet" file.

    TIA,
    Tim

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Check file name

    Code like this:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: Check file name

    Bernie,

    Thank you for the code. I figured out a way but yours was much better.

    thanks,
    Tim

+ 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. How to check Last Modified Date on Temp File and compare it to original/parent file?
    By CaffeinatedCoder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2016, 07:42 PM
  2. [SOLVED] Use text file to hold usernames and then VBA to read the file to check if the user is list
    By Pbuffh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2016, 01:14 PM
  3. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  4. [SOLVED] Check if file exists and if so save file incremented by 1 e.g. filename(1).xlsm
    By ratdogexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2014, 01:15 AM
  5. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  6. [SOLVED] Get file path from a cell, run a check to see if the file has a specific sheet if yes copy
    By Martha44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 03:35 AM
  7. [SOLVED] code to check file size everytime an Excel file is opened
    By Kaiser in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2006, 12:50 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