saves

  1. H

    MsgBox keeps popping up

    I have this code that almost works, but has one issue. I think i know why, but dont know how to fix it. As dates are entered elsewhere, G11 counts them. When G11 = G16, it throws up the MsgBox. So far so good. When I hit 'OK' on the MsgBox, Step 1 occurs (saves the file), but then the MsgBox...
  2. 5

    Excel saving a file witout quotations

    Hey, I am trying to make some VBA that saves one row of data from a spreadsheet and saves it as a PRN file which I can do but it adds quotation marks to the start and end of every row, how do I go about removing them without having to do it manually? Here is my code...
  3. S

    How can i make a workbook print to multiple printers

    Hi All, I have a workbook that will automatically print a worksheet within it when certain conditions are met. The problem I have is that this is a multi-user workbook who work from different pc's. I want the automatic print to print to the printer that is closest to the users pc. The workbook...
  4. S

    Question about saving to text delimited file

    Hi there. I have the following, which saves the current tab as 12.txt. Is there a way to specify the path? Is there a way to make it stop and not overwrite the file / prompt a message if 12.txt already exists in the location? And finally, I notice that when it saves, it basically closes out...
  5. M

    Auto create PDF at set time AND have it change the file name each time

    Hi all, Hopefully this is possible. I have a workbook containing around 100 or so sheets. The first sheet is the summary sheet, that contains amounts owed by each customer. These are displayed as a list from top to bottom, with the amounts owed beside each name in the adjacent column. What I...
  6. M

    Need help creating a marco please

    Hello, I need help making a macro for my excel sheet: I need a macro that saves a document into a certain folder but when it saves the file it needs to have all the cells be saved as "Values(v)" because currently have the cells get as formulas and other macro wont run cells if they have formulas...
  7. HomeTek

    Hyperlinking to a shortcut which saves to desktop

    I've tried to search for help on this but struggling with the keywords I'd need to find a query like this. Basically I'm wanting to know if it is possible to create a simple text hyperlink to an application, but when the hyperlink is clicked rather than taking the user to the original...
  8. M

    Vba auto save every 5 minutes. Help

    Hi everyone, I am trying to auto save a worksheet every 5 mins using vba code. I have saved the code to workbook and module and it saves every 5 mins. Issue is it reopens any excel file that was open and it saves those files too. Any suggestions?? Thanks in advance. Saved in workbook...
  9. D

    Saving as new spreadsheet

    I am trying to create code to save my workbook, then save it again as a string entered in a textbox. I then want it to close the new workbook and reopen the original one. The workbook name can change so I can't use the name of the workbook as a reference point. I have this code so far: Private...
  10. S

    Making new Directories

    I have an workbook that will save as as required. I know how to make a specific directory with the MkDir code but here's where I get stuck. I'd like a piece of code that will check for the number in a specific cell (let's say Sheet1, Cell "A1") and will make a new folder if and only if the...
  11. R

    VBA Save

    I have a file that saves everyday at 1am. It is locates on a network drive in a specific folder. I cant figure out why it saves to the drive and saves to the local PCs documents. Sub sveWrkBk() Application.DisplayAlerts = False ActiveWorkbook.Save Application.OnTime...
  12. P

    Pivot Table Issues

    Hi everyone, I have a workbook that a macro opens, saves, and information is pulled from that excel. Problem is: the Workbook will not update while macro is running. The worksheet opens, everything is 0 and then it saves as everything 0. When I leave it open after macro finishes, it will update...
  13. V

    File name from two cell values

    Hello All This code saves my excel sheet as a PDF and then saves this named as Range "H7" How can I change this please to save as "D19" & "-" & "H7" Sheet1.Range("A4:J56").ExportAsFixedFormat xlTypePDF, Filename:= _ "C:\Invoices\" & Sheet1.Range("H17").Value, Openafterpublish:=True
  14. A

    PDF Exporting Issue

    Good morning all, After hours of grappling, I've got the macro I'm writing to do what I want bar one last bit. With ActiveWorksheet ChDir Sheet8.Range("F2").Value fname = Sheet8.Range("I2").Value ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF...
  15. S

    VBA saving one folder to short

    Hi All, I am trying to create a userform that saves itself with a file name based on the contents of a text box and to a location the user decides. I got the first part working okay, but when I go and save the file it saves one folder short of where I choose. For example if I want to save it to...
  16. S

    Saving sent emails with Excel

    I have a simple bit of code in Excel that creates an Email,adds an attachment and saves the email into the folder where the excel documentsits – easy enough so far. However it only saves the email in its ‘unfettered’state but I want it to save the email AND its attachments exactly as they...
  17. K

    Creating historical version of spreadsheet

    Hi all, Kinda fumbling my way through learning VBA/Excel. I'm going through different tutorials online and can't figure out how to do the following. Any help/tutorial links for this would be appreciated. I have a spreadsheet with financial data under a given month. I need to put a button in...
  18. S

    Why does my VBA code jump to ActiveWorkbook.Save without running the rest of the code?

    I have a long macro that works great every time I run it except if I try to save at the end. If I put ActiveWorkbook.Save at the end it skips the code in front of it and just saves and does nothing else. What would cause this? I'm using the latest Excel and windows 10.
  19. B

    Change Value In Workbook from Outlook Macro

    So I have a Macro that Opens an Attachment, and saves it in a shared drive location. After it saves I need to change the value of A1 to "Hostname" Set objApp = CreateObject("Excel.Application") objApp.Visible = False Set wb =...
  20. A

    why is this file so big?

    https://www.4shared.com/photo/f0Q3CCCyca/FILE_SIZE.html https://www.4shared.com/rar/eP0V5IQ_ca/TAX_2017.html i dont know how to upload excel files i put them on a shared thingy so you can download them. i have a 5 column - 50 row spreadsheet. please tell me why it saves at 15MEG !! it is now 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