save as cell name

Hi I have this save button, that saves: 3 sheets into pdf 4 sheets into a new workbook (xlsm) 1 sheet into a new copy inside the workbook My problem is if i want to save the sheets again it dosn't overwrite the old one. So my question is how to change the code so it overwrite existing files...

Hi All, Appreciate any help with this. I want to save a file using VBA into a specified folder on the server. Most of the save location will not change so I would like to have the first part up until the final folder hard coded into the vba. However, I would like the final folder name to be...

First off any input is greatly appreciated, here's what I am trying to accomplish via Macro/VBA code: 1. Copy cell A2 on tab 2 to cell $A$2 on tab 1 2. Copy cell B2 on tab 2 to cell $B$2 on tab 1 3. Copy cell C2 on tab 2 to cell $C$2 on tab 1 4. File Save As (make the save as name equal to...

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 Excel gurus, I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help! I'm looking to : 1) Open multiple file names from my F drive. Details - With the file name of "issue303661.txt" the following file would typically be consectuive...

Hi there, I've searched the forum but can't find exactly what I need. I would like a macro to be able to save 26 tabs within the one document to individual PDFs. Preferably I would like to be able to specify each time exactly which tabs get printed, because often I don't need to print all 26...