Search found 6 matches

by Herrie
Wed Apr 15, 2015 9:20 pm
Forum: Programming
Topic: Switch OptionSet in VBa
Replies: 0
Views: 127681

Switch OptionSet in VBa

A double question a: does it make sense to programmatically switch OptionSet ini ? Example: before printing from vba (Excel) set a specific OptionSet file After finishing the job, set the 'original' OptionSet file would the code below be the best solution?? [code] Part from an existing sub routine.....
by Herrie
Wed Apr 15, 2015 9:13 pm
Forum: Programming
Topic: printing from Excel VBA
Replies: 0
Views: 133794

Re: printing from Excel VBA

the code I use now: [code] Sub PrintSheet(Optional sFileName As String = "", Optional confirmOverwrite As Boolean = True) On Error GoTo errhandle Dim oPrinterSettings As Object Dim oPrinterUtil As Object Dim sFolder As String Dim sCurrentPrinter As String Dim xmldom As Object Dim sProgId As String D...
by Herrie
Wed Apr 08, 2015 12:55 pm
Forum: Programming
Topic: printing from Excel VBA
Replies: 0
Views: 133794

Re: printing from Excel VBA

This problem has been solved, special Thanks to Jacob
by Herrie
Wed Apr 08, 2015 10:50 am
Forum: Programming
Topic: Switch OptionSet.ini in VBA?
Replies: 0
Views: 123350

Switch OptionSet.ini in VBA?

Dear readers, Does it make sense to switch between 2 OptionSet files in Vba? General idea is 1 OptionSet for common use 2nd OptionSet for use under returnung, specified circumstances? So, standard the 'common use' OptionSet is chosen, but under the other circumstances the 2nd OptionSet. In short Bef...
by Herrie
Mon Apr 06, 2015 3:13 pm
Forum: Programming
Topic: Switch OptionSet in VBa
Replies: 0
Views: 123995

Switch OptionSet in VBa

Just a question. ( :D ) Is it possible to switch from one OptionSet.ine file to another OptionSet.ini file? I run Bullzip as a sort of general printer, with almast the basic (default) setting, saved in 'StdOption Set.ini" and anther one 'Theeketel Option Set.ini" in my Vba Excel code, with different...
by Herrie
Thu Feb 26, 2015 7:35 pm
Forum: Programming
Topic: printing from Excel VBA
Replies: 0
Views: 133794

printing from Excel VBA

L.S., I get an error when trying to peint a (part) of a sheet (=printarea) [quote] C:\Ketel\offertes\2015\TEST\offerte 2015004 naam.pdf Error trapped by OnError eventhandler. Error= 438 Description= Property or method not supported by this object object Source=Offerte_Factuur Last: 0 Help: 1000438 [...