search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2.01k stars 494 forks source link

Application.Run compile error in Mac Word 2011 #100

Closed jcushman closed 9 years ago

jcushman commented 9 years ago

Thanks for the crazy-fast response to my issue in VBA-Dictionary, by the way! The solution worked perfectly.

The next error I ran into is a compile error in WebHelpers, in each of these three lines:

Set ParseByFormat = Application.Run(web_Callback, Value)
Set ParseByFormat = Application.Run(web_Callback, Bytes)
ConvertToFormat = Application.Run(web_Callback, Obj)

In each case, the result of compiling is:

Compile error: Wrong number of arguments or invalid property assignment

This is in Mac Word 2011; it does not happen in Excel.

With those lines commented out (since I'm not using a custom format), everything else has worked perfectly -- thanks so much for putting this project together.

timhall commented 9 years ago

These little inconsistencies are always so surprising and strange. Thanks for raising this issue, I'll see if there is a good way to bypass it in general for Word, but sounds like your solution is the best approach for the time being.

LawrieMcintosh commented 6 years ago

Thanks Tim, I had exactly the same problem. the EnableCustomFormatting Flag was super useful

LawrieMcintosh commented 6 years ago

In case you were intererested this only showed up for me when i tried to run my solution in 32bit windows. there was no issue on my VBA7 environment on my 64bit installation