This may be a really stupid question about "macros"/"VBA", but...

[Steve Maser]

So, I read that Office 2008 isn't going to have "VBA" support.


What, exactly, does that mean?

If I currently have a set of spreadsheets where one references a
"macros" spreadsheet containing commands like:


Begin
=ECHO(FALSE)
=ADD.BAR()
=ADD.MENU(A5,$B$4:$D$12)
=ADD.MENU(A5,$B$15:$D$21)
=ADD.MENU(A5,$B$23:$D$26)
=ADD.MENU(A5,$B$28:$D$29)
=ADD.MENU(A5,$B$33:$D$35)
=SHOW.BAR(A5)
=ERROR(FALSE)
=ACTIVATE("Encumbrance Spreadsheet")
=IF(ISERROR(A13),OPEN("Encumbrance Spreadsheet"))
=UNHIDE("Encumbrance Spreadsheet")
=ADD.COMMAND(1,2,B11)
=ACTIVATE("EncumbranceMacros")
=HIDE()
=ACTIVATE("Encumbrance Spreadsheet")
=RETURN()


EncBar
=ERROR(FALSE)
=HIDE()
=UNHIDE("Encumbrance Spreadsheet")
=ACTIVATE("Encumbrance Spreadsheet")
=IF(ISERROR(A27),OPEN("Encumbrance Spreadsheet"))
=SHOW.BAR(A5)
=RETURN()


New
=ECHO(FALSE)
=PROTECT.DOCUMENT(FALSE)
=SET.VALUE(H68:H86,"")
=DIALOG.BOX(Enter)
=IF(A59=FALSE,GOTO(A84))
=SELECT(INDEX(!Database,3,0))
=INSERT(2)
=IF(H68<>"",FORMULA(H68))
=IF(H69="","rc[1]",FORMULA(H69,"rc[1]"))
=IF(H70="","rc[2]",FORMULA(H70,"rc[2]"))
=IF(H71="","rc[3]",FORMULA(H71,"rc[3]"))
=IF(H72="","rc[4]",FORMULA(H72,"rc[4]"))
=IF(H73="","rc[5]",FORMULA(H73,"rc[5]"))
=IF(H74="","rc[6]",FORMULA(H74,"rc[6]"))
=IF(H75="","rc[7]",FORMULA(H75,"rc[7]"))
=IF(H76="","rc[8]",FORMULA(H76,"rc[8]"))
=IF(H77="","rc[9]",FORMULA(H77,"rc[9]"))
=IF(H78="","rc[10]",FORMULA(H78,"rc[10]"))
=IF(H79="","rc[11]",FORMULA(H79,"rc[11]"))
=IF(H80="","rc[12]",FORMULA(H80,"rc[12]"))
=FORMULA("=IF(RC[-2]="""",RC[-11]-RC[-1],0)","rc[13]")
=IF(H81="","rc[14]",FORMULA(H81,"rc[14]"))
=IF(H82="","rc[15]",FORMULA(H82,"rc[15]"))
=IF(H83="","rc[16]",FORMULA(H83,"rc[16]"))
=IF(H84="","rc[17]",FORMULA(H84,"rc[17]"))
=IF(H85="","rc[18]",FORMULA(H85,"rc[18]"))
=IF(H86="","rc[19]",FORMULA(H86,"rc[19]"))
=CELL.PROTECTION(FALSE,FALSE)
=PROTECT.DOCUMENT(TRUE)
=RETURN()


etc...



where the macros, are called by a "master" spreadsheet to run these
commands, etc...


Is *this* using VBA? Or is VBA something entirely different than basic
"macros" (which I'm guessing would be supported in Excel 2008?)


Thanks for answering this probably really stupid question (but I'm
inheriting these spreadsheets from somebody else and really don't know
diddly about VBA...)


- Steve

 

[JE McGimpsey]

Is *this* using VBA? Or is VBA something entirely different than basic
"macros" (which I'm guessing would be supported in Excel 2008?)


Thanks for answering this probably really stupid question (but I'm
inheriting these spreadsheets from somebody else and really don't know
diddly about VBA...)

Not a stupid question. Your macros are written in XL4 Macro language,
which will continue to be supported. VBA is the language that Office
macros have used since XL7 and is a compiled language. It's the expense
and time it would take to update the compiler for Office2008 that is the
primary reason for dropping it.