Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka Visual Basic for Application).
This is planned to be an ongoing post, get back here as we are discovering more and more differences.
1: ASP may not have Optional used in Sub or Function line
2: ASP cannot do Goto ???
3: ASP cannot assign type to function on function line
4: ASP Cannot have Dim Arra(1 to 9), just Arra(9)
5: ASP cannot do Next I to close a For loop, just Next
6: Use Cint() instead of Val()
7: Use Fix() instead of VAL()
8: Gosub - Return DOES NOT work :(
9: Use FormatNumber() instead of Format()
10: ASP get type of variable using VarType(), 0,1,2,3,4,5,6,7,8,9,10, etc; see www.csidata.com/custserv/onlinehelp/vbsdocs/vbs218.htm
VBA get type of variable using TypeOf()
Views 307 Downloads 130
'asp', 'classic asp', 'vb', 'vbscript', 'vba', 'visual basic for application', 'macros', 'html', 'asp classic', 'asp v2'