Rick T

Hi,

I'm trying to write a macro that will seek and delete multiple instances of the same file stored in folders and subfolders of unknown name.

The filename is 'Report.xsl' and the top folder name is 'Store'. There are two levels of subfolders, the first level being named by date created and the second level by five digit non-sequential numbers (basically random). It is the second level subfolders that contain the 'Report.xsl file.

I'm aware that I can use wildcards with filenames but is it possible to use something similar with folders?

Any help with this problem would be gratefully received.

Figured it out myself. The way i figured it out involves having to create two macros for every letter on the keyboard (one to copy and one to paste), but it's the only way i can get it to work the way i want for now. Thanks anyway...

Hi,

I've attached a playable macro for you to try. Import it into Macro Express and set the activation to Ctrl+Alt+A. Have a look at the workings before you activate it.

The macro should copy highlighted text when activated. It will then flash up a box to show you what it has captured, save the text to a .txt file (in a folder called 'Saved Text' in the root of C) and empty the clipboard.

The next time you activate it, if no text is found for the clipboard to copy, it will type out the contents of the saved .txt file. If there is something for the clipboard to copy, the .txt file will be overwritten with the new information.

I've only tested this in a MS Word document. It works ok but you might find that some other programs will interfere with the process.

I hope this gives you something to develop further. You might also want to add a 'Clear Clipboard' command right at the start of the macro.

Regards

Rick

Copy_and_save_text.mxe

Hi guys,

I'm trying to accomplish one of two things with Macro Express and Windows XP. Either:

1) Launch a macro on the hard drive when a USB pen drive is inserted.

or

2) Launch a playable macro (stored on a USB pen drive) when it is inserted.

I'm completely stumped by this and have tried all sorts with .inf files etc. The only way that I can get it to work is with the 'options' window that appears when a pen drive is plugged in. But for reliability with different PCs, I'd like to try and get it to work with this option turned off.

I'm looking forward to hearing of possible solutions and wish all members a very happy Christmas.

Rick T

Thanks Kevin,

I've tried your suggestion and it works great.

I appreciate the help.

Hi,

Does anyone know how I can get a macro to access the taskbar properties (I want to change the autohide property) in Windows 2000? I've tried the 'Get Control' feature but cannot get it to work on anything in the taskbar.

Thanks