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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Check out the worksheet SaveAs method in VB help, with particular attention
to the File Format parameter.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Worksheets from a workbook and saving them as a .prn file 1
Problems With PRN File 1
Importing .PRN files into Excel spreadsheet 2
Creating PDF from Excel Using PrintToFile 6
Don't want to hard-code file name in macro 3
Run-time error ‘13’ mismatch type 1
Remove extension 5
Prn file carriage return deletion within notepad 6

Back
Top