girijaprasad Posted November 22, 2011 Report Posted November 22, 2011 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 Quote
Samrae Posted November 22, 2011 Report Posted November 22, 2011 I have a need to read files where the mex file is located Try this: Variable Set From Misc: "Current Macro File" into %MacroFilePath% Variable Set From File path Text Box Display: Result <VARIABLE SET FROM MISC Destination="%MacroFilePath%" Value="Current Macro File"/> <VARIABLE SET FROM FILE Filename="%MacroFilePath%" Option="\x01" Drive="%Drive%" Path="%Path%" Expand="FALSE" Flags="\x03"/> <TEXT BOX DISPLAY Title="Result" Content="{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1033{\\fonttbl{\\f0\\fnil\\fcharset0 Tahoma;}{\\f1\\fnil Tahoma;}}\r\n\\viewkind4\\uc1\\pard\\f0\\fs16 %MacroFilePath%\r\n\\par %Drive%%Path%\\f1 \r\n\\par }\r\n" Left="Center" Top="Center" Width="866" Height="118" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/> Quote
Cory Posted November 22, 2011 Report Posted November 22, 2011 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. Quote
girijaprasad Posted November 27, 2011 Author Report Posted November 27, 2011 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.