Save using macro file path

**RANDY LIPOSKY** · 04-19-2014, 03:44 PM

I want to be able to save a file using only the macro save path which I have already created.

So how do I turn off the save, save-as, or Control C function?

**alansidman** · 04-19-2014, 03:54 PM

try this:

Option Explicit

Sub SaveMe()
Dim thePath As String
thePath = "C:\YourFilePath\"
Dim theFile As String
theFile = "YourFileName.xls"

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=thePath & theFile
Application.DisplayAlerts = True
End Sub

**RANDY LIPOSKY** · 04-22-2014, 11:10 AM

Alan,

Thanks for the input. I already have a macro that saves to a file. I want to be able to disable the normal save, save-as, and Control S functions. Do you know how to do that? In other words, when the user opens the file, he/she has no choice but to run the save macro because he/she can't utilize the normal save functions.

Thanks again.

Save using macro file path

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Save using macro file path

Re: Save using macro file path

Re: Save using macro file path

Thread Information

Users Browsing this Thread

Similar Threads

Save As macro with only partial file path

how to specify a file save path to a save macro

[SOLVED] VBA for file save as macro enabled to a specifi path and folders

Macro to save sheet as CSV using a dynamic file name and file path

Macro to save workbook by referencing cell in another workbook for file name and file path

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions