activeworkbook.savecopyas

  1. M

    How to reverse string order in file naming macro?

    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...
  2. S

    ActiveWorkbook.SaveCopyAs crashes excel on 2. run

    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...

Some videos you may like

This Week's Hot Topics

Top