Folder Problems

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

Postby Franco403 » Thu Mar 03, 2011 8:40 pm

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?



Softland
Posts: 1496
Joined: Thu May 23, 2013 7:19 am

Postby Softland » Fri Mar 04, 2011 1:37 pm

Hello,


Please send us the XLS file with the macros to support@novapdf.com so we can troubleshoot this further.


Thank you.




Return to “Troubleshooting”