Where can i learn excel & vba?

[Para80d]

I'm a visual basic programmer, just never messed with excel. Now i need to up at work, gotta write some vb code for excel to get some information from SQL Server 2k and then make a report. But i don't know anything about programming for excel with vba.

If someone out there could point me in the right direction, i'd appreciate it.

[RobDog888]

You should be able to find some examples here throughout the
forums. If you record a macro in Excel and then view the VBA
code that it recorded would be a good way to learn the methods,
properties , and functions that Excel has to offer.

Another thing is to automate Excel from VB.
Add reference to MS Excel x.x

Private moXL As Excel.Application
 
Private Form1_Load()
 
    Set moXL = New Excel.Application
    moXL.Visible = True
 
End Sub

etc.
Then you can retrieve the data from SQL using VB and then
manipulate Excel to populate the spreadsheet with SQL data.