ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   After using Acrobat Distiller object, certain formatting causes error (https://www.excelbanter.com/excel-programming/280102-after-using-acrobat-distiller-object-certain-formatting-causes-error.html)

Zink

After using Acrobat Distiller object, certain formatting causes error
 
Strange situation - I have a routine that creates adobe
files and uses the CDO library to email them out. After
running this procedure, certain formatting functions, like:

Like the following:

wksFin.Range(wksFin.Cells(FIN_DATE_ROW, FIN_X_COL),
wksFin.Cells(FIN_DATE_ROW, FIN_X_COL)).NumberFormat
= "m/d/yy"


This causes the error
"Unable to set the number format property..."

Routine is usually fine - it's only after running a
certain piece of code totally unrelated that the sheet
starts giving all kinds of errors then crashes.


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com