tatrader

System background. I am using Vista OP and Macroexpress v 3.7d I had created a set of macro to run when a specifc program was running (Metastock mswin.exe) on a prior computer that ran XP operating system. When I now load that set of macros into Macroexpress on the Vista machine, these program specifc ones do not activate when the assigned key is pushed. I can manually run the macro but it does not do what it is supposed to do in the specific program. I opened one of the program specific macros, and with Metastock running, when I look in the available set of active programs in the program specific list for selection, this program does not appear for selection (even though I can see it running in another window). Other programs that are running show up, but not this one. Hence, it appears that the macros are not executing because macroexpress does not recognize that the required specific program is running. Any known issues on this? Charles

If you are willing to stop MacroExpress itself in order to stop the macro: ctrl+Alt+shift+V

How/where are the symbols stored that you want to type/paste to a particular appliction? If the symbols are stored in a text file, each could be sequentially read from the file and then "text type"ed into a cell or box that has focus. You may need to do a mouse click in the text box to gain focus. Or a series of separated symbols could be read from the file and saved as a single text string with appropriate separators (spaces, tabs,??), and then text typed into the text box after making sure the box has focus.

Lemming and all, I tried the macro text cleaner macro posted by Lemming (thanks!). Unfortunately it did not delete the hidden character(s). So I concluded that the troublesome character(s) had to be some other character than the ones specifically filtered by text cleaner macro. The data in the Excel cell had been copied from a table of stock values (from Bigcharts.com), and thus could contain ??? in addition to the numeric values for open, high, low, close, volume for each stock symbol. Thinking about the approach used in the text cleaner macro, I wrote the attached macro that cleans ALL ASCIII characters from 0-31 and 127-255 from the text string copied from the Excel cells. The filtered characters are not normally used for typical alphanumeric strings. It worked! I ran a test and determined the unwanted embedded, non-printing, character to be between ascii 127 - 255. Anyway, happy ending. The Excel cell values, after being filtered by the attached macro, now paste into my target application program as numbers. ASCII_TEXT_FILTER.MEX

Thanks Lemming, I will give this a try and post results. One more thing about my problem. The information in Excel is captured from a web site having a table with stock information: symbol, open, high, low, close, volume. It is pasted into Excel, in order to more easily separate the different values for each stock I then want to transfer the data into my stock database contained in files kept by the MetaStock that can be edited by using MetaStock's Downloader program. So there could be characters/attributes embedded that are not visible, but are there to cause the problem in the attempted paste into the Downloader cell.

I am trying to transfer informtion contained in certain cells in an Excel spreadsheet to another program (the Downloader of MetaStock) as part of stock data updating. I can select the cells ok in Excel and perform a clipboard copy operation. I then try to paste the into a selected cell of the Downloader. I get an error generated by the Dowloader stating that the attempted paste did not work due to an unpermitted character. If I do an intermediate step the data is accepted by the Downloader. I can paste the copied cell from Excel into Notepad, and then copy the data in Notepad and paste it into the Downloader with no problem. I assume that some kind of embedded character/attribute is associated with the Excel copied data. The cell in Excel looks like "11,069.74". I store the copied Excel cell data (5 separate cells) as a text variable which I then sequentially copy to the clipboard and attempt to paste into the Downloader. I have tried using the trim and/or strip CR/LF on the text variable before I attempt pasting it into the Downloader, but same reported error. Evidently the intermediate step of using Notepad acts as a filter that eliminates the unwanted character/attribute. However, I would prefer to not hve to go through such an intermediate process. Any ideas on how to filter out whatever characters/attributes are associated with the Excel cell data so I can store it in variables and then paste the variables into the Downloader cell? I have looked at the stored data in the text variables in the debug variable listing, and the data "looks" clean, i.e. only numbers, commas and a decimal point.

Thanks. I tried a trim left and trim right on values stored in the text variables, and this got rid of the unwanted symbol. I think it was probably a carriage return/line feed as you suggested. This part seems to now operate as expected.

Hi, Sorry about about the last. I had an error. The righarrow and copy to clipboard actions are working ok. Thanks. However, my question about symbol to the right of the copied value as appears in the text variable is still in issue. Since want to paste the text variables into another application, I need to delete whatever these symbols are.

Thanks Cyberchief, The clipboard copy works in copying the contents of the Excel cell with focus. It causes the marching ants to appear around the cell copied. However, the text type: <rightarrow> following the copy of the first cell does not cause the focus to shift to the next right cell. Marching ants remain around the first cell. The copy for the second cell ends up with the value of the first cell. Also, I notice in the value stored in the text variable has a symbol appearing like two small vertical bars following the value as shown in the Excel cell. Is this some type of format information? Can I get rid of it?

I am trying to write a macro that sequentially reads and copies a series of 5 cells in a row of Excel into corresponding text variables. Activating Excel and locating the cells of interest is working ok. With a cell highlighted, I try to copy: text type macro: "controldown,C,countroup" I notice that Excel does not turn the frame around the selected cell to 'marching ants' when the macro attempts to copy it; however, marching ants does occur when I actually enter ctrlC on the keyboard. I then set a text variable with the contents of the clipboard, and I see from the debug variable table that no information resides in the text variable. I want to treat the copied value (shown as a number in Excel cell) as text so I can then paste it into another different application. Does it matter for copy into a text variable if numbers are shown in the Excel cell? What if the cell format is set to "text" in Excel? Help appreciated.