activeworkbook.savecopyas

Hello, I have a very basic question. I want the below macro to output an xlsx file, not a macro file. I have tried changing the extension and the FileFormat but the copied file does not open. I get a message that the file types are different. Any and all assistance is appreciated. TIA Sub...

Hi All, I have been trying to search in the existing threads for a solution to my question and cannot seem to find one. I am trying to create this generic SaveCopyAs macro to save a copy of my current file with the current date in a "Superseded" folder in the current directory where my file is...

I have the following working well for saving files and making version backup copies in two different locations. for sorting purposes I would though like to change the order of the file name strings. File name first, date and time stamp second. Have not succeeded yet. Appreciate if anybody can...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m working on an excel workbook where I need to take out 2 worksheets and save as another workbook.<o:p></o:p> <o:p></o:p> The code below runs fine the first time the macro is used in the...