saves

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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