save to folder

Hi, Breaking the problem into small parts. I want to use VBA to save an copy of a workbook to a specific locations, documents on C drive as an example. The file name will be taken from the data in cells A1 and A2 for identification. So first, save the file named from cell/s data. Then save as to...

I feel the answer to this question is real simple but I'm VERY new to power query and haven't found a way to do this yet. I have built a few queries where I save reports to a folder, it pulls the files consolidates and re-formats them when I click refresh. This is wonderful. But now I need to...

Hello All, I have a project which requires a tool that is capable of looking at a set list of file names, a specified sub folder and seeing if the file exists, if so, then make a copy of the file to a specific Directory and update the workbook that I will trigger the code form with a "Saved...

Hello, I'm having trouble with what should be a very easy excel problem. I am opening a file from my desktop and running it through a macro. I then need to save it to a specific folder and would like the macro to do this for me. I tried just recording a macro: ActiveWorkbook.SaveAs...

Help would be appreciated. I would like a script which would save my file named Xtemplate to a folder named C:\Temp\ExcelTemplates\ The only thing is I would like it if the script could add a new number to the file name if the file already exists in the destination folder. I.e. Xtemplate...