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