Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
:34:00 PM Subject: Re: $$Excel-Macros$$ Copy Files & then go back amd delete them Ah! You have already posted while I was typing. Good that we all are on the same page :D. Happy posting Sam On Tue, Nov 1, 2011 at 11:02 PM, Sam Mathai Chacko wrote: Dave, > >How I couldn't agr

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Sam Mathai Chacko
eople you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:* Dave >> *To:* MS EXCEL AND VBA MACROS >> *Sent:* Tue, November 1, 2011 12:50:11 PM >>

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Sam Mathai Chacko
- > > > -------------- > *From:* Dave > *To:* MS EXCEL AND VBA MACROS > *Sent:* Tue, November 1, 2011 12:50:11 PM > > *Subject:* Re: $$Excel-Macros$$ Copy Files & then go back amd delete them > > Here is how I hav

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > - > > ____________________ > From: Dave > To: MS EXCEL AND VBA MACROS > Sent: Tue, November 1,

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
s long as ever you can.” - John Wesley - From: Dave To: MS EXCEL AND VBA MACROS Sent: Tue, November 1, 2011 12:50:11 PM Subject: Re: $$Excel-Macros$$ Copy Files & then go back amd delete them Here is how I have your script with all the

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
the Message box "reporting" results, simply comment > > it out. > > > If you insist on copying the files, then going back to delete them, let me > > know and I'll break it into two functions. > > > *Paul* > > > -

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
Here is how I have your script with all the mods you suggested. Its still not copying the files from October 2011. Move command will not work as it screws with permissions etc. When I run the script the Window says Old Files: 10/1/2011 and then it lists all the files created in September 2011.

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Sam Mathai Chacko
p; f.Name > > End If > > Next > > MsgBox msg & Chr(13) & Chr(13) & msg2 > > End If > > End Sub > > > > If you don't like the Message box "reporting" results, simply comment > it out. > > > > If you insist on copying the files, then going

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
EXCEL AND VBA MACROS Sent: Tue, November 1, 2011 11:32:06 AM Subject: Re: $$Excel-Macros$$ Copy Files & then go back amd delete them Paul, The script you wote is great. I just did not know that you could do all the actions  in one step. I ran the script and here is what its doing. In the &

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
Sent: Tue, November 1, 2011 11:32:06 AM Subject: Re: $$Excel-Macros$$ Copy Files & then go back amd delete them Paul, The script you wote is great. I just did not know that you could do all the actions  in one step. I ran the script and here is what its doing. In the "From" director

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
- From: Dave To: MS EXCEL AND VBA MACROS Sent: Tue, November 1, 2011 11:32:06 AM Subject: Re: $$Excel-Macros$$ Copy Files & then go back amd delete them Paul, The script you wote is great. I just did not know that you could do all the

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
copying the files, then going back to delete them, let me > know > and I'll break it into two functions. >   > Paul > - > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
them, let me >know >and I'll break it into two functions. >  >Paul >- >“Do all the good you can, >By all the means you can, >In all the ways you can, >In all the places you can, >At all the times you can, >To a

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Paul Schreiner
e ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Dave To: MS EXCEL AND VBA MACROS Sent: Tue, November 1, 2011 9:03:43 AM Su

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread dguillett1
e = "C:\YOURDIR\NEWFILE" Name OldName As NewName' Move and rename file. Don Guillett SalesAid Software dguille...@gmail.com From: ashish koul Sent: Tuesday, November 01, 2011 2:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Files & then go bac

Re: $$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
Thanks Ashish, But the program is not working , when I pick the source directory I get an error saying "Permission Denied" and when you click on the debugger the following line is highlighted in the code. fso.Copyfile fil.Path, Sheets(1).Range("b1").Value What I want from the program is as follow

$$Excel-Macros$$ Copy Files & then go back amd delete them

2011-11-01 Thread Dave
Hi, I need help with the following task. Thanks in advance I am using MS Excel 2010. I have two folders: A & B. I want to do the folllowing tasks 1, Every month I want to copy all files that are 1 month old (these are all .PDF files) from folder A to folder B. 2, Then I want to verify if the fi