save to specific folder

I would like to copy specific files to specific folders using Excel VBA. I obtained code that can allow the user to select the files and copy them to another folder as defined by the `msoFileDialogFolderPicker`. How to modify the code such that the respective file goes to the folder as...

Hello everyone, I am using a script that will save a file to a specific folder based of a couple of cells. If the folder doesn't exist, the command fails. I cannot figure out how to get it to create the folder if it isn't there. Here is what I am using now: Sub File_Save() Dim Path1...

I'll start with saying I've never messed with VBA and Macros. My boss is looking to take a spreadsheet that breaks down the employees by manager, create new workbooks and save them by the managers name. I've been able to take the managers by filtering and then create the new workbook but I'm...

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 everybody. I have made an invoice in excel that make a new invoice number when opening etc. Everything is working fine but i need to save the invoice in a specified folder, which is also working fine. My problem is when i copy my whole work folder to usb and work on it from my laptop it...