>>One thing I couldn't find: how do I run an excel macro? Can't figure out >>the hierarchy, syntax or whatever is necessary. >>(VFP 5.0 and Office 97) > >You could record the macro and edit/copy the code into your VFP application >and do all the commands through OLE. > >Wayne I would have done that in the first place, if only I could - the macro is used for handling codepage to Unicode, and requires the ChrW() function, which is not available in VFP... or I could write another macro as a function, and return just the converted string (not using the search/replace macro) and then OLE stuff it there? Now, that pulls up another question - I don't know the scope of such a function, the proper syntax to call it etc. I'm stuck until further. [ and GMRIDER added: ] Try: oWDoc.ToolsMacro("MacroName",1) where oWDoc = ref to MS Word object, your name may vary... MacroName = name of MS Word macro, again, your mileage may differ yeah, I know, this is Word syntax, but it 'should' work in Excel, same VBA, right? :) hth eJ8+IhUCAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA1AEAAAEAAAAQAAAAAwAAMAMAAAAL AA8OAAAAAAIB/w8BAAAAUwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGZveHByb0B1bml2ZXJz YWx0aHJlYWQuY29tAFNNVFAAZm94cHJvQHVuaXZlcnNhbHRocmVhZC5jb20AAB4AAjABAAAABQAA AFNNVFAAAAAAHgADMAEAAAAbAAAAZm94cHJvQHVuaXZlcnNhbHRocmVhZC5jb20AAAMAFQwBAAAA AwD+DwYAAAAeAAEwAQAAAB0AAAAnZm94cHJvQHVuaXZlcnNhbHRocmVhZC5jb20nAAAAAAIBCzAB AAAAIAAAAFNNVFA6Rk9YUFJPQFVOSVZFUlNBTFRIUkVBRC5DT00AAwAAOQAAAAALAEA6AQAAAB4A 9l8BAAAAGwAAAGZveHByb0B1bml2ZXJzYWx0aHJlYWQuY29tAAACAfdfAQAAAFMAAAAAAAAAgSsf pL6jEBmdbgDdAQ9UAgAAAABmb3hwcm9AdW5pdmVyc2FsdGhyZWFkLmNvbQBTTVRQAGZveHByb0B1 bml2ZXJzYWx0aHJlYWQuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAAA3NuAQSA AQAtAAAAUkU6IEV4Y2VsbCBmcm9tIHdpdGhpbiBhbiBleGUgW1VUOklEOjA1OTExM10A2w0BBYAD AA4AAADNBwsACAAUAA0ADgAGABwBASCAAwAOAAAAzQcLAAgAFAANAA4ABgAcAQEJgAEAIQAAAEVD N0UyODdCQkY1N0QxMTFCNDEzMDAyMDE4MjkzMDU1AO8GAQOQBgAsCQAAIgAAAAsAAgABAAAACwAj AAEAAAADACYAAAAAAAsAKQAAAAAAAwAuAAAAAAACATEAAQAAAPQAAABQQ0RGRUIwOQABAAIASgAA AAAAAAA4obsQBeUQGqG7CAArKlbCAABNU1BTVC5ETEwAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpc d2lubnRcbWFpbGJveC5wc3QAGAAAAAAAAABeqExZy2zQEbM6ACAYKTBVooAAABgAAAAAAAAAXqhM Wcts0BGzOgAgGCkwVaQUMwAYAAAAAAAAAF6oTFnLbNARszoAIBgpMFXCgAAAEAAAAOx+KHu/V9ER tBMAIBgpMFUtAAAAUkU6IEV4Y2VsbCBmcm9tIHdpdGhpbiBhbiBleGUgW1VUOklEOjA1OTExM10A AwA2AAAAAABAADkAEPA7CbXsvAEeAHAAAQAAAC0AAABSRTogRXhjZWxsIGZyb20gd2l0aGluIGFu IGV4ZSBbVVQ6SUQ6MDU5MTEzXQAAAAACAXEAAQAAABYAAAABvOyVuiJ7KH7tV78R0bQTACAYKTBV AAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAAEQAAAHBhbmFjZWFAZWRlbi5jb20AAAAAAwAG EN1trHQDAAcQ/wMAAB4ACBABAAAAZQAAAC0tLS0tT1JJR0lOQUxNRVNTQUdFLS0tLS1GUk9NOlVO SVZFUlNBTFRIUkVBRFZJU1VBTEZPWFBST0ZPUlVNU01UUDpGT1hQUk9AVU5JVkVSU0FMVEhSRUFE Q09NU0VOVDpTQVQAAAAAAgEJEAEAAAD7BAAA9wQAACUHAABMWkZ1b70P3XcACgEDAfcgAqQEZAIA Y4JoCsBzZXQwIAhVHweyAoMAUAPUAgBwcnFsMiAHEwKAfQqACMggYjsJbzI1NQKACoF1NmMAUAsD YwBBC2BuZ/AxMDMzC6cKsQqECoThCzBsaTM2AUAVgBaxFQNgdAWQdBD0MTYg6i0Zgk8FEGcLgAdA BdDhB5BzYWdlGYMWxhiUBxazCzEYlmktMTQ04wFAF+AxODABQAzQHSOoYiBGA2E6DINiD/A6VQMA dgSQGpADIFRooQlwYWQgVgQAdRoxUEZveFADYCACEHIAdW0gW1NNVFBKOgIQeBiBQHUfVnTlH/Mu BaBtXRbFHlAGYBcCMB63BhB0CHBkYXk6LAewbx9wBtAQYTA4ASWAMTk5NyAyOiAzMSBQTSOnVG+l HrdHCsByeQfwaQSBMSOodWJqGMEet1JlgDogRXhjZWwDIF0DUiAD8CLwC4AgA5FlBHhlIYBVVDpJ RIA6MDU5MTEzI5YvG58YsxfkFltbHnMgRB5yGqADkQfAAQBsamtJJbBpYyeyIFclYG45LHBNeR+B LWcW4j4+hk8ygSvSZyBJIAWgYHVsZG4nBUAc8G7SZCrQaG8H4GQhEDSQtyFQLAUrESAAwQNgPxAA +wBwNRNnCHAscAhgGOAzhX8i8CxwK+AEkArAD4AlcXPbMnABkHg4MAXAdw+QGLD1H3EgBAAgMoAr EBqBKKACLjN2KFZGUCA17i4P8ABwIDBPASAx4Cxw7SaQKTN1M3VZCGA0pDYgfwWSIDA48jcDPOMJ gCvAL/0FoHAosDjyBaABADsAAjA9IRB5CGEgQDyBFsRhcPcLUDHgJRBpAiAzdTzyNeHXB0ADIEFE bQOBZAQgIvHJCGBnaD0gTEU71jN19zJTFso0kHc/Aw+QH3A10f80AyUQQcE/sxzwD7AFQAtRzysQ JYAGkDgwbmwosDSV7xlwP7gWxDsRdQ/AIDAhMf9I0TVgF+A0YUGCCrAasDQgPyEQH0FBgiWAPPIJ cHF1l0pQB5E48kMf8FcoPcX+ZiJgGNBDkSWAOoAx4EYQ9zsSGKAsEHYLcAtgAmBBst1CYi5UADpC S5Z3BRAYsL8sERigOQApFUAFBCBhISDvUadPxCUhA6BqTVAFQEFEfm4fcRiwIDBKcAUQNGEof1LC TVA0UjjxFsQPwDlyL/cJcEqjNvQpPOM48QOgRjH9WUF1ASA7AFhTCXA3UCWgVnclgEmDcDTQbE0x cPtCtVVkIFAgB5BDgkwBNJD7STE1EWtSwAfgOPIE8EEA/zghSyAgcFJhVro48hiBYiB/KRU55UHx Q2ArMV2RD9BjmVQgSSchcF0xY2tNQP8CMAMRUZAAIFWRO9UVcwwyRy3mIYA840dNUizQRdpSLBBk AQA1cV0DMB8QHwxAD/Af0CigKtBvV0ROb2XQJ8AG8HNNNxIoEiJr805hB4AiLDGfPcUWxDqAXeFr NCA9P0HXSyBB8QXhVz+CbynTJYD/QiMaIAeANvEosFMQO7FUAP8WymxnatBuoXCTYlFvRjcD70+h MRALgHAlbQMQIBBO0T9w4kCwASApBxbTMsBhaP8lgDSQYWJeYjsROxFvcznkzSWAYjhQXYInczWg NNH6J0hxcmaAK/Eq8znBcKKYVkJBJYAZ4Wh0N1D2Om0rfDBoZ4cYaBbTEnECAH9AAAMAEBAAAAAA AwAREAAAAAADAIAQ/////0AABzAwhpw6ley8AUAACDAQ8DsJtey8AQsAH4AIIAYAAAAAAMAAAAAA AABGAAAAAAOFAAAAAAAAAwBZgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAAeAFqACCAGAAAA AADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjAAAwBbgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUA AAAAAAALAGSACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAZYAIIAYAAAAAAMAAAAAAAABG AAAAABCFAAAAAAAAAwBmgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADAGmACCAGAAAAAADA AAAAAAAARgAAAAAYhQAAAAAAAB4AeYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAA AAAeAHqACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgB7gAggBgAAAAAAwAAA AAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4APQABAAAABQAAAFJFOiAAAAAAAwANNP03AADLXw==