girijaprasad

Thanks! I will check it out and let you know how it goes.

loop until your requirement satisfied, I followed that pattern. I have a need to click a button until page is loaded fully with fully ajax functionality. wait until Webpage loading is not working at that situation, I tried to loop until I get the solution. the Solution is first i stored the desired fields when the page is loaded. After the page loaded my condition satisfied. My macro worked fine at all levels. Hope this will be useful.

This is how I normally do it:

Variable Set From Misc:  "Current Macro File" into %Macro File Path%
Variable Set From File path
Variable Set String %Macro File Path% to "%Macro File Drive%%Macro File Path%"

<VARIABLE SET FROM MISC Destination="%Macro File Path%" Value="Current Macro File"/>
<VARIABLE SET FROM FILE Filename="%Macro File Path%" Option="\x01" Drive="%Macro File Drive%" Path="%Macro File Path%" Name="%Macro File Name%" Extension="%Macro File Ext%" Expand="FALSE" Flags="\x03"/>
<VARIABLE SET STRING Option="\x00" Destination="%Macro File Path%" Value="%Macro File Drive%%Macro File Path%"/>

As I have explained in other posts here I create macro packages this way. One folder of the MEX and all the support files. Works well to create development packages as well.

thanks & I will apply this to my program

I am giri @ girija prasad,

I have a need to read files where the mex file is located i.e. if xyz.mex file is located at c:\providerextract\, there are some other files test.txt(text file) provider.xls (excel file) at that location which I need to read. suppose if i change xyz.mex file to another location d:\demo\xyz.mex, then I have a need to read test.txt, provider.xls from the location. I also need to run macro express pro from command line with mex file/nickname.

I tried to run MacroExpressPro MeProc.exe /A::c:\TestMacros.mex?TestMacro but I got the errors and could not run. or else atleast In another way I have to findout the current directory. .

thanks in advance

giri

Macro Express Pro v 4.3.0.1

 

Macro Express Pro v 4.3.0.1 is now available. This version includes many important changes including some that address the problem where Windows 7 slows down dramatically while running Macro Express Pro. Additional changes include:

 

• Made several changes to improve CPU utilization and to prevent lockups when running on Windows 7.
  
• Added the ability to edit a macro specified in a 'Macro Run' command from the right-click menu of the script editor.
  
• Added the 'Do not process embedded variables' option to many of the 'Variable Set String' and 'Variable Modify String' commands.
  
• Revised 'Run Macro In Variable' command.
  
• Fixed a bug rounding negative numbers.
  
• Fixed a bug with the Clear Variables clear all variables command.
  
• Fixed an issue with TCP/IP activated macros that was caused by Microsoft Security patch.
  
• Fixed a bug where the menu builder would get confused about the menu's structure.
  
• Fixed a bug where the debug variables dialog did not clear out the old values when starting a second test run of a macro.
  
• Made a change to resolve issues that occurred when the program shuts down.
  

For a complete list of changes, see the Macro Express Pro v 4.3.0.1 Release Notes. Download Macro Express Pro from the Macro Express download page.

excellent, is there any trial version available

The native Excel file is not a delimited format and you can’t do that.

 

Generally people have lists of things and they put it in excel just because it’s a handy way you have a grid. If this is the case I suggest you save the file to CSV instead. This way you can open and edit it on Excel and use ASCII File Process in MEP. However there’s no formatting, no multiple worksheets, and you can’t have it open at the same time.

 

Other alternatives is to have the user copy the range of cells to your clipboard and parse that with a split command in MEP. When you copy like that all clipboard data is inherently a tab separated value format. IE like CSV but using tabs instead.

 

But if you need to access the data in the Excel file format without changing it then you will need to use some VBScript and the External Script command to get to it. I have one I use often that will simply export one worksheet to a temp TSV file that I can deal with. Let me know if you need help, I’m available.

thanks cory, Now I will try for that and complete my work. :-))

I am girija prasad @ giri,

I am having requirement to read excel file. I used TextFileBeginProcess for reading excel file. then MePro is terminating abruptly and prompting for error reporting. is AsciiFileBeginProcess is suitable or not

Thanks in Advance

regards

giri

Did you try adding a Lock Player command? This from Help:

Lock / Unlock Player

Since more than one macro may be run simultaneously, this command prevents another macro from starting while the macro containing the Lock Player command runs.

 

--

Terry, East Grinstead, UK

thanks a lot, I will use that command now

Hai,

I am girija prasad @giri, I am new to this forum, I have a need to run only single macro, i..e when I am running one macro, no other macro is activated. I am running macro express through java program. when several computers in the network hit the macroexpress for executing the macro, only one macro should be executed, others will get the prompt that there is a macro is working

any help

thanks & regards

girija