Jump to content
Macro Express Forums

Renaming A File


patgenn123
 Share

Recommended Posts

I have a program that strips an attachment from Microsoft Outlook and puts it in a general folder.

 

I would like to be notified of it when it hits this folder and then prompted to change the file name. Of course I want to open to see the file first before I rename it.

 

After that I would like to move the file to a corresponding folder that matches a part of the file name.

 

For example, an e-mail comes in from John Smith. John Smith has just sent me his proposal. A message box just tells me that I just received an attachment.(It would be great if the message box could tell me the name of that file before I change it). John has the name of the file to be XYZ.pdf

 

I would like to have this file open first(to see what it is), rename it by prompting me, and then sending this file to another folder that matches part of the renamed file.

 

For example, XYZ has been changed to "John Smith Proposal" from the prompt. I need to send this to another folder called "Proposal" where all the rest of the proposals are.

 

How could I do this?

 

Your help would be greatly appreciated!!!

Link to comment
Share on other sites

I guess no one wants to help me???

 

I am trying my hardest to understand this program. It has given me much nervousness and anxiety, but it's still not clicking in my head regarding the logic and technical words needed to understand.

 

If no one wants to help me, can someone direct me to where I need to start understanding basic computer programming so I can do this? I am very frustrated right now. I am not asking someone to write this whole thing, but if I can have pieces parts(and the logic behind it) so I can slowly understand, it would be greatly appreciated.

 

All answers are welcome.

 

Pat

Link to comment
Share on other sites

Hmm... can see how to easily do everything you want, except open the attachement part.

 

I have a somewhat simular macro that works with Groupwise email... it first checks 4 pixel locations to see if there are attachments, then if there are it saves those to a specific directory while remembering the files names for use later in macro, at which point it add's those files into a form that the macro is designed to complete for me.

 

Here's a copy of that section of my macro.. maybe you'll get some inspiration from it:

 

Macro Playback Speed: 3 Times Faster than Normal

Audio Mute

Window Resize: Current Win - (Width: 551, Height: 417)

Get Pixel: Window Coords: 115,325 into %N3%

Get Pixel: Window Coords: 190,325 into %N4%

Get Pixel: Window Coords: 265,325 into %N5%

Get Pixel: Window Coords: 340,325 into %N6%

If Variable %N3% <> 16777215

Mouse Move Window 115, 325

Mouse Right Button Click

Delay 1 Seconds

Text Type: s

Delay 1 Seconds

Clipboard Copy

Variable Set String %T11% "c:\macrotemp\"

Variable Set String %T12% from Clipboard

Variable Modify String: Append %T12% to %T11%

Delay 1 Seconds

Text Type: %T11%

Delay 0.5 Seconds

Text Type: <ENTER>

Text Type: y

Wait for Not Mouse Cursor: Hour Glass

Delay 0.5 Seconds

Variable Set String %T12% "%T11%"

Else

End If

If Variable %N4% <> 16777215

Mouse Move Window 190, 325

Mouse Right Button Click

Delay 1 Seconds

Text Type: s

Delay 1 Seconds

Clipboard Copy

Variable Set String %T11% "c:\macrotemp\"

Variable Set String %T13% from Clipboard

Variable Modify String: Append %T13% to %T11%

Delay 1 Seconds

Text Type: %T11%

Delay 0.5 Seconds

Text Type: <ENTER>

Text Type: y

Wait for Not Mouse Cursor: Hour Glass

Delay 0.5 Seconds

Variable Set String %T13% "%T11%"

Else

End If

If Variable %N5% <> 16777215

Mouse Move Window 265, 325

Mouse Right Button Click

Delay 1 Seconds

Text Type: s

Delay 1 Seconds

Clipboard Copy

Variable Set String %T11% "c:\macrotemp\"

Variable Set String %T14% from Clipboard

Variable Modify String: Append %T14% to %T11%

Delay 1 Seconds

Text Type: %T11%

Delay 0.5 Seconds

Text Type: <ENTER>

Text Type: y

Wait for Not Mouse Cursor: Hour Glass

Delay 0.5 Seconds

Variable Set String %T14% "%T11%"

Else

End If

If Variable %N6% <> 16777215

Mouse Move Window 340, 325

Mouse Right Button Click

Delay 1 Seconds

Text Type: s

Delay 1 Seconds

Clipboard Copy

Variable Set String %T11% "c:\macrotemp\"

Variable Set String %T15% from Clipboard

Variable Modify String: Append %T15% to %T11%

Delay 1 Seconds

Text Type: %T11%

Delay 0.5 Seconds

Text Type: <ENTER>

Text Type: y

Wait for Not Mouse Cursor: Hour Glass

Delay 0.5 Seconds

Variable Set String %T15% "%T11%"

Else

End If

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...