1. G

    Export Cell Range As JPEG and Save As

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

    VBA for Save as PDF & Save file help

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

    VBA to create a folder name with the date for Monday and Friday separated by a hyphen?

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

    Prints Sheets and SaveAS Macro

    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?
  5. K

    VBA: save document to path from variable

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

    VBA SaveAs Error

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

    "Saving" Notification/Status window not closing after VBA Save

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

    VBA code to Save As in Current Folder and a Cell Dependent Name

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

    Make PowerPoint macro SaveAs overwrite without warning popup

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

    VBA code with cell.Value and SaveAs works in Windows, not Mac, help

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

    Macro for saving a file that will add ascending numbers and revert back to .xlsx

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

    Workbook SaveAs private function to include date & time stamp - saved file won't open

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

    Anyway to have BeforSave event runs after SaveAs location prompt instead of before?

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

    Saveas active word document in specific folder

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

    What is wrong with my code? The line that is not responding is underlined and bolded.

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

    VBA SaveAs Code failed

    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 =...
  17. J

    VBA if Save Fails then saveas

    Hi, I have 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?
  18. J

    how to open an existing PDF file and save as a .png file?

    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!
  19. C

    Macro to ask user to saveas worksheet

    Hi, Looking for a macro to be able to save only one worksheet of the workbook. For example, msgbox asks user to saveas H:\Jobs\ and then saves sheet 5 as an excel workbook itself. and if possible, it uses the value of cell b2 as the name of file."H:\Jobs\B2 value I tried but I have a mess...
  20. L

    How to change the default "SaveAs" dialog directory path without prompting user nor causing a "save"

    I know I can change the SaveAs path using application.GetSaveAsFilename initialfilename:="%userprofile%\Downloads" but this results in the user being presented with the SaveAs dialog. I want to change the SaveaS directory they are shown if/when they issue their own SaveAs (or Save) request...

Some videos you may like

This Week's Hot Topics