+ Reply to Thread
Results 1 to 4 of 4

Restricting save filenames to stop changing the original file.

  1. #1
    Registered User
    Join Date
    04-21-2016
    Location
    Houma
    MS-Off Ver
    2013
    Posts
    15

    Restricting save filenames to stop changing the original file.

    So I am fairly new to VB and up to this point I have been able to Google what I needed and modify it to my needs but this time I wasn't able to get it to work right.

    So I am in need of some code that will block a user from saving the file with a certain name. Basically I have created a master work book and when someone uses it they need to save it under a different name and leave the master template blank and intact.

    I am thinking when they try to save with the original file name you get a message box and then it cancels the save. but I want it to do this on save and and save saveas
    can any one help me out with this or point me in the right direction with some sample code?

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Restricting save filenames to stop changing the original file.

    Welcome to the forum!

    If it is a template, why not save it as an xlt or xltm file?

  3. #3
    Registered User
    Join Date
    04-21-2016
    Location
    Houma
    MS-Off Ver
    2013
    Posts
    15

    Re: Restricting save filenames to stop changing the original file.

    To be honest I had never thought of using that as a solution and wasn't completely sure how to implement it. So I googled a little last night and the problem im facing is that even though I save it as a template. when you open and forget to save as a different file name.(just click save) you still change the original file which is what im trying to avoid in the first place. The whole reason behind this is that I work in a office of people who are not very computer savy and formulas links to cells and information gets changed a over written fairly often. So I have created a Master Packet with all the formulas, forms and such in it to work from. but sometimes they forget to save the changes as a different file. it is my understanding that this is what a template is suppose to do but I must have been doing something wrong because after I saved my file as a template I was still able to edit and save it just as I had done before.

  4. #4
    Registered User
    Join Date
    04-21-2016
    Location
    Houma
    MS-Off Ver
    2013
    Posts
    15

    Re: Restricting save filenames to stop changing the original file.

    So after playing around some more with the template idea you suggested yesterday I figured out what I was doing wrong.
    I much appreciate the reply/suggestion as this will do exactly what I was looking for. Thank you and I apologize for my ignorance.

+ 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. Vba to run some codes then save file to different filenames
    By bezbid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2016, 02:42 AM
  2. 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
  3. Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  4. Macro to keep original file open, not 'save as' file
    By LonestarGuy in forum Excel General
    Replies: 4
    Last Post: 06-09-2010, 03:53 PM
  5. Replies: 3
    Last Post: 09-08-2005, 03:05 PM
  6. Replies: 1
    Last Post: 08-15-2005, 06:05 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