save

  1. J

    Display information in second form

    Hi, me again, Sorry for ask many question, I am new in vba excel. I have a form, this form allows you to look for a person (probably I have many people named David), in case you have many registers with one name (but different last name) you can pick wich register you want to update. once...
  2. B

    Error on Closing PowerPoint Presentation from Excel-VBA

    Hey Everyone, so i have the following code in order to open a powerpoint presentation which i have embedded into excel, save that powerpoint under a new name to a filepath and then open that powerpoint (so that the new saved powerpoint copy is edited and not the embedded object) Sub...
  3. A

    Excel vba for creating a summary word document from the comparison of 2 word documents

    Hi, I created a vba script in Excel in order to create a word document as summary of comparison of 2 word documents. Here my script: Option Explicit Private Sub ButtonSummaryReport_Click() 'Initialize the progressbar and the label Dim k As Integer Dim filesNumber As Integer...
  4. A

    Save to relative (variable) file path

    Hello all bright minded people, please allow me to ask a question: I have a complicated excel project that uses Power Query to read data from different directories. To indicate the source I have a drop down menu (with all the sources) and a FilePath named in name manager. The project outputs...
  5. H

    Automatically Download PDF Links to Desktop Folder

    Hi, I have code that currently loops through a list of hyperlinks in Excel and batch downloads these links as PDFs. I am having trouble controlling where these downloads ave. Sometimes they save to my desktop, documents, or another file path. Ideally, I would like them to be saved into a...
  6. M

    Save word/excel file on Sharepoint with VBA

    I have managed to extract data from excel to a specific word format and save it on my local disc with use of VBA. Now I need to set the code so that the file is saved to a specific Sharepoint folder. The code I got now is; SaveName = Environ("UserProfile") & "\Desktop\ " & _...
  7. C

    Loop through range. Use range data as input

    I am struggling to add further functionality to my code. I would like for my code to run a loop through a range of dates, found in column "E:E", and thereby use this input into cell C2 and then perform the rest of my code - saving the file to CSV (SaveAsCSV()). The spreadsheet is such that it...
  8. D

    Run-time error "53": File not found

    Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...
  9. D

    Password protect or prohibit the "Save" & "Save as" option in Excel

    Hello everybody, I am currently managing an order form in Excel, where people download it and then they go in every day, fill out the details and submit the order through a macro. They will just need to download it once and then do this whenever they have an order. However, is there any way in...
  10. M

    VBA Save File to SharePoint and Choose Property Type

    Hi I had an excel file where one of the macros saved the file as a new workbook to the users last open folder. I now want to save the new file in to a SharePoint library folder but as the user has to choose a content properties, its coming up with a debug error. The content is a droplist of...
  11. A

    Issue with Outlook VBA to Save Emails - Replies not Saved

    Hi all, I found some code on the web and am trying to adapt it. I need to categorize and save emails by their subject and time received so that I can reference them in a database. The below code works for new emails, but when i try to save someone's reply it creates an empty file. Public...
  12. A

    Application.Ontime switching workbooks

    This is a continuation of a post that is now buried. Application.OnTime continuously opening my workbook The Code @AlphaFrog helped with is working perfectly. Each instance of save, the workbook comes to the foreground and then to the background again after the save is completed. While this is...
  13. C

    Save workbook as PDF when PDF is already open

    I'm trying to save a workbook on sharepoint as a PDF (which I have working using this path \\xxxx.sharepoint.com\sites\xxxx\Shared Documents\) but when someone has the PDF open on either a network share or sharepoint I get the "document not saved" error. My question is, do I just have to wait...
  14. lockarde

    Change cell value upon save

    Good morning all, I have a workbook that tracks current in progress and completed jobs for the month. I'd like two cells, C2 & D2, to update upon every save with date (C2) and time (D2), so everyone that has access can easily see when the workbook was updated. Any help is greatly appreciated!
  15. W

    Help! Formulas Disappearing After Every Save

    Hello, I have a problem that I can't find any information on online. I hope someone here can help me. I work with excel workbooks that have several spreadsheets (tabs). On some of the workbooks (no rhyme or reason I can find), any formula that is pulling data from another spreadsheet within...
  16. P

    VBA to save some sheets as xlxs and some as PDF

    Hi, I am hoping for some help to for VBA code to save some sheets as xlxs and some as pdf. I am using the below code to save all sheets as xlxs with a filename as the name of the sheet within the workbook. Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N&...
  17. S

    Formatting date question ....

    I have data in columns G & H which is 13/11/2019 (ie, 13th November 2019) I want this date to display as 2019/11/13 When I formal cells > custom and enter the format as yyyy/mm/dd, this looks good. I save (as csv) and reopen the file, but it reverts back to it's original formatting? How do I...
  18. A

    re-run the macro if command button is clicked

    Dear Learned people I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" . I added a command button "Save & New" on a user-form in a certain position in the code. I would like for the user to save the workbook (Save As) and then...
  19. S

    Pls help how to Add multiple rows with same value of combobox through userform

    I have created a userform Which have a combobox and a text box, save button. Now when i select a value say"ABCD" in combo box, i will mention say number as "5". Now when i click on save button, then 5 rows of value "ABCD" should be created in excel cells in the column i specify. And next time i...
  20. K

    Pop up message box

    Hello all, I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the...

Watch MrExcel Video

This Week's Hot Topics

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
Top