Results 1 to 2 of 2

Error in Excel 2007 from 2003 version: saving ActiveSheet as prn file

Threaded View

plane-crazy Error in Excel 2007 from 2003... 03-03-2011, 07:23 AM
royUK Re: Error in Excel 2007 from... 03-03-2011, 07:26 AM
  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    Guildford, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Error in Excel 2007 from 2003 version: saving ActiveSheet as prn file

    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.
    Last edited by plane-crazy; 03-03-2011 at 08:09 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1