Folder Problems

[Franco403]

Since updating my DoPDF software to ver7 from ver6 the VBA macro I wrote to print an Excel file into a specific folder will no longer work:

___________________________________________________________________________________

Sub Printing()

'

' Printing Macro

'

'Print the file in PDF format
ChDrive "z"

ChDir "\Invoices \Statements\PDF\"

Application.ActivePrinter = "doPDF v6 on DOP6:”

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""doPDF v6 on DOP6:"",,,,FALSE)"
End Sub

___________________________________________________________________________________

This works perfectly, if you accept the default location the file will be created in the folder “Z:\Invoices\Statements\PDF\” exactly as I wish.

However if the macro is changed to use ver7:

___________________________________________________________________________________

Sub Printing()

'

' Printing Macro

'

'Print the file in PDF format
ChDrive "z"

ChDir "\Invoices\Statements\PDF\"

Application.ActivePrinter = "doPDF v7 on DOP7:"

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""doPDF v7 on DOP7:"",,,,FALSE)"
End Sub

_____________________________________________________________________________________

The default folder location is “E:\My Documents”. For this reason I still use ver6 for VBA printing and ver7 for manual conversion. Does anyone know if I can fix this problem please or is it a limitation of the new version?

[Claudiu (Softland)]

Hello,
Please send us the XLS file with the macros to [email protected] so we can troubleshoot this further.
Thank you.