file name save

Hi, I'm trying to find a way to add a ''save'' function at the end of my macro to save my file in Excel format (originally a .txt file), while keeping the same name the .txt had. I was able to either do one or the other (Excel file that didn't retain the original name, or text file with the...

Hi I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF, but then save it based on 3 cell Values, C4, C6 & C8. C4 is a name C6 is a name C8 is a date I'm wanting it to save to a specific file location to: C:\Users\Vector\Google Drive\H_O...

I have completed a workbook with several macros working well inside. The problem is that when I change the name of the actual excel file, none of the macros will work because they have the file name in the beginning of the macro name. This workbook is for budgets and will be saved down...

Hello, I'm new to and not well-versed in VBA, but have been working my way towards an automatic mailmerge. The last step which I can't seem to figure out or find an answer for is to save the mail-merged files with part of the saved name being drawn from a specified cell in excel, basically the...