VBA: basic syntax and sample tutorials

Question

At work, I work closely with MS-Office. I managed to create several scripts that perform various tasks. Although I can transfer functions to VBA with some difficulty, I do not fully understand the basics of the VBA language.

Elements for which I am looking for basic syntax and examples include: "hello world", loops, flow control, variable declaration, variable type conversions, objects (if possible), file / user input / output, when the block is "c" can be used etc.

Can someone provide me with a link to a VBA tutorial, perhaps with details of the points above?

Answer 1

VBA post Office 2000 VB6. MSDN - . VB6 .

Answer 2

MSDN: Office VBA

, Visual Basic Office. Office Alt + F11, Visual Basic. F1 Help → Microsoft Visual Basic. , , VB6, VBA.

Answer 3

I think you will find this video tutorial quite useful:

http://developresource.weebly.com/10/post/2011/11/vba.html

And there are other great things you can find there, so try :)