This page is presented by www.haserodt.de  Impressum Download Register - Buy now   Help

Actual Version: 4.2.0

VBA

There is a possibilty to automate via VBA.
You need a reference to EJHTML4E and then you can use the function EJHTML4e.AccessVBA.

Example:
Option Explicit
Public Sub TestEJH()
'Needs a reference to EJHTML4
Debug.Print EJHTML4E.AccessVBA(1, Range("a1:a4"))
End Sub

This function needs two arguments:
Buttonnumber (1 - 6)

ButtonNumber
1
2
3
4
5
6

and second argument the range as range.


Precondition is, that all flags are set in Excel Jeanie Html as you need it.
The function returns the created html-code as string and put's it to the clipboard.

Important:

Only one range!

Still all messages will be displayed.
It's only an automation for buttonclicks.

Top   Home