VBscript commands for Excel 1

[BdR]

Is there some sort of reference where I can find al the commands that I can use in VBscript to handle an Excel sheet?

Thanks

 

[PHV]

If you're confident with VBA for Excel, you can use OLE automation to handle your workbook with VBS, keeping in mind the few diffs between this two flavors of VB.
Mainly in VBS you can't use typed var nor Goto instruction.
Feel free to do a keyword search in this forum for excel.

Hope This Help
PH.

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

for some samples of automation.

 

[jlindahl]

i also need some reference to some vbscript that can be used in excel. i use the Response.ContentType = "application/vnd.ms-excel" to display a table in an excell spreadsheet. i also make one of the cells a hyperlink, but the problem i am having is i cannot get the hyperlink to open in a new window. i guess my question is, does excel understand the properties of the html anchor tag? i use the target=_blank, but it still opens in the same window.

 

[mrmovie]

something i found today, if you look in c:\program files\microsoft office\office\1033 you will find a load of vba help files. each one is the object model for each application!!!! fantastic

regards,
vonmoyla

 

[SolidFish]

Would anyone know how to do ErrorHandler on VB within Excel? Since Goto statements are not allowed, I'm not sure what to do to handle error cases...

 

[tsuji]

Hello SolidFish,

You can take a look at the thread(329,698824) for idea on the general building block of error-handling.

regards - tsuji

 

[Mighty]

You might get some help here:

http://msdn.microsoft.com/library/d...s/dv_wrcore/html/wrgrfexcelworkbookobject.asp

Mighty

 

[SolidFish]

Great! Thank you guys so much.