create and populate an Excel file using vb

I would like to create and populate an Excel file.

For example:
   How would I set row 5 to a height of 32.
   How would I change the name of sheet 1 to my sheet.

Is there a good book I could look at to address these questions and may more?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
Hi jc31415,
Sub Test()
Rows(5).RowHeight = 32
Worksheets("Sheet 1").Name = "my Sheet"
End Sub


byundtMechanical EngineerCommented:
John Walkenbach probably has the best book on Excel VBA for beginners through medium experience. Excel 2003 Power Programming with VBA is the latest version of it.

You ought to investigate the macro recorder. It's a great way to learn the syntax and objects that you need to work with. You access the macro recorder through the Tools...Macro...Record macro menu item. Once you launch the macro recorder, it watches the manual operations and writes VBA code that will execute them. It is then very desirable to edit the VBA code, because the macro recorder almost always includes lots of fluff. It is quite common to shrink a recorded macro by 80% through hand-editing--and the edited code will run much faster as well.
jc31415Author Commented:
I may have asked this question in the wrong place. I do not want to write a macro that is accessed through Tools.
I want to write OLE code that is external to Excel which creates and populates an Excel file.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

byundtMechanical EngineerCommented:
I transferred your question to the Visual Basic TA. That should be a better place to get the right assistance.
byundt--Excel TA Page Editor
Amritpal SinghCommented:
have a look at the following link for full xample

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jc31415Author Commented:

    That link was very helpfull. Are you aware of other example that make use of VB OLE commands? I am trying to get as complete a list of OLE commands as possible.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.