macro - autosave

  1. V

    Workbook with Timer Macro Saving After Closing

    I have a workbook that has a timer macro in it that will save and close the book after 2 minutes of inactivity. That works fine. When you have another instance of excel open, and you close the workbook that has the timer macro in it, the workbook with the timer macro will still save, you can see...
  2. G

    VBA Macro - Save entire workbook as PDF

    Hi there, I am trying to create a macro to save an entire workbook (4 sheets) to one PDF. I can find VBA to save the active sheet but not the entire workbook. It just needs to open the Save As menu and automatically have PDF as the save as option so I can then choose the file location to save...
  3. Jyggalag

    Refer to cell using date format with formula?

    Hi all, I have the following formula: It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today. However, I am also referring to cell C7 in another cell, specifically like this: My issue is, obviously, that the cell...
  4. S

    Advanced filtering of data into other sheet and copying the same sheet into a new workbook

    Hello ..!! This is my 3rd thread with Mr.Excel and my journey here is making me visualize what all can I automate using VBA and becoming successful with smaller macros for now. Thanks to everyone who is making my journey here fruitful ..!! :) So I am here with a request for macro that I need...
  5. P

    Macro to export text file based on worksheet parameters

    Hi Macro Experts!!! I need help creating a macro that will save a range (F#:DD#) based on the supplier value in column C as a text file. I included a screenshot of what my spreadsheet set up looks like. I need a separate text file for each supplier (Column C) that contains all of the data...
  6. M

    How do I notify the user that a backup (save) has completed succesfully

    Hi guys. I have bit of code that clears a sheet, before it does that I have it save to another location (just incase the user pressed the wrong button), my question is, is there a way to notify the user hat the save is succesful before thy carry on? Here is hat I have already. If...
  7. B

    Save to new file in range using Macro

    Hi, I have a file with thousands of rows. I created a macro to select 500 rows, copy past in new sheet, save as .txt and delete rows. 1) How do I increase the file name by one each time. So let's say I want to save it as Book1, Book2 etc. 2) how do I repeat it over and over again until all...
  8. M

    VBA: If Auto filter has no data then it has to move to next filter

    Hello Experts, Requesting you to review my macro. i have tried little bit and i am new to this so please help me out. I want to save the file into two different format based on criteria that i have done. but while filtering if no data for that respective criteria then it has to move to next...
  9. W

    Macro - Save specific open wrksheet with a varying file name

    Hello Everyone, Hopefully this is an easy fix. I have a large file that I backup every 30 minutes due to it corrupting frequently. I have created a macro to save a new version of the file with a variable name (based on date and time) as follow: "YYYY-MM-DD-HH-MM_FileName.xlsm". It works out...
  10. O

    Duplicates removal/prevention in VBA ( New to VBA)

    Hi All: it's actually my first post here, and I am practically new to VBA, so bare with me:). I am running macros that import data from a .txt file, organize it, and then append the new data to historical data base. Since I am running a macro of macros, and finally closing file and saving...
  11. M

    Macro to convert spreadsheet to PDF?

    I was wondering if someone could create a macro that could convert and save a spreadsheet to a PDF, but also, save it as version 2, or anything to distinguish it from the old one if it was already saved? I'm new to excel so any help would be appreciated.
  12. Z

    Macro for quotes

    I am working on a Macro (1st time ever) for my quotes. I have it just about how I need it, however, there will be multiple users and I need it to clear multiple sheets and save all sheets to a new Macro Free excel doc, and I need it to Pdf the first sheet only, and print first and second sheets...
  13. P

    macro to save as pdf with name from bookmark

    hi all, i'm trying to create a command button in word and attach a macro that automatically saves the doc as a pdf to a specified folder with file with the name coming from 2 bookmark references with a space and dash in between name. here is what i have so far: Private Sub...
  14. S

    Macro to update, hide and save

    Morning, I have developed the following Macro in order to- update, hide some columns and save the file. But, it keeps giving me the following error: This action will cancel pending data updates. Would you like to continue?- And, it does not matter whether yes or no, because the data is not...
  15. D

    Macro to copy and save cells by name to new workbook

    Firstly, thank you for the invaluable information I get in here. I am no graceful in my macros but they work so i can't complain. I have 4 Questions I have a purchase order macro. Command Button is clicked and it opens a workbook and saves selected cells to next available row and saves workbook...
  16. Z

    Need help merging this code together

    I am looking to run the retrieveColumns code first, which copies select columns from source document and moves these select columns to a new workbook. Then I want to run the saveworksheetscsv code to save the new workbook as a .csv Sub RetrieveColumns()Dim nmary As Variant, sh1 As Worksheet...
  17. R

    Add "Filter out Blanks" to current code:

    So this code will take the active workbook, save each sheets "VALUES" to a new workbook. However, if there are values on Row 1056 in the master "book" there will not be any value in the "NEW SAVED WORKBOOK" until Row 1056. Therefore, upon saving the new workbook, I need to have that new...
  18. T

    New to Macros (Please Help)

    I have a problem with sharing an excel product, so I'm left at the mercy on relying on others to close out the product when they're done. This workbook is utilized by many people, but can't be shared due to the tables and formulas therein. So, how can I create an Auto-Save Auto-close...
  19. H

    Combining 3 Macros into 1 - Save As Cell Names

    Hi all, I've been working on this for a little while now and it is probably obvious but I'm having trouble combining 3 pieces of VB script to into one routine. The context is that a team regularly have to take an excel workbook and go through several stages to process it. They have to...
  20. A

    VBA Macro to copy paste and create and save a new from from data file

    Hi all: I need help on the following: Scenario: I have a master database of information in Excel Called Data. It has a lot of fields. I have a form that I need to automatically filled with each row data from the master and then a save the form with a specific style (AgencyName_SiteAddress in a...

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