Thanks you. i tried to reply yesterday but somehow my computer wont open the
popup.. anyway i was trying to use SaveAs and sure enough for pdf and xps, i
was supposed to use the ExportAsFixedFormat method. Thanks for pointing that
out..
Jun

"Jim Rech" wrote:

When I recorded a macro saving as PDF I got this:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,.....

xlTypePDF equals 0.

--
Jim
"Jun" wrote in message
...
| Hi all,
|
| I am trying to use offcie automation to convert a xls into pdf. I
installed
| the the save as pdf or xps addin and it worked fine from the application
but
| can find the right file format in the enum value.
|
| any help will be approciated.. thx
|
| here is the enum value in my system:
| public enum XlFileFormat
| {
| xlCurrentPlatformText = -4158,
| xlWorkbookNormal = -4143,
| xlSYLK = 2,
| xlWKS = 4,
| xlWK1 = 5,
| xlCSV = 6,
| xlDBF2 = 7,
| xlDBF3 = 8,
| xlDIF = 9,
| xlDBF4 = 11,
| xlWJ2WD1 = 14,
| xlWK3 = 15,
| xlExcel2 = 16,
| xlTemplate = 17,
| xlTemplate8 = 17,
| xlAddIn8 = 18,
| xlAddIn = 18,
| xlTextMac = 19,
| xlTextWindows = 20,
| xlTextMSDOS = 21,
| xlCSVMac = 22,
| xlCSVWindows = 23,
| xlCSVMSDOS = 24,
| xlIntlMacro = 25,
| xlIntlAddIn = 26,
| xlExcel2FarEast = 27,
| xlWorks2FarEast = 28,
| xlExcel3 = 29,
| xlWK1FMT = 30,
| xlWK1ALL = 31,
| xlWK3FM3 = 32,
| xlExcel4 = 33,
| xlWQ1 = 34,
| xlExcel4Workbook = 35,
| xlTextPrinter = 36,
| xlWK4 = 38,
| xlExcel7 = 39,
| xlExcel5 = 39,
| xlWJ3 = 40,
| xlWJ3FJ3 = 41,
| xlUnicodeText = 42,
| xlExcel9795 = 43,
| xlHtml = 44,
| xlWebArchive = 45,
| xlXMLSpreadsheet = 46,
| xlExcel12 = 50,
| xlOpenXMLWorkbook = 51,
| xlWorkbookDefault = 51,
| xlOpenXMLWorkbookMacroEnabled = 52,
| xlOpenXMLTemplateMacroEnabled = 53,
| xlOpenXMLTemplate = 54,
| xlOpenXMLAddIn = 55,
| xlExcel8 = 56,
| }
|