save_as

Hello, I have a macro created to save the file but for some reason .xlsm is being included in the actual name of the file. Can anyone figure out how I can prevent that from happening...

Hey all, Having a small issue with my vba code. The code is supposed to throw up a bunch of prompts to confirm saving and then clears out the forms and vba codes and then is supposed to open the new file and then closes the application. However, no matter where I put the Workbooks.open line...

I need this save as code to keep the workbook that I am working in open, and not open up the new workbook. currently it opens up the new file. I guess I essentially want to save the document as a new document, and then close it and reopen the old one. Sub SaveAsName()Dim save_as As Variant Dim...

Hi so I have this code, and it saves exactly like I want it to, but I dont want it to open itself up after it is saved, Id rather the current workbook I'm in to stay displayed. Sub SaveAsName() Dim save_as As Variant Dim file_name As String Dim ProgramName As String file_name = ProgramName...

Hi All, I am currently working on a macro that takes each worksheets from a workbook, copies it as a separate workbook and saves it using that particular worksheet's name. For example, I have a report with various departments as separate worksheets (Admin, Finance, Legal, etc). I want to copy...