save as

  1. M

    Save As and Continue Working

    I have a macro that clears a database for the quarter, to start fresh with the next quarter. Each quarter adds a few things, so it's not feasible to just start with a blank from the original file. I'm trying to add something to the macro that will save the current file (the outgoing quarter)...
  2. K

    Save As VBA for MacroEnabledWorkbook

    Hi, I'm going to have a macro to save as in MacroEnabledWorkbook format. Here is my code Sub trysave() Dim kamal As Variant kamal = Application.GetSaveAsFilename If kamal <> False Then ActiveWorkbook.SaveAs Filename:=kamal, FileFormat:=52 End If End Sub If I...
  3. G

    VBA to filter and export sheets based on data validation list

    Hi all, I have a file for a number of different orgs, and I'm trying to get to a solution where I run a macro, and it filters the sheet, copies values to a new sheet and saves it to a designated location. I'm hoping to get one run of the macro to accomplish this for all the orgs represented in...
  4. B

    Excel VBA: Save As with Filename/Filepath/Date&Time

    Hello all, I am currently needing to add a "save as" function to add both the date, and hour to the filename. Currently, the script I have is below. Sub SaveWorkbook() Dim FilePath As String Dim NewName As String FilePath = "C:FILEPATH": NewName = FilePath & "Pack Labels" &...
  5. Johnny Thunder

    VBA Help - SaveCopyAs trying to open a workbook instead of save?

    Hi group, I am at the last step of my code and I am running into a little issue. I have an emailscript that drafts an email and attaches a link to the activeworkbook to the email and adds a calculated time stamp. Prior to adding the timestamp the code runs fine and without issue. When I add...
  6. L

    Detecting change in Save As filename before hitting OK

    Hi everyone, Maybe a cryptic Title but I'll explain: I Use "Application.Dialogs(xlDialogSaveAs).Show(filename)" (containing prompted filename) to open Dialog window Save As. Now, I want to detect if that filename in an way is changed before hitting "OK" to save (actually I want to prevent/stop...
  7. B

    VBA to save as tab delimited file

    Hi all, I've seen this topic discussed, but not sufficient to answer my question. Your help is appreciated. My goal is to export a worksheet to a new workbook, save the new workbook in a specific location with a specific file name. The next part is where I'm struggling. I then want to take...
  8. andrewb90

    Create a copy of workbook with VBA

    Hi all, Basically, I need VBA to create a copy of my workbook (equivalent to press F12). The name would be the same with the added (view only) in the name, and the file path would be the same. When I used the recorder I got this: ChDir "C:\Users\AB\Desktop" ActiveWorkbook.SaveAs...
  9. M

    Incrementing File Name when using save as a macro

    Hi, please do correct if violate some rules. I have a workbook that needs to be saved everytime there is a new name that is selected and if ever that the same name will be save the file name will increment. The filename I choose is the value of cells. Name - Date - Line of business. so for eg...
  10. S

    VBA code fails on SaveAs when .xltm

    Morning everyone!!, This is my first post here. I normally stay back and figure things out on my own but this one has me stumped. Any help or insight that you might be able to provide is greatly appreciated!! I have some VBA code that I use to save a workbook. It is linked to a button for ease...
  11. N

    Save As missing

    How do I configure the File drop down menu from the ribbon on Excel in Office 365. My colleague has suddenly found that some of the shortcuts are missing after the last update. For instance, she no longer has the Save As shortcut but it seems to have been replaced with something called Save...
  12. N

    VBA to deal with Open/Replace/Save as Text file .txt

    Hi, I need help on this one. I am trying to run a macro from Task1.xlsx that will open text file from /template/aaa.txt, replace xxx with text in cell A1 in Sheet2 on Task1.xlsx. Then save as bbb.txt file in result/bbb.txt with bbb is text in cell A2 in Sheet2 on Task1.xlsx Has anyone run into...
  13. J

    Microsoft Word Not Saving

    Sub Test() Dim DCM1 As String DCM1 = Mid(ThisDocument.Name, 1, Len(ActiveDocument.Name) - 4) ActiveDocument.SaveAs2 FileName:="C:\Users\UI488820\Desktop\Logo" & DCM1 & "" & "test" & ".docx", FileFormat:= _ wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles _...
  14. D

    VBA save as txt file - Uppercase file extension

    Hi, Currently the below code snippet is used to save a range of data into a tab delimted text file for upload into a database. I have just found out the file name including extension needs to be uppercase throughout. ActiveWorkbook.SaveAs SaveToDirectory & SaveName, xlText Is there a way to...
  15. J

    Saving an open PDF as something from Excel with VBA

    I'm creating a report where I open a handful of spreadsheets containing data, and then run the macro from the "master sheet", which then pulls data from these sheets and pastes it in. This is fine, it works and there's no problems. BUT, one of the files is a PDF and the only thing I need to do...
  16. V

    VBA insert cell value to named text box and save

    Hi, I am having a bit of trouble getting this code to work. I have broken it down simply to have a single text box in the word document 'Word.docx' and have named it "Test" using the 'plain text content control' I have clicked the design mode all on the developer tab in word and then changed...
  17. P

    Save As dialog box looks weird

    Hey Guys, I'm losing my mind a bit here trying to get my Save As dialog box to look normal again. I've done a fair bit of googling and can't find a fix (or anyone that's ever had this problem!). The below screenshots show what my Save As box looks like now, vs how it should look. Does anyone...
  18. P

    Massive Download from links - Save as

    Hello guys, I found a code that download all archives from links located in the Column Q, and it's working very well. But would be perfect if I could download with a diferent filename, using the value of column S. Thank you in advance for the help! Sub imagestore() Dim i As Long Dim lastRow...
  19. J

    Copy specific worksheets to new workbook (as values). Save as

    Hello, I am attempting to do the following: Copy all worksheets whose name ends in "-PP" into a new workbook (formats, values - NO formulas) Open a pop-up box in the new workbook that asks the user to enter the version number Open the save as window and save the file to the user's desktop as...
  20. J

    vba save as variable name

    Sub FormatReprot() Dim AC As String: AC = Sheets("main").Range("H17").Value ActiveWorkbook.SaveAs Filename:= _ "C:\Dept\Report\NC.xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False I am trying to make a variable for the file name. However I instead...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top