I have a macro that used to work fine in 2003 but in 2007 gives an error on the line:
ActiveSheet.SaveAs Filename:="pltyss1.prn", FileFormat:=xlTextPrinter, CreateBackup:=False
next few lines are
ActiveWorkbook.SaveAs Filename:=working_file_full_name, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Sheets("pltyss1").Select
ActiveWindow.SelectedSheets.Delete
working_file_full_name = ActiveWorkbook.FullName
working_file_name = ActiveWorkbook.Name
Calculate
Application.Run ("Macros.RDT_start")
UserForm1.Show
End Sub
Any idea what's causing the problem. This is causing a distruption to work so a fast response would be very much appreciated.
Bookmarks