How do I set up a macro to save an Excel worksheet as a .prn file?

[cher]

I have a multipage workbook and I need to setup a macro to save "sheet 3" as
a seperate .prn file. I've tried using the SaveAs macro function with .prn
at the end of the file name but it still saves it in Excel form.

[Jim Rech]

Check out the worksheet SaveAs method in VB help, with particular attention
to the File Format parameter.

--
Jim
"cher" <cher@discussions.microsoft.com> wrote in message
news:21544295-22F3-4ACF-AA92-0FE2F553AA08@microsoft.com...
>I have a multipage workbook and I need to setup a macro to save "sheet 3"
>as
> a seperate .prn file. I've tried using the SaveAs macro function with
> .prn
> at the end of the file name but it still saves it in Excel form.

[cher]

I entered:

Activeworksheet.FileFormat=xltemplate Then
Active Worksheet.SaveAs Fileformat:=prn
End If

This is not working. I'm also no sure where to put in the path and file
name to Save As. The workbook is setup as a template.

"Jim Rech" wrote:

> Check out the worksheet SaveAs method in VB help, with particular attention
> to the File Format parameter.
>
> --
> Jim
> "cher" <cher@discussions.microsoft.com> wrote in message
> news:21544295-22F3-4ACF-AA92-0FE2F553AA08@microsoft.com...
> >I have a multipage workbook and I need to setup a macro to save "sheet 3"
> >as
> > a seperate .prn file. I've tried using the SaveAs macro function with
> > .prn
> > at the end of the file name but it still saves it in Excel form.
>
>
>