Jump to content
Macro Express Forums

gagangoomer

Members
  • Posts

    88
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by gagangoomer

  1. Copy,In MEP we have an option to convert from upper or lower case but no option is available to convert to a proper case. Is there any way through which we can convert the text(Upper or Lower) to a proper case. I tried doing it through Variable Modify String ->copy Part of Text option but here i don't know the no of characters in a name. Any suggestions ?
  2. Hi, Is there any way we can compare value in a variable suppose [T1] with multiple options (say A or B or C) ? If the value in T[1] is either A, or B or C...Msg "Value is " T[1] else Msg "Value is different. <IF VARIABLE Variable="%T[1]%" Condition="\x00" Value="A or B or C" IgnoreCase="FALSE" _COMMENT="Basic Claim OT UPHELD letter"/>
  3. Can you share the code or the macro with me, also send the supporting docs (if any)..leme see how it works
  4. Hi Cory, SOrry for bothering you again. I'm working on a project in which i need to draft a letter. The macro will prompt to select from Option A & option B. As per the option selected it will open word document and paste a logo depending on option (A or . As per our previous discussion as we cann't store an image file in MEP, so the only option which comes in my mind is to create two different templates and save it on your system or on sharepoint (whatever is the requirment) and as per the user's respone open that blank template and paste the data which we'll fetch from the other application stored in vairables. Now the problem is while i paste the data in template(A or it takes extra spaces and change the alignment of the text entered in the document. I tried to use Trim function to remove the extra spaces but i'm still facing for both spaces and alignment. Is there any way through which i can overcome this problem or will you suggest some other way to draft a letter other than the one i mentioned above. Regards, Gagan
  5. Yes, I did checked the options available under Debug Button. But these option are not working properly when i'm doing in step by step by pressing F8 key. The focus generally moves to incorect position. Even after selecting the <<Don't switch focus>> option from Debug menu.
  6. Hi, Does anyone knows how to use the debug option under MEP to debug code step by step just ike we do it in VBA by pressing F8 ? I tried doing that with Step over option under Debug button but failed to get the desired results. I also tried to put Toggle Breakpoint but the macro steps over it as well. Any suggestions ? Gagan
  7. Thanks Cory..I know lil bit about this. ASCII is something the complier is converting the commands which we use in ME for its own reference. Just like we have binary language which is easy for the complier to understand. I must say you are a knowledge warehouse . I just had an idea about the binary language but the knowledge i really got to know more about how the complier works. Though i've used Hex editor only couple of times to break the protection in excel file but didn't realised how it interpreats things. Do you have an a/c on FB where i can join or follow you or may i know your website from where i can learn more. I want to learn many more things from you. Thanks for your valueable time. Gagan
  8. I check the above snippett but but couldn't get much idea about it. What are ASCII codes and where are they used ?
  9. Yes, I'm with you. Cory can you explain it along with an example.I'll import it into my ME and then see what it exactly does. I know i'm expecting a lot but as i've not used array's before so its bit confusing for me
  10. Thanks Cory for a quick respone I've not used Array's or copying a range of values in a MEP. Can you please share an example of how to use copy a range nd store it into a variable or in a an array ?
  11. HI All, I've two questions to ask fromthe forum. 1) Firstly i've put some values in Column A of an Excel sheet. I want the macro to read each value till the time it finds a blank cell. The macro should pop-up an error message "There are no more values available". I've tried doing this but the macro is reading all the values including blank values. I've tried Repeat until and Repeat Start both options but failed to get the desired results. 2) Secondly Can i store an image in a variable in ME pro. I've a project in which i need to draft a template as per user selection and there should a particular logo depending upon the option selected on the top of the word document. Is it really possible ? Thanks in advance, Gagan
×
×
  • Create New...