patgenn123

Cyberchief, Here is what I have, BUT I guessed how to do this. I created this for quite some time(by chance it worked). I use a prompt to get the first name of file and it works to get more than one word of the file: I want to know how it could automatically recognize the first(maybe the second word of the folder and bring the matching files together). I used a prompt on this: Change Directory/Folder: "C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing" Variable Set String %T1% from Prompt Create Folder: "%T1%" If Folder Exists "C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%" Open Folder: %T1% End If If File Exists "%T1%*.pdf" Move File or Files: "%T1%*.pdf" End If If File Exists "%T1%*.pdf" Move File or Files: "%T1%*.pdf" End If If File Exists "%T1%*.pdf" Move File or Files: "%T1%*.pdf" End If End If <DOFILE:01:NN:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing>><TVAR2:01:02:FFolder NameFFCenter:Center><DOFILE:02:NN:%T1%>><IFOTH:02:1:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%><MYCOMP:%T1%><ENDIF><IFOTH:01:2:C:\My Cabinets\Pat Gennarelli\Inbox\%T1%*.pdf><DOFILE:07:NN:C:\My Cabinets\Pat Gennarelli\Inbox\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%\%T1%*.pdf><ENDIF><IFOTH:01:2:C:\Documents and Settings\Gabriella Gennarelli\Desktop\%T1%*.pdf><DOFILE:07:NN:C:\Documents and Settings\Gabriella Gennarelli\Desktop\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%\%T1%*.pdf><ENDIF><IFOTH:01:2:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf><DOFILE:07:NN:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%\%T1%*.pdf><ENDIF><ENDIF> How can I get this to work by itself without the prompt? Pat

Cyberchief, I pasted your code and it didn't work. Is there something missing? Thanks! Pat

Thanks Kevin!

Cyberchief, Thank you. I haven't tried it yet, but I will when I come home from work. However, the question remains, will your code loop through the folder and if it finds any match on ANY part of the file name(from the folder name) with ALL/ANY of the files, will it move it to the folder with a match in the folder name? This is what I was ultimately getting at. Joe and Strathos I want to thank you. Please feel free to join in. I want to learn. I am frustrated at my lack of computer knowledge and programming, but as the saying goes "One day at a time". Someday the light bulb will turn on. Thanks! Pat

Joe and Strathos, OK. Maybe I was premature about things and I apologize, but I plugged in the code and have no clue about what it means. I want to understand this program and I did buy MACRO EXPRESS EXPLAINED, but no where would it give any sort of idea about the response by Strathos and how to structure this. MACRO EXPRESS EXPLAINED IS VERY GOOD, but there is no way I could have figured out what Strathos did to come up with the solution. I still don't know. I tried something myself. Why doesn't this work? Variable Set Integer %N1% to 0 Repeat with Folder Variable Modify Integer: %N1% = %N1% + 1 Repeat End If File Ready "%T1%*.pdf" Move File or Files: "%T1%*.pdf" End If <IVAR2:01:01:0><REP3:07:000006:000001:0001:0:01:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing><NMVAR:01:01:1:0000001:2:0000001><ENDREP><IFOTH:19:2:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf><DOFILE:07:NN:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%\%T1%*.pdf><ENDIF> This "Repeat with folder" is putting the folder names into a variable and then putting the variable into the file name as Kevin explained to do, but it's not doing it and I must be missing a step. There is something I am missing in between. If you separate the two parts in my macro, they work separately, but don't work together. For example, the second part(After the Repeat End Line) works with a prompt. If you prompt for a name, it brings everything together in all folders with a Change/Directory command line. Can you help me with what I have done already? Pat

Dear Moderators, Thanks for all your help on this one. I really appreciate it. If I was going to ask for you to write the whole program for me, I would pay you for it, but if I was just asking for some simple advice to point me in the right direction, it's a different story. Thanks for the customer service. Sincerely, A grateful paying customer

Kevin, What I ultimately want to do is this: I have a folder that has files in it. All are different in name and type. Most of them have file names(1,2 or 3 words in the file name) and another folder that has subfolders. Almost ALL of the files can be matched to these subfolders by the first name of the file. So really what i want to do is isolate the first name of the file, run a loop through them, isolate the corresponding subfolders(i guess by running a loop through the subfolders also?), match them together and send the files to the corresponding subfolder(s). If in the future there are extra files stored in that folder, once they are renamed, they would go to the corresponding subfolder(s) the moment the name has been changed. Seems like it might not be too hard? Or is it just a dream? P

Kevin, Please pardon my question if it seems to obvious since I lack a lot of computer knowledge. I know how to do the repeat with folder, but I do NOT know the other steps. How do I find the word "Excel" in the repeat folder loop? What does it need to compare itself to? Obviously, the file name "excel". How do I find the word "Excel" in the filename and isolate it and put it into a variable? Doesn't that mean I need to set focus on the excel file first, loop it, and then compare to the folders by looping the folder also? Or does it matter? Pat

I know it easy to just use "move file or files" to get a file to go into a folder, but how about automating it to go to that specific folder based on the first word of the file name matching the first word of folder name? For example, what if I had a file named Excel Shortcut tips on my desktop. What if I had a folder named "Excel" as a subfolder somewhere and I want it to go to that folder automatically. I could be spending an endless amount of time creating "move file or files for every single file variation or I could make it easy. Anybody have any ideas? P

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

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!!!

I have files I would like to rename using Variable Set from File. I am choosing "Get File Date/Time" with the month/day/Year as Variables N1, N2 and N3. I have a program that strips attachments from my Outlook Inbox and puts them in a folder. The names of the files in this folder are similarly named. For example, 2nd Mortgage Rate Sheet.pdf 2nd Mortgage Rate Sheet-1.pdf 2nd Mortgage Rate Sheet-2.pdf I know I can use wildcards to rename them to something like this: 2nd Mortgage Rates N1-N2-N3.pdf(where N1,N2 and n3 is the date of the original file) Variable Set From File Date/Time Rename File or Files: " 2nd Mortgage Rates*.pdf" <VFFILE:0:0:T:1:T:2:T:3:F:1:F:1:F:1:C:\My Cabinets\Pat G\Inbox\Broker 2nd Mortgage Rate Sheet*.pdf><DOFILE:06:NN:C:\My Cabinets\Pat G\Inbox\2nd Mortgage Rate Sheet*.pdf>C:\My Cabinets\Pat G\Inbox\2nd Mortgage Rates*N1-N2-N3.pdf> I am really confused as to why this is not working.

Here is my next challenge, I have a program that strips attachments out of Outlook and puts it in a folder. I know how to rename these and move them.I also want to check certain websites for different rates and save them as either.mht or as pdf. it depends on the website. Also, there are some e-mails I receive from lenders that do not come as attachments, rather they come as hyperlinks within the body of the message. I want to have e-mails that come from account representatives' e-mail addresses, to be recognized, saved after opening it, and moved to that day's folder. Right there are 5 different ways I want to move files to these folders to give me an update of all rates for the day. The question really is: How can I get the "create date" of that file to match the date of the folder and automatically move the file to folder instantly? Also, how can I get a pop up I can click to go to the folder after it alerts me of a new file or even better, ask me to see the newly created file, answer yes, and then open it right away? Lots of things to do, but most importantly, I need to match date created on file to date created on folder for the file to move. How to? I CANNOT POST MY CODE because it has interest rates and programs I am not legally allowed to distribute to the general public. It doesn't work anyway. Pat

Strathos, I want to thank you for doing this. I cannot express my gratitude enough. I must be real slow, but I am trying to go through this and have no clue on some of the things you did. Where do you go to learn about macros? I need to get to the real basics and the logic behind this in order to understand this or I will be forever posting on this board. Even the best of them do, but I don't want to look like I know nothing. I am very determined to learn this and need someone to point me in the right direction. Can you help? Sincerely, Pat

Hi Strathos! Unfortunately, after I put the code in, it didn't work according to plan. Is there something I am missing? The code is giving me an error about not being able to rename the file. Pat

I am new to this program. I don't have any experience in this. I wish I could ask someone to help me, but I haven't gotten a response to my previous question. I will rephrase this and pose it again. I am trying to create folders on my desktop for each day of the week. After the new week commences, I want to have all old folders move to another folder while new folders for the new week are generated on my desktop- One day at a time. Here is what I have so far: Date/Time: Save "ddd MMM-dd-yy" into %T1% Create Folder: "C:\Documents and Settings\User Name\Desktop\Rates -%T1%" Rename Folder: "C:\Documents and Settings\User Name\Desktop\Old Rates\Rates -%T1%" When this macro is executed, it automatically moves "Rate-%T1%" to Old Rates(folder). How do I make it move there 7 days later instead of instantly? Does it require Integer, If statements, Repeat commands? What is needed? Pat

Joe, Thanks for your reply. I want you to know that I am not good with computers and programming language. If you can teach me like I was a newbie with plain and simple language, it would greatly be appreciated! Here is what I have so far. I am probably far off, but I am trying real hard to understand this. Date/Time: Save "ddd M-d-yy" into %T1% / Create Folder: "C:\Documents and Settings\UserName\Desktop\Rates -%T1%" Variable Set Integer %N1% from Current Day Variable Modify Integer: %N2% = %N1% + 7 Move File or Files: "Rates -%T1%" Change Directory/Folder: "C:\Documents and Settings\Gabriella Gennarelli\Desktop\Old Rates" //Note: I want %T2% to be the next day or loop this somehow?????// What is happening is that I am creating the folder correctly and when I change the system time/day for a week in advance to test it, it creates another folder, but it doesn't move the old folder to a a new folder called "Old Rates" I know I am way off, but I am willing to learn, buy your book and do whatever I can to get this, but it will take a while. the purpose of this is to make everything as efficient as possible. The way I am doing this is that I purchased/am using a program that strips attachments from my Outlook inbox and directs it to a folder called "inbox". I want to rename these files with wildcards and send them to 2 folders. One is the folder with the respective Lender name(I get many attachments from all kinds of lenders about their programs/rates). The other is the folder(s) I want to create on my desktop with Names on the folders: i.e."Rates %T1%"(with %T1% being the day of the month). When an attachment comes in, the "date created" in the attachment will be sent to the date created for the folder. I want to have a weeks worth of folders on my desktop with all 7 days of the week. I want to start the week off "fresh" which means on Monday the desktop is clear of all folders ready to start anew for the next week everyday adding a new folder for Monday, Tues etc. with the date on the folder, but I want the old folders(from the prior week) to go to an archive folder to be kept for however long I want them there. Thanks! Pat

No Takers? How would this be done? HELP?

I want to be able to create 7 folders on the desktop(one for each day of the week) and when the days go by, a new one is created as the old one is moved to another folder. How do I create the folders with a date on them? How do I create the folders with todays date on the newest one and the 8th day moved to another folder? Thanks! Pat

I am trying to open up a web page and use controls to put in the user name and password. Why is this not working? Web Site: http://www.website.com[Default Browser] Wait for Web Page: "www.website.com" Get Control %C1% Text Type:("my user name") -----with %C1% chosen as control This is for the password: Get Control %C1% Mouse Single Left Click on Control %C1% Text Type:(my password) This is all I have so far and it's not working.. It seems that when you drag the control "target" to the area of the webpage, it doesn't "highlight" the user name field nor the password text field

I am a novice to macros and I was wondering how to move files automatically to a folder already created. This folder would be on the desktop and the files would move automatically based on the name of the folder MATCHING the name of the file. Any ideas?