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
2k stars 493 forks source link

vba-web in word 2010 windows #176

Closed gerald2545 closed 8 years ago

gerald2545 commented 8 years ago

Hi all, sorry, I didn't found a way to ask my question elsewhere and didn't found the information in the docs.

Does VBA-Web useable in a word document? if yes, how can I use it in word?

Thank you for your help

Gérald

timhall commented 8 years ago

Hi @gerald2545 I have tested it in Word 2013 and it works, so it should work in 2010, but if it doesn't please let me know in case there are some compatibility changes I can make.

How to install manually (needed for Word and Powerpoint):

  1. Download the latest release
  2. Import everything from src to your project except for WebAsyncWrapper (only compatible with Excel + Windows)
  3. Download the latest release of VBA-Dictionary and import Dictionary.cls to your project

(I'll add the above to the Wiki shortly)

Let me know if this works for you. Note, some of the examples are Excel-only, but the maps example should work in Word. Add Maps.bas to your project and then add the following to a new module:

Sub TestDirections()
  MsgBox Maps.GetDirections("New York, NY", "San Francisco, CA")
End Sub
adjenks commented 5 years ago

@timhall Did you ever add the instructions? I can't seem to use the installer for Excel 2010, it says the workbook is protected but it is not. Even if I make a brand new xlsm file and try to use the installer on it, it fails. So I need an alternative installation method, I'll try importing from the src folder as you described.

adjenks commented 5 years ago

I did get it to work by just adding all the src files. What is the purpose of the installer? Not to be rude, I just don't understand why people can't just add the library files to their projects like any other programming project. What does the installer do aside from this?