Search found 6 matches
- Wed Apr 15, 2015 9:20 pm
- Forum: Programming
- Topic: Switch OptionSet in VBa
- Replies: 0
- Views: 142465
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.....
- Wed Apr 15, 2015 9:13 pm
- Forum: Programming
- Topic: printing from Excel VBA
- Replies: 0
- Views: 149560
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...
- Wed Apr 08, 2015 12:55 pm
- Forum: Programming
- Topic: printing from Excel VBA
- Replies: 0
- Views: 149560
Re: printing from Excel VBA
This problem has been solved, special Thanks to Jacob
- Wed Apr 08, 2015 10:50 am
- Forum: Programming
- Topic: Switch OptionSet.ini in VBA?
- Replies: 0
- Views: 138145
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...
- Mon Apr 06, 2015 3:13 pm
- Forum: Programming
- Topic: Switch OptionSet in VBa
- Replies: 0
- Views: 138756
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...
- Thu Feb 26, 2015 7:35 pm
- Forum: Programming
- Topic: printing from Excel VBA
- Replies: 0
- Views: 149560
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 [...