Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #19  
Old 09-17-2013, 07:21 PM
BobBridges's Avatar
BobBridges BobBridges is offline Merge data from excel into word Windows 7 64bit Merge data from excel into word Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I don't use tutorials and texts much. I read documentation, mostly references and once in a while, when I'm desperate, user's guides. But such as I have give I thee:

Microsoft's Developer Network (MSDN) has their official documentation for all the Office apps, all versions, plus a lot more. Start there and drill down to "Office and SharePoint development" and "Office client development"; that'll show you a list of all the currently supported versions of Office. Pick the one you have. Say it's "Office 2010": There you'll see a list of Office apps: Access, Excel, Outlook etc. Choose "Excel 2010", then "Excel 2010 Developer Reference", then "Reference"; that gets you the documentation on each object used in Excel 2010, with a list of each object's properties and methods. Some of the articles are missing important elements, and this isn't nearly as convenient (to my way of thinking) as the CHMs they used to provide, but it's Official and it's a heck of a lot better than nothing.

I don't know whether it'll be helpful, but you may get some hints by looking at the Access development section; since you already know something about that, seeing the information there may tell you more about how the Excel section is organized. But maybe not.

For the VBA language itself, go back to "Office 2010" and then select "Office 2010" (yes, again). This has a list of various features of Office itself, rather than of any particular application, including "Visual Basic for Applications Language Reference for Office 2010"; select that, then "Visual Basic Language Reference" to see a general reference on VBA.

Another one I use a lot—dunno whether it'll interest you—starts at "MSDN Library" and then goes down through "Web Development" and "Scripting". Here you'll find a reference on VBScript, which is a flavor of VB that's cut down some from VBA but has the advantage of being usable in Windows, ie not from any Office application itself; you can write a VBS program in Notepad, then double-click on the icon to get it to run. Also under Scripting are a couple of objects that I find useful in VBA even though they're not documented in Office: The FileSystemObject, for example, which lets me read and write plain-text files, look up documents in directories and such. There's also an object for handling regular expressions; a handy thing, that, though it took me a while to learn what they're good for. If you start using VBScript much, there are some other handy sites too.

Other than that, when the MS documentation fails me (and it does; I try to write user add-ons, but for some reason it always experiences an error so I'm unable to fill in the gaps), I just google my question and discover that it's usually been asked before, and answered. That's how I found this forum, and there are a few others too. But no doubt if you use a search engine you'll find your own favorites without any pushing from me.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge data from excel into word data from Excel into Word table ragesz Word Tables 1 09-29-2013 06:14 PM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM
Merge data from excel into word How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
Merge data from excel into word Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
How do I set up the fields in mail merge word 07 from my data base mbcrabber Mail Merge 4 06-06-2010 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft