I'm trying to get this code running but I'm unsure where you declare Arg 1, Arg 2 and Arg 3? What do I have to change to Ron's code to make it work?
http://www.rondebruin.nl/mail/folder2/saveatt.htm
Please Login or Register to view this content.Please Login or Register to view this content.
Hi Xx7,
I see you are having an argument with the arguments
It looks like you need to call the subroutinefollowed by stuff. This stuff is called Arguments.Please Login or Register to view this content.
To be more specific thesays you need to have 3 strings in the call like this:Please Login or Register to view this content.
The Strings are called Arguments to be passed to the subroutine.Please Login or Register to view this content.
More specifically String1 needs to be.... read the code..
So you would use this subroutine like:
Please Login or Register to view this content.
Hope this helps.
Last edited by MarvinP; 04-10-2011 at 01:52 PM. Reason: Added Code Tags
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hello MarvinP,
Please use code tags even around code fragments for better readability.
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!)
So, do I leave the code above the same and then insert a new sub procedure?
I get an error saying "The attempted operation failed. An object could not be found"Please Login or Register to view this content.
I would assume that one of the Arguments is not valid.
Do you have Outlook running and open on your computer? Does the Inbox agree with what you are passing to the Sub? Does the "pdf" need a period in front of it like ".pdf"? Read the code and see what is needed exactly. All these may need to agree, based on how the sub is written.
You should set breakpoints and step through the code to see where it fails. see http://www.cpearson.com/excel/Debug.htm
If I have the 2 subs in my initial post. Don't I only have to run the "test" sub to get the macro to work? Do I change the code in the "test" sub or are you saying that I need a 3rd separate sub where I use something like:
Please Login or Register to view this content.
Is there a particular reason why an Outlook question is posted in an XL forum?
My fault... I didn't even consider that. just assumed everything from Ron de Bruins site was all excel related.Originally Posted by arthurbr
OK
I moved the thread to the appropriate forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks