hello, could some one please look at my code and advise on how to fix my excel 2003 run-time error 438 "Object doesn't support this property or method" error? The VBE highlights this line of code:
The code below is the entire macro:
Please Login or Register to view this content.
Please Login or Register to view this content.
Any help on this would be greatly appreciated.
Kind regards,
Chris
Last edited by longbow007; 08-13-2009 at 08:35 PM.
Excel does not support the Documents (MS Word) command...
Use Workbooks insteam...Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Leith Ross; 08-13-2009 at 08:14 PM. Reason: Added Code Tags
Hello longbow007,
Please change your tile to more accurately reflect your question or problem. Refrain from generic titles like "Need Help", "Urgent", "Have Problem", etc.
A better title would be "Run-time error 438 when controlling Excel remotely"
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Chances2,
Please remember to use code tags in the future.
Thanks Chance2 and Leith Ross for all your help - very much appreciated. Your revised code works well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks