Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
NOW we're getting somewhere. Keep in mind that you've asked the question in an EXCEL Macros group. It's kind-of like calling a Plumber and asking him to come and fix a leak. When he arrives, he finds that the leak is in the ROOF. Of course he MAY be able to fix it, but that's not his primary purpose. You really don't need excel at all. What you really need is someone that knows how to write VBA in Outlook to automate the process of detaching the attachments and place them in a specified folder. I won't be able to help you there. I'm more like a REALLY FAST Plumber that cannot stand ladders... Perhaps someone else in this group can assist (or point you to a group for Outlook programming) 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 all the people you can, As long as ever you can.” - John Wesley - From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Wed, October 3, 2012 8:40:10 AM Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder now i have a folder in outlook, folder contain many mail, every mail has a attachment with same name. i want to save all attachment in my desktop folder with different name.. On Wed, Oct 3, 2012 at 5:54 PM, Paul Schreiner wrote: OK... I'm going to try one more time. >Please be CLEAR. > >Are the folders IN OUTLOOK? > >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 all the people you can, >As long as ever you can.” - John Wesley >- > > > > > From: Manoj Kumar >To: excel-macros@googlegroups.com >Sent: Wed, October 3, 2012 7:34:09 AM > >Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder > > >Sorry for delay > > >i have outlook mail save in folder every mail has excel attachment... >i want to extract all excel in onether folder.. > > >Regard >Manoj > > > >On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner wrote: > >Are you saying that the folders are IN Outlook? >>Not on your filesystem? >>(that is like "C:\temp\X") >> >>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 all the people you can, >>As long as ever you can.” - John Wesley >>--------- >> >> >> >> >> From: Manoj Kumar >>To: excel-macros@googlegroups.com >>Sent: Wed, October 3, 2012 3:52:31 AM >>Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder >> >> >>Dear vabz, >> >> >>Thanks. >> >> >>but it's not working.. >> >> >>Regard >>Manoj >> >> >>On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: >> >>Hi >>> >>> >>>PFA Files.. >>> >>> >>>Cheers.. >>> >>> >>>Rgds//Vabs >>> >>>On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>>Dear Export, >>>> >>>> >>>>I have one folder "x" witch has contain mail's, every mail contain an excel >>>>file, >>>>i want to copy all excel file from folder "x" to onther folder with >>>>different >>>>name.. >>>> >>>> >>>> >>>> >>>>Regard >>>>Manoj-- >>>Join official facebook page of this forum @ >>>https://www.facebook.com/discussexcel >>> >>>FORUM RULES (1120+ members already BANNED for violation) >>> >>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>Help, >>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>>get >>>quick attention or may not be answered. >>> >>>2) Don't post a question in the thread of another member. >>> >>>3) Don't post questions regarding breaking or bypassing any security measure. >>> >>>4) Acknowledge the responses you receive, good or bad. >>> >>>5) Cross-promotion of, or links to, forums competitive to this forum in >&
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
My question is a bit different but will help resolve this issue. What is the file extension of the files in the folder? Regards David Grugeon On 3 October 2012 22:24, Paul Schreiner wrote: > OK... I'm going to try one more time. > Please be CLEAR. > > Are the folders IN OUTLOOK? > > > 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 all the people you can, > As long as ever you can.” - John Wesley > - > > > > > From: Manoj Kumar > To: excel-macros@googlegroups.com > Sent: Wed, October 3, 2012 7:34:09 AM > > Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder > > Sorry for delay > > i have outlook mail save in folder every mail has excel attachment... > i want to extract all excel in onether folder.. > > Regard > Manoj > > > On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner > wrote: >> >> Are you saying that the folders are IN Outlook? >> Not on your filesystem? >> (that is like "C:\temp\X") >> >> >> 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 all the people you can, >> As long as ever you can.” - John Wesley >> ----------------- >> >> >> >> >> From: Manoj Kumar >> To: excel-macros@googlegroups.com >> Sent: Wed, October 3, 2012 3:52:31 AM >> Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder >> >> Dear vabz, >> >> Thanks. >> >> but it's not working.. >> >> Regard >> Manoj >> >> On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: >>> >>> Hi >>> >>> PFA Files.. >>> >>> Cheers.. >>> >>> Rgds//Vabs >>> >>> On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>>> >>>> Dear Export, >>>> >>>> I have one folder "x" witch has contain mail's, every mail contain an >>>> excel file, >>>> i want to copy all excel file from folder "x" to onther folder with >>>> different name.. >>>> >>>> >>>> Regard >>>> Manoj >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >>> not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. Forum >>> owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> To unsubscribe from this group, send email to >>> excel-macros+unsubscr...@googlegroups.com. >>> >>> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post question
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
now i have a folder in outlook, folder contain many mail, every mail has a attachment with same name. i want to save all attachment in my desktop folder with different name.. On Wed, Oct 3, 2012 at 5:54 PM, Paul Schreiner wrote: > OK... I'm going to try one more time. > Please be CLEAR. > > Are the folders IN OUTLOOK? > > > *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 all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Manoj Kumar > *To:* excel-macros@googlegroups.com > *Sent:* Wed, October 3, 2012 7:34:09 AM > > *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder > > Sorry for delay > > i have outlook mail save in folder every mail has excel attachment... > i want to extract all excel in onether folder.. > > Regard > Manoj > > > On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner wrote: > >> Are you saying that the folders are IN Outlook? >> Not on your filesystem? >> (that is like "C:\temp\X") >> >> >> *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 all the people you can, >> As long as ever you can.” - John Wesley >> *--------------------- >> >> >> -- >> *From:* Manoj Kumar >> *To:* excel-macros@googlegroups.com >> *Sent:* Wed, October 3, 2012 3:52:31 AM >> *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder >> >> Dear vabz, >> >> Thanks. >> >> but it's not working.. >> >> Regard >> Manoj >> >> On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: >> >>> Hi >>> >>> PFA Files.. >>> >>> Cheers.. >>> >>> Rgds//Vabs >>> >>> On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>>> >>>> Dear Export, >>>> >>>> I have one folder "x" witch has contain mail's, every mail contain an >>>> excel file, >>>> i want to copy all excel file from folder "x" to onther folder with >>>> different name.. >>>> >>>> >>>> Regard >>>> Manoj >>>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> To unsubscribe from this group, send email to >>> excel-macros+unsubscr...@googlegroups.com. >>> >>> >>> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
OK... I'm going to try one more time. Please be CLEAR. Are the folders IN OUTLOOK? 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 all the people you can, As long as ever you can.” - John Wesley - From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Wed, October 3, 2012 7:34:09 AM Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder Sorry for delay i have outlook mail save in folder every mail has excel attachment... i want to extract all excel in onether folder.. Regard Manoj On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner wrote: Are you saying that the folders are IN Outlook? >Not on your filesystem? >(that is like "C:\temp\X") > >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 all the people you can, >As long as ever you can.” - John Wesley >- > > > > > From: Manoj Kumar >To: excel-macros@googlegroups.com >Sent: Wed, October 3, 2012 3:52:31 AM >Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder > > >Dear vabz, > > >Thanks. > > >but it's not working.. > > >Regard >Manoj > > >On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: > >Hi >> >> >>PFA Files.. >> >> >>Cheers.. >> >> >>Rgds//Vabs >> >>On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>Dear Export, >>> >>> >>>I have one folder "x" witch has contain mail's, every mail contain an excel >>>file, >>>i want to copy all excel file from folder "x" to onther folder with >>>different >>>name.. >>> >>> >>> >>> >>>Regard >>>Manoj-- >>Join official facebook page of this forum @ >>https://www.facebook.com/discussexcel >> >>FORUM RULES (1120+ members already BANNED for violation) >> >>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not >>get >>quick attention or may not be answered. >> >>2) Don't post a question in the thread of another member. >> >>3) Don't post questions regarding breaking or bypassing any security measure. >> >>4) Acknowledge the responses you receive, good or bad. >> >>5) Cross-promotion of, or links to, forums competitive to this forum in >>signatures are prohibited. >> >> >>6) Jobs posting is not allowed. >> >>7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >>NOTE : Don't ever post personal or confidential data in a workbook. Forum >>owners >>and members are not responsible for any loss. >>--- >>You received this message because you are subscribed to the Google Groups "MS >>EXCEL AND VBA MACROS" group. >>To post to this group, send email to excel-macros@googlegroups.com. >>To unsubscribe from this group, send email to >>excel-macros+unsubscr...@googlegroups.com. >> >> >> >-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ members already BANNED for violation) > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. > >2) Don't post a question in the thread of another member. > >3) Don't post questions regarding breaking or bypassing any security measure. > >4) Acknowledge the responses you receive, good or bad. > >5) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
Sorry for delay i have outlook mail save in folder every mail has excel attachment... i want to extract all excel in onether folder.. Regard Manoj On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner wrote: > Are you saying that the folders are IN Outlook? > Not on your filesystem? > (that is like "C:\temp\X") > > > *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 all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Manoj Kumar > *To:* excel-macros@googlegroups.com > *Sent:* Wed, October 3, 2012 3:52:31 AM > *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder > > Dear vabz, > > Thanks. > > but it's not working.. > > Regard > Manoj > > On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: > >> Hi >> >> PFA Files.. >> >> Cheers.. >> >> Rgds//Vabs >> >> On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>> >>> Dear Export, >>> >>> I have one folder "x" witch has contain mail's, every mail contain an >>> excel file, >>> i want to copy all excel file from folder "x" to onther folder with >>> different name.. >>> >>> >>> Regard >>> Manoj >>> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security &
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
Are you saying that the folders are IN Outlook? Not on your filesystem? (that is like "C:\temp\X") 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 all the people you can, As long as ever you can.” - John Wesley - From: Manoj Kumar To: excel-macros@googlegroups.com Sent: Wed, October 3, 2012 3:52:31 AM Subject: Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder Dear vabz, Thanks. but it's not working.. Regard Manoj On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: Hi > > >PFA Files.. > > >Cheers.. > > >Rgds//Vabs > >On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >Dear Export, >> >> >>I have one folder "x" witch has contain mail's, every mail contain an excel >>file, >>i want to copy all excel file from folder "x" to onther folder with different >>name.. >> >> >> >> >>Regard >>Manoj-- >Join official facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES (1120+ members already BANNED for violation) > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. > >2) Don't post a question in the thread of another member. > >3) Don't post questions regarding breaking or bypassing any security measure. > >4) Acknowledge the responses you receive, good or bad. > >5) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > > >6) Jobs posting is not allowed. > >7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners >and members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
Hi Manoj, I hope this will help you. Sub Copy_Folder() Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath = "K:\Prince\Rima" '<< Change ToPath = "K:\Prince\test"'<< Change If Right(FromPath, 1) = "\" Then FromPath = Left(FromPath, Len(FromPath) - 1) End If If Right(ToPath, 1) = "\" Then ToPath = Left(ToPath, Len(ToPath) - 1) End If Set FSO = CreateObject("scripting.filesystemobject") If FSO.FolderExists(FromPath) = False Then MsgBox FromPath & " doesn't exist" Exit Sub End If FSO.CopyFolder Source:=FromPath, Destination:=ToPath MsgBox "You can find the files and subfolders from " & FromPath & " in " & ToPath End Sub Regards Prince. On Wednesday, October 3, 2012 1:13:28 PM UTC+5:30, Manoj Kumar wrote: > > Hi Prince, > > X is my folder name witch has many mail's of outlook..every mail has a > excel attachment.. > > Regard > Manoj > > On Wed, Oct 3, 2012 at 12:52 PM, Prince Dubey > > > wrote: > >> Hi Manoj, >> >> I their any sub folder inside forlder X ? >> >> >> Regards >> Prince >> >> On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >>> >>> Dear Export, >>> >>> I have one folder "x" witch has contain mail's, every mail contain an >>> excel file, >>> i want to copy all excel file from folder "x" to onther folder with >>> different name.. >>> >>> >>> Regard >>> Manoj >>> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-...@googlegroups.com >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com . >> >> >> > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
Dear vabz, Thanks. but it's not working.. Regard Manoj On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: > Hi > > PFA Files.. > > Cheers.. > > Rgds//Vabs > > On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Export, >> >> I have one folder "x" witch has contain mail's, every mail contain an >> excel file, >> i want to copy all excel file from folder "x" to onther folder with >> different name.. >> >> >> Regard >> Manoj >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder
Hi Prince, X is my folder name witch has many mail's of outlook..every mail has a excel attachment.. Regard Manoj On Wed, Oct 3, 2012 at 12:52 PM, Prince Dubey wrote: > Hi Manoj, > > I their any sub folder inside forlder X ? > > > Regards > Prince > > On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Export, >> >> I have one folder "x" witch has contain mail's, every mail contain an >> excel file, >> i want to copy all excel file from folder "x" to onther folder with >> different name.. >> >> >> Regard >> Manoj >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.