information sources

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Information sources

Information sources

resolvedResolved · Low Priority · Version 2007

Anamaria has attended:
Excel VBA Intro Intermediate course

Information sources

is there any "best book" to use for quick references and use of VBA coding?

RE: information sources

Hello Anamaria,


Thank you for your question regarding books on vba.

My recommendation is a book called Master Visually Excel VBA 2003. They have never updated the manual, but all 2003 code is suitable for all versions including 2010.

The book can be picked up cheaply, and each page covers a separate command, so if you need to add a chart, or import data, or save multiple books etc.. code is described per page. Very clear.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Tue 30 Aug 2011: Automatically marked as resolved.


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.09 secs.