What is VBA for?

[dave_br]

Forgive my ignorence guys, but it seems like VBA could be a great help to learning to use excel to a fuller level,

so....

what does/can it do?

waht is the best way to learn visual Basic? is it to go on a course or can it be self taught?

dave

 

[FunUnlimited]

I began learning VBA very recently by picking up a few books on the the subject. It can seem daunting in the very beginning for someone who has absolutely no programming background but from what I've read, VBA is a lot easier than than many other languages. Just stick to it and you will soon be writing some very useful code.

 

[Trevor G]

It can even be used to open up your DVD drive. (That's a fun little prank I like to play on coworkers from time to time)

That would be interesting to do? Would you be prepared to share the code !

 

[RoryA]

Something like this (for 32bit Office):

Public Declare Sub mciSendStringA Lib "winmm.dll" (ByVal lpstrCommand As String, _
    ByVal lpstrReturnString As Any, ByVal uReturnLength As Long, _
    ByVal hwndCallback As Long)

Sub OpenCDTray()
    mciSendStringA "Set CDAudio Door Open", 0&, 0, 0
End Sub
Sub CloseCDTray()
    mciSendStringA "Set CDAudio Door Closed", 0&, 0, 0
End Sub

 

[Trevor G]

Rory,

Thank you for that, will be interesting to see a few faces when I use this