saveas

Hello, I keep receiving RunTime Error 1004 at the saveAs line of my code. The code is below. I have tried multiple different solutions people have posted, but it doesn't help. Private Sub CommandButton1_Click() Dim Path As String Dim Name As String Dim Loc As String Set wb = Workbooks.Add...

I want to save Excel files in both the local drive and in the network folder. Currently I am doing it with SaveAs (local) and another SaveAs (network), is it faster to do a SaveAs then FileCopy? Code below: Sub SaveAs() Dim ws As Worksheet Dim ws_console As Worksheet Dim...

Hi All, I have a sheet in which I have 2 images within a cell to the left (A4) and a product code in the next cell (C4). I have to screenshot cell A4 and save the file as the product code in C4 (another program uses this data so they have to be saved in this format). I’m currently using the...

Hi Guys, I have created a VBA which saves the active sheet of the specific workbook - this works perfectly but I also want to save the whole workbook alongside the PDF with the same filename as the PDF. How can I fit this in on the same macro? Please see below code: Sub PDFActiveSheet() Dim...

Hi Folks, I have found a great macro which allows you to check for the existence of folders in a file-path matching: Year, Month and Day (i.e., creating the folder if it doesn't exist). For instance, if the FilePath starts: C:\Temp Time Sheets\ it checks for C:\Temp Time Sheets\2019\ C:\Temp...

I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?

Hello all, In have a file path saved as the variable "File_Path". Now I want to save a workbook to that path. I'm using the following code: WB2.SaveAs Filename:= _ File_Path _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False It is not recognising "File_Path" as...

Hello, I am trying to automate some data importing into a spreadsheet from another then save as a new file name. When I go through the macro it all works right up to the point it trys to save the spreadsheet. I just get the run time error 424: Object required I am sure I must be missing...

Though currently on Office 365 I have experienced this issue in earlier versions as well. I am using the ActiveWorkbook.SaveAs command to save a new workbook. The save is successful; however the Saving status window does not close. In order to continue processing I must select Cancel...

Hello I was wondering how to make a macro SaveAs my file into the folder that my main file is in. Currently my code saves to my documents folder. My current code: Sub SaveAs() ActiveWorkbook.Save ThisFile = Range("B4").Value & Range("B8").Value ActiveWorkbook.SaveAs Filename:=ThisFile End...

Hi, is it possible to write a code to Excel VBA that saves a PowerPoint presentation to SharePoint with a dynamic name (changes according to a specific cell value) and overwrites the existing file, if there is one? This is my code now, and it doesn't work. Application.DisplayAlerts = False...

Hi, I've got a piece of code I found online and it works awesome in Excel for Windows. It takes a long list of data and saves out separate files for each unique value in column A. However, when running it on Excel 2019 for Mac, it does not use the unique values in Column A for the file name, but...

Hello everyone, I have been looking for a macro that can do the ff: Save the active workbook with Specified path Prefixed with "SASPO" Add a number after e.g. "SASPO 1" Add a value of a range e.g. "SASPO 1 (value of cell B1)" change the sheet format back to .xlsx e.g. "SASPO 1 (value of...

Hi Folks, I discovered some VBA to be able to save a workbook with a custom filename that contains date and time stamp. My goal is just to save the file as *.xlsx. The code below works in regards to saving the workbook with the bespoke filename; however, when you try and open the workbook...

So I have some code that I don't want to run until after the user selects save on the SaveAs save location prompt but it appears the BeforeSave event runs the code before the prompt even opens. Is there anyway around this or some other method to define a trigger event for once the user selects...

I am using the below code to copy values from excel and paste into word document and the macro is working fine . I am facing the issue while doing saveas word documents could you please help me with the code which can saveas the documents in specific folder and close the original document...

Dim path1 As String Dim Filename1 As String Application.ScreenUpdating = False path1 = Range("I7").Text Range("A1:f40").Select Selection.Copy Sheets("Laser").Select Sheets.Add After:=ActiveSheet Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...

Can somebody please help to identify what mistake am i committing? I'm using Excel 2010 Running macro gives me the message that... Run time error 1004 Method 'SaveAs' of object' _workbook' failed Here is how I set up the file format If Val(Application.Version) < 12 Then FileExtStr =...

Hi, I have thisworkbook.save in some of my macros though if save fails I would like to saveas in the same folder.... Same file name but include V2, V3 etc.... What is the best way to do this?

Hi, everyone I want to use Excel VBA to open an existing PDF file, and save this PDF file as a ".png" file. How to write the vba code, or vb code? Thank you very much! Really APPRECIATED!