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

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 ?

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 ?

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.

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

There is a video on the MEP web site that demonstrates using controls in general http://www.macros.com/videospro/usingcontrols/usingcontrols.htm

and great documentation. Would that help?

The video in this link is not working...Thanks anyways

There is a sample macro in the samples file which was installed in the programs folder or it's on their website which uses the Windows Calculator to demonstrate controls.

 

The one but of advice that I would pass along is that the Get Control does just that. The addresses of controls change every time they are created so there is no way of knowing their address in advance. The Get Control contains a path, imagine street directions, on how to find it at run time to define the control variable. But the Get Control doesn't execute where it's defined in the macro but at the first time it's used.

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.

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

I have no idea and even if I did I'd be reticent to share! But if it's a legit accident and you can make a good case you might be able to get some help from ISS support.

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.

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.

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.

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

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

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

Yes, i did that but it is still not picking the correct value.

I did changes the coding but failed to get the desired results. Instead i'm getting the result as 12/30/1899.

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 ?

Cory, I didn't get you when you say rearranging the characters using string manipulations. How do we do it?

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

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.

Thanks Terry, I'll try to implement the same concept in my macro.

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.

I know it is possible though .net or VBA bt i want it in MEP.

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

Thanks a ton