Convert numbers or currency values to words in Excel with VBA e.g. 123.45 becomes One Hundred Twenty Three Dollars and Forty Five Cents. I have a function that I wrote about 10 years ago or so in Excel 4.0 format. This format is more like a spread sheet that a VBA macro. I would like to convert it to Acad VBA and be totally separate from Excel. My question involves the excel function uses a large table to lookup values to use in its calculations. 'In order to use the macro you must enable the Acrobat library from VBA editor: 'Go to Tools - References - Adobe Acrobat xx.0 Type Library, where xx depends 'on your Acrobat Professional version (i.e. 9.0 or 10.0) you have installed to your PC. 'Alternatively you can find it Tools - References.
-->Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function.
Syntax
expression.ExecuteExcel4Macro (String)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| String | Required | String | A Microsoft Excel 4.0 macro language function without the equal sign. All references must be given as R1C1 strings. If String contains embedded double quotation marks, you must double them. For example, to run the macro function =MID('sometext',1,4), String would have to be 'MID('sometext',1,4)'. |
Return value
Variant
Remarks
The Microsoft Excel 4.0 macro isn't evaluated in the context of the current workbook or sheet. This means that any references should be external and should specify an explicit workbook name. For example, to run the Microsoft Excel 4.0 macro 'My_Macro' in Book1 you must use 'Book1!My_Macro()'. If you don't specify the workbook name, this method fails.
Convert Excel 4 0 Macro To Vba File
Example
Excel Vba Convert String To Integer
This example runs the GET.CELL(42) macro function on cell C3 on Sheet1 and then displays the result in a message box. The GET.CELL(42) macro function returns the horizontal distance from the left edge of the active window to the left edge of the active cell. This macro function has no direct Visual Basic equivalent.
Support and feedback
@ 4:0 Mark Zuckerberg
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
