tags:

views:

50

answers:

1
+3  Q: 

VBA to Javascript

I built a macro in Excel to pull data from a website and I'd like to recreate that macro in a Google Spreadsheet (regular or apps). The excel file uses VBA and I believe google only uses javascript.

Is there a way to get around this? I don't know javascript and wouldn't be able to use what I built in google.

+1  A: 

Google Docs offers the ability to pull some web info without macros/javascript. You may want to google "Google spreadsheet and xxx" (xxx is what you are trying to pull from the web) and see what you come up with.

Also, you have the ability in gDocs to insert Widgets (which are the javascript bits), but it may not be possible to fully clone your VBA macro in gDocs. They don't provide the flexibility of Excel.

Posting your code may help get more detailed answers.

guitarthrower