save as

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...

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...

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" &...

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...

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...

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...

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...

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...

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...

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...

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...

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 _...

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...

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...

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...

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...

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...

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...

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...

Hi all, I'm using the following piece of VBA in outlook to save a file when it is received automatically however the file is unusable. If I don't change the name of the file when saving in the directory it is ok but because the file names can be different at times the VBA changes the file name...