>>I'm having to do quite a few projects that involve the use of OLE with Excel and Word, I was wondering where is a good source to get some hints and tips on using OLE with Excel and Word. If you can share some knowledge I would be so greatful. Thank you in advance.
>>
>>Vic
>Victor,
>Unfortunately I don't have any extra resource such as books, OLE tips etc. All I have got is the hlp files (vbawrd8.hlp, vbaxl8.hlp etc) that installs with office. And constants header files.
>Other than that there is code I wrote for testing + real projects.
>The biggest tip with them is :
>Record a macro
>Furnish the macro code in VFP, replace all named arguments with positional arguments. You could check portion of code (_SampleMerge) macro recorded, if you comment it out and record corresponding macro.
>Cetin
You could try
http://www.amazon.co.uk/exec/obidos/ASIN/0201410354/qid%3D935661017/026-7880614-2623427 (The Underground Guide to Microsoft Office, Ole, and Vba : Slightly Askew Advice from Two Integration Wizards) which is cynical enough to be really helpful although it's gettting old now and I wish that they'd issue a new edition.