Jump to content
Macro Express Forums

gagangoomer

Members
 View Profile  See their activity

  • Posts

    88

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Everything posted by gagangoomer

  1. gagangoomer
    Hi, Is there any way to preserve the value of a variable from External Script file and place it in MEP variable %T[*]%. I've gone through the post "How to return a value from external script to MEP" earlier posted in this forum. But failed to find any conclusion on it. Can some one post a simple method of capturing the variable value from ES to MEP. FYI..I'm using VBscrpit in External Script. Thanks in advance. Gagan
  2. gagangoomer
    Thanks for Replying Cory. I tried the option you suggested by calling the.vbs file in my macro but it doesn't works. That's why i used the External script option in my code. Also i'm not aware of how to use then .vbs file in a command prompt. Would you like to share any example file for .vbs file which works with cmd. Do we need to establish connection or something to work on cmd ?
  3. gagangoomer
    Hi, I'm trying to connect MEP to IE through External Script option. Below is the code to activate IE window. I've run this code in VBA and is working fine but the same code when i put under MEP under External Script option it doesn't works. Dim btnSelectList As MSHTML.HTMLSelectElement Dim btnOptionList As MSHTML.HTMLOptionElement, ElementColList As MSHTML.IHTMLElementCollection Dim ElementCol1List As MSHTML.IHTMLElementCollection, i As Long, j As Long, URL As String Dim ie As InternetExplorer Set ie = New InternetExplorer Set ie = CreateObject("internetexplorer.application") ' Create IE object ie.Visible = True ie.navigate http://google.com 'Open URL Do Until ie.readyState = READYSTATE_COMPLETE 'Wait till the page gets loaded in the browser Loop Can anyone help on this ?
  4. gagangoomer
    Thanks for replying Samrae. I've tried both these macros which yous external scrpit as a part of macro. But my requirement is to use a .vbs file. Its just a vb script file(external file ex : Test.vbs)which can be called in an ME macro. And once the scrpit is run the ME macro wil continue there on. The use of using a .vbs file is that in case if there is some chages required in the script file(.vbs file) it will not impact the complete macro. I've seen this working before. Unfortunately I'm not able to find the code to call the.vbs file.
  5. gagangoomer
    Hi, Can anyone share an example of "How to use .vbs file(vb scrpit) file in an ME macro. I've written a small code but its not wroking ? Any help/ suggestion will be appriciated. Regards, Gagan
  6. gagangoomer
    The video in this link is not working...Thanks anyways
  7. gagangoomer
    Cory, Can you please mention the path here as i couldn't find it on the Macros.com website or please post it here in this thread.
  8. gagangoomer
    Hi, Can some one provide an example macro to understand the use of Get Control & Capture Control utility in MEP. I've tried hard and understand to some extent the use of these controls but want to have an example which can show me a demo of this control. Thanks in Advance !! Gagan
  9. gagangoomer
    Here's the reply which i got from ISS. HI Gagandeep, It requires programming time from our developers to remove old passwords. There is a fee of $50.00 USD to cover our costs to remove the password. Please let me know if you have any questions.
  10. gagangoomer
    Yes,I think you have got fair idea. The macro opens the word docx saved on the desktop and starts putting the information gathered from the other apps.There are mainly 3 font colors(i.e. red, blue and black) used in my document. The default font color used is Black, now i'm not sure how to change the font color at various positions in the document.
  11. gagangoomer
    Hi, I've created a macro to design Templates through MEP in Microsoft word. It captures certain info. from another application and stores in some variables. The macro is working fine but now i've recieved a request to color the font in a different color while designing the template.There are 3 colors to be used in the template. I found this can be done through the Text Display option box but it can only be used to display the colored font in a message box whereas i need to change it in the template. Is there any way through which the macro can change the text color in the template? I've attached the snapshot to make it more clear. Thanks in advance. Gagan
  12. gagangoomer
    Hi All, Is there any way we can crack the password protected macro. I've couple of macro's which i need to modify but i can't open these macros. Even you can't disable or delete these macro from the Macro Express. Any suggestions ? Thanks in advance Gagan
  13. gagangoomer
    Hi All, I've created a macro using MEP which operates with a web based application. I need to copy some information from the application and store it in variable, which i've already done. I've used mouse pointer to take the cursor to a specific place and then capture the information from all the fields. The macro was working perfectly fine till yesterday. I noticed when i added toolbar by right clicking on the File, Edit menu located on the top of IE. When i added a toolbar into the IE the resolution changes which impacts my macro. Even though i've tried all the options Realitive to screen/ Realitive to window but it is facing the same problem. Another serious concern is when i distribute this macro to other users it doesn't work for them either. This may be bcoz they have different window resolution or addons in there IE. Does anyone knows how to get rid of both these problems ? Thanks in advance Gagan
  14. gagangoomer
    Hi, I couldn't find any option in MEP just like we have it in VBA in form of Msgbox. I want the macro to do a certain task if Button 1 is pressed and do something else if Button 2 is selected.It is pretty much similar Msgbox option in VBA. The only option which comes to my mind is to use Multiple Choice Menu. Any Suggestions ? Thanks in advance, Gagan
  15. gagangoomer
    Yes, i did that but it is still not picking the correct value.
  16. gagangoomer
    I did changes the coding but failed to get the desired results. Instead i'm getting the result as 12/30/1899.
  17. gagangoomer
    I tried the macro referenced below. It does change the date format from MM-DD-YYY to MM/DD/YYYY but doesn't revert in a desired format.It didn't gave me any problem while loading the macro in MEP. Can anyone advice how to get the result in MMMM/DD/YYYY format ?
  18. gagangoomer
    Cory, I didn't get you when you say rearranging the characters using string manipulations. How do we do it?
  19. gagangoomer
    Hi, I'm copying some fields from an application on which date format is in "mm/dd/yyyy" (ex. 03/01/2013)format but i want to customarize it to "mmmm dd',' yyyy" (ex. March, 01, 2013) format. The above value is stored in variable T[1] through Variable Set String t[1] from clipboard contents.I guess the desired results can be acheived by using modify Date/Time --> convert to text variable option or maybe some better option. But as the variable is intialized from clipboard but modify date/time uses Date/Time Variable(that means an existing variable defined in date/time format to modify). Please advice is there some better option of converting the date into the desired format ? Thanks in advance Gagan
  20. gagangoomer
    By Windows Taskkill Command did you mean to use Window Task Manager and click on End task for MEP else where can i find Windows TaskKill Command in my system. I'm using Windows Xp S3.
  21. gagangoomer
    Thanks Terry, I'll try to implement the same concept in my macro.
  22. gagangoomer
    Attached is screenshot of the Restart located in my Macro Express Pro folder via My Computer/Program files/MEP Sometimes the macro express is closed while running a macro, but you can see the green man running (MEP running icon) in taskbar when you hover on it disappears. When you restart MEP from the given path it doesn't starts. Can anyone tell, is it a bug and what can we do to restart MEP again w/t shutting down the system as there are couple of apps which are running on the system and restart can take a lot of time.
  23. gagangoomer
    I know it is possible though .net or VBA bt i want it in MEP.
  24. gagangoomer
    Hi All, Is there any way by which i can create a pop-up showing three options(Yes, No and N/A) instead of two (usually shows 2 options i.e Yes, No or True False etc.). When a user clicks on any option an event should fire depending on the option selected by user. I know how to use If Message option but it only shows max 2 options under it.The only one way that comes to my mind is giving a Multiple Choice Menu option. Is there other appropriate method how i can get the desired reults ? Thanks in Advance !! Gagan
  25. gagangoomer
    Thanks a ton
×
×
  • Create New...