I have the same problem pasting variables on the internet, only sometimes works. I use the clipboard.
On Excel the text type variable works fine.
yannis
To paste data from a variable to a location
I use Text Type %T1%
To read data from a location to a variable
I use
Clipboard Copy
Variable Set String %T1% From Clipboard
Is any direct way like
Copy Variable directly from the location
without going through the CB ?
yiannis
Cory,
There is no problem provided:
1. You store the MS macro in the workbook that contains the worksheet
and you don't use the same Shortkey in the workbook
2. In the MEP file you don't use the same Hot Key for another MEP macro
I tried using "Program Launch" with
Application.Run "C:\XFIL\ER.xls!optimize"
It should have worked because MEP accepted it (when I left something
out will get "specify file")
and still I was getting at run time "cannot locate file)
Finaly I solved the problem by using the MS macro's short-cut
and Text type <CONTROL><SHIFT>N
Thanks for your help
In a MEP macro I am using an Excel file in which I embed
a microsoft macro (VBA Sub).
I try to call the sub but MEP cannot find it.
So for now to get to the sub I click in excel Tools\Macro\...
How can I get the sub directly ?
Please help
yannis
I can edit or create a new macro and they run without a problem.
However after I turn off the computer and restart it, I loose all the changes or
additions.
I would appreciate any help.