Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving file to *.prn format
Hello NG,
Can someone explain why I can not make this piece of code to work and help me correct it. The debugger always stop on the SaveAs command. testfile.xls is just a tabulation of numbers formatted as text. TIA. Jon-jon Sub Test_xls2prn() Workbooks.Open Filename:="c:\testfile.xls", ReadOnly:=True With ActiveWorkbook .Sheets(1).Cells(1, 1).Select Application.DisplayAlerts = False .SaveAs Filename:="c:\testfile.prn", _ FileFormat:=xlTextPrinter, CreateBackup:=False Application.DisplayAlerts = True End With ActiveWorkbook.Close True Kill "c:\testfile.xls" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving in new file format | Excel Discussion (Misc queries) | |||
Saving File Format | Excel Worksheet Functions | |||
Cell changes format upon saving file | Excel Discussion (Misc queries) | |||
Saving file in CSV format | Excel Discussion (Misc queries) | |||
Saving file in the format "YYMM" | Excel Discussion (Misc queries) |