I have a macro running that beeps every several seconds (and it has hours to go). Can someone tell me what the commands are to silence the 'beep' of dialog boxes being closed, and the command to turn off screen updating. I searched online help to no avail.

Thanks,

Rob

Thanks, I copied and ran the following. Each variable has a carriage return after it, and thus shows up on a new line. Tried .csv extension, but with those carriage returns it makes no difference. Suggestions? Rob //Make variable to include comma delimiter Let>NewLine=%value1%,%value2%,%filename% //...

I would like to write three variables into one line of a text file, separated by a comma (or space or tab). I'm stuck.

This code gives me three lines, one for each variable:

WriteLn>c:\temp\logs\test.txt, %value1% %value2% %filename%

Ideas?

Thanks,

Rob

Thanks!

I copied your changes verbatim. Macro runs, but then I get a msgbox containing this text: %value1%. Seems it is not getting the clipboard.

Ideas?

IGNORE ABOVE: added wait before and after CTRL and works fine.

THANKS!

What am I doing wrong. I open a macro to edit it (no macros are running). Make edits, save it in editor, then go to next dialog box (Macro) and it says cannot save edits because macro is in use? But it isn't as far as I can tell?

Thanks,

Rob

Hi, I got the idea for the following from this forum, but I cannot get the value I want copied (in this case in Excel) out of the clipboard. What am I doing wrong? // Use Excel GoTo command to go to Z1. Copy Z1 to clipboard as Value1 //Excel has focus Press CTRL Wait>1 Send>g WaitWindowOpen>Microsof...

When running following script I get an error box and script stops: Error says "Unable to locate script compiler" and program hangs. Log stops recording: 6/2/2005 09:14:16:097 - Started Macro : chart6 6/2/2005 09:14:16:097 - GetFileList>c:\temp\*.*,files 6/2/2005 09:14:16:097 - Separate>files,;,file_...