Folder Problems

Post here if you have problems installing or using doPDF.
Post Reply
Franco403
Posts: 1
Joined: Thu Mar 03, 2011 1:03 pm

Post by 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)
Posts: 1560
Joined: Thu May 23, 2013 7:19 am

Post by Claudiu (Softland) »

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

Follow us to stay updated:

Post Reply