Results 1 to 3 of 3

Saving Files In More Than One Location???

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    30

    Saving Files In More Than One Location???

    Hello:
    I would like to thank everyone who has helped point me in the right direction while I have been working on this file. Your help has been invaluable.

    The last step in the file I have been working on to me is my most complicated b/c I would like to do several different things that all lead to one outcome. As I am new to VBA and creating MACROS where to start and how to finish seems like a daunting task for me.
    What I would like to do:
    1. Create a MACRO that will save my file upon the entry of new data in what I will call the "Primary Location", simultaneously saving the file to a "Secondary Location" as a back up. The "Secondary Location" will be on a separate drive as well as a removable storage disk, so in total three locations. The reason being for the three locations is: one is a protected drive which only managers have access to, the drive is located on the same network. The removable storage disk is for security reasons in case the primary drive fails and the fill needs to be restored.
    2. Create a "Button" that will drop down to the next line data is to be entered and reset the courser to column "A" on that line. In total 27 people have potential to be entering in data to the spread sheet and having the button to do all this for them will make things (in my opinion) easier.

    I've looked online and seen examples of how to save in multiple locations similar to this: I would just need to enter in the appropriate file path and be done. Would something like this work even with a removable storage drive?
    Sub SaveToLocations()
        Dim OrigName As String
    
        OrigName = ActiveWorkbook.FullName
        ActiveWorkbook.SaveAs "G:\" + ActiveWorkbook.Name
        ActiveWorkbook.SaveAs "L:\" + ActiveWorkbook.Name
        ActiveWorkbook.SaveAs "K:\" + ActiveWorkbook.Name
        ActiveWorkbook.SaveAs "S:\" + ActiveWorkbook.Name
        ActiveWorkbook.SaveAs OrigName
    End Sub
    What I've been unable to find is how to create the button to trigger this code. I've been able to create a button but that's as far as I've gotten, getting it to drop to the next line and reset the courser is where I'm stuck.
    I need to note: due to how the document needed to be created for form and function, there are three lines that are merged and centered, and in the same row those three lines are un-merged in column "AC" (three seperate peices of data needed to be entered with in the location as the remaining data). I'm noting this b/c I'm fairly sure it will have an impact on how the button needs to be coded in order to do what I'd like to have done. Lastly there are 12 sheets in the document and one sheet which is where data is collected and calculated, I also have one hidden sheet for my drop down lists data. In other words if I'm somehow able to get this button and saving down where do I put the code to apply to all the sheets that have a button?
    Last edited by excelneub; 08-24-2014 at 09:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. split text files stored in some location to multiple files based on a condition
    By GIRISH_KH in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 11:32 AM
  2. Saving copying text files named in a column to a different location
    By twills in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2010, 08:44 AM
  3. Saving in wrong location
    By chris_mayer in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-06-2007, 05:08 AM
  4. saving to a default location
    By s_ali_hassan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2006, 07:00 PM
  5. Saving in a location
    By Greg Brow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2005, 11:06 AM

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