I want to open a workbook in one folder, and then use a command button to have a completed worksheet saved to a different folder. The filename is based on the contents of two cells in the worksheet. Here is the code that I am using for the command button.
ChDir "\\lpofs01\groups\Engineering\LAB\MI Calculations for Offspec Types"
ActiveWorkbook.SaveAs Filename:= _
Range("C3") & "_" & Range("C5") & "_MI Calc", FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
My problem is that the file will save in the folder that the worksheet is opened, not the folder that I designate in the ChDir statement.
I am puzzled because I have other worksheets that I do the same thing and they work fine.
Thanks for the help.