JimShoenfelt

1. does accomplishing this require months of experience with macro express? If not, can someone give me a hint as to how to get started on it? 2. How do I "surround my code with square brackets"? (I use the direct editor.) And what does "at the end use "/code" with square brackets" mean? i copied and pasted the text from the scripting editor to this post and it gets pasted like the text in the direct text editor. Was hoping there's an easy way to copy and paste code so that forum readers can more easily read it (i.e. scripting editor format).

1) I have a cell in Excel (e.g. cell A1 assigned the name "projectcode") in Excel. The formula in this cell is the same, but the value often changes. I'd like to use the current value of this cell -- whatever it is -- to paste into Outlook or Windows Explorer, or desktop search, etc. Can MacroExpress help me accomplish this? 2) I've seen other posts where Macro Express code appears to be pasted in it (in "Scripting Editor format"). How do you do this? When I copy code from the scripting editor it looks like this: <TEXTTYPE:<ESC><ESC>><LAUNCHYES3:0:0112pandora radio<LAUNCH:C:\Program Files\Internet Explorer\iexplore.exe<PARAM>www.pandora.com><MMW2:588,543><LCLK><MMW2:588,436><DELAY:1><LCLK><DELAY:1><LCLK> Thanks, Jim

here's my macro: <TEXTTYPE:<ESC><ESC>><MACRUN2:Activate or Launch Personal.xls><TEXTTYPE: ><WAITWIN2:000000:000005:Personal.xlsm><DELAY:1><TEXTTYPE:<F5>><WAITWIN2:000001:000000:Go To><TEXTTYPE:PWTab<ENTER>><WAITWIN2:000001:000000:Excel><DELAY:1><TEXTTYPE:<CTRLD>f<CTRLU>><WAITWIN2:000001:000000:Go To> 1) When I launch it from excel, sometimes it puts "f" in the cell that i launch it from, suggesting that macro express failed to hold the ctrl key down before hitting hte "f". And sometimes it brings up the "find and replace" window, just as i expect it to. Any idea why? 2) Sometimes when I've run a macro, it seems to get hung up. Other than right clicking the running man icon, how may I break the macro? Also, is there a way for me to tell which line the macro was working on when I asked the macro to break? 3) I've been using macro express for years, and have always had these intermittent results in many different scenarios. e.g. I make a macro to just open or launch a program -- sometimes it does...a nd sometimes it doesn't. Does anyone else share this experience? Thanks,

To file an email in Outlook 2007, the shortcut is Ctrl+Shift+V. I try Text type: <CONTROL><SHIFT>V, and it doesn't work. But typing Ctrl+Shift+V manually in Outlook works, so what's the problem?

Thanks for your response. I tried the delay and replacing the clipboard copy with ALT ec in Excel (edit-copy). It still doesn't work. Like I wrote in the original post, the copy seems to have been working all along because when I added a text box to display %T2% before the file create command, the text box did show the correct file name and path. Any other ideas, anyone? The Create Folder command doesn't appear to be working with a variable, but does work with a text input. What's doing on?

I'm using the following where Folder_on_Pc is a range name in excel's Timesheet.xls that contains a file folder and path (e.g. "C:\shoe\CC\ANA\1Current\DE-Tech-20070301-LCA"), but the folder doesn't get created. Why? <TEXTTYPE:<ESC><ESC>><DELAY:1><ACTIVATE2:timesheet.xls><WAITWIN2:000010:000000:Excel - timesheet><TEXTTYPE:<F5>><WAITWLF2:000010:000000:timesheet><WAITWIN2:000010:000000:Go to><TEXTTYPE:Folder_On_PC<ENTER>><WAITWLF2:000010:000000:Go To><WAITWIN2:000010:000000:Excel - timesheet><CLIPC><TVAR2:01:03:><TEXTTYPE:<ENTER>><DOFILE:02:NN:%T1%>><TEXTTYPE:<ENTER>> If I do it without using a string variable, it works fine. e.g. <TEXTTYPE:<ESC>><DOFILE:02:NN:C:\shoe\CC\ANA\1Current\DE-Tech-20070301-LCA>> I've also added a textbox to ensure that %T2% has the right value after the clipboard command... it does. Any ideas?