Remove space from name of folder. It should be "Folder5" & not "Folder 5".
Thx On Sat, May 3, 2014 at 5:14 PM, prkhan56 <prkha...@gmail.com> wrote: > Hello Vaibhav > > When I run the macro > > I get this error: Run time 1004 > > Microsoft Excel cannot access the file C:\Test\Macro\Folder 5….*.I don’t > know how Folder 5 is coming here please* > > The following gets highlighted > > .SaveAs "C:\Test\Macro\" & FolderName & "\" _ > > & c.Value & FileExtStr, _ > > FileFormat:=FileFormatNum > > Any solution so I can test it further please? > > Thanks once again. > > Rashid Khan > > On Saturday, May 3, 2014 10:13:53 AM UTC+4, Vabz wrote: > >> Hi >> >> PFA >> >> HTC//Cheers >> >> >> On Sat, May 3, 2014 at 2:13 AM, prkhan56 <prkh...@gmail.com> wrote: >> >>> Dear Vabz, >>> >>> Thanks a lot for your time and effort. >>> >>> At present when I run the Macro it creates Folder1, Folder2 etc in >>> Documents Folder and some Excel files in the same folder. >>> >>> But maybe I need to explain my requirements once again …hope I will be >>> clear this time. >>> >>> 1. >>> >>> The macro should look for x in J to AX >>> 2. >>> >>> If it finds x then it should go to the Path “C:\Test\Macro” and no >>> new Folders should be created. >>> 3. >>> >>> The Path “C:\Test\Macro\” has Folder1, Folder2, Folder3 etc (names >>> are mentioned from J3 to AX3) having an excel file with one sheet only >>> (as >>> per sample shown in the output sheet). >>> 4. >>> >>> If there is one x – let’s see the example of Cell J4; then the macro >>> should fill concatenated values from respective rows A4 which is >>> 07-AB-001 >>> and Name1 from I4 in Folder1. >>> 5. >>> >>> If there is more than one x (eg Column K) then 3 sheets should be >>> created and filled with the concatenated Ref and Names in the respective >>> row where x is shown. >>> 6. >>> >>> Column L values in Folder3, Column M values in Folder4 and so on. If >>> there is no x in the Column then no action required. >>> 7. >>> >>> Only if x is shown in the Column then new sheet would be created as >>> per the x found and respective Ref and Names pasted. >>> >>> Hope it is clear this time. >>> >>> Thanks once again for your help >>> >>> Regards >>> >>> Rashid Khan >>> >>> >>> On Thursday, May 1, 2014 2:02:57 PM UTC+4, Vabz wrote: >>> >>>> Hi >>>> >>>> Refer this, >>>> >>>> when prompted for selecting range you need to select range from I4 to >>>> down.. >>>> >>>> Cheers!! >>>> >>>> >>>> >>>> On Thu, May 1, 2014 at 3:18 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>> >>>>> Hi >>>>> >>>>> Pfa. Click to run Macro. Put "\" at the end of folder name. >>>>> >>>>> Cheers!! >>>>> >>>>> >>>>> On Thu, May 1, 2014 at 10:35 AM, prkhan56 <prkh...@gmail.com> wrote: >>>>> >>>>>> Hello Paul, >>>>>> I don't how to write a macro...and I request someone to write it for >>>>>> me please. >>>>>> >>>>>> Thanks >>>>>> Rashid >>>>>> >>>>>> >>>>>> On Wednesday, April 30, 2014 5:21:27 PM UTC+4, Paul Schreiner wrote: >>>>>> >>>>>>> Do you know how to write macros and are asking for help? >>>>>>> or are you asking for someone to write the macro? >>>>>>> >>>>>>> *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:* Rashid Khan <prkh...@gmail.com> >>>>>>> *To:* excel-macros <excel-...@googlegroups.com> >>>>>>> *Sent:* Wednesday, April 30, 2014 8:05 AM >>>>>>> *Subject:* $$Excel-Macros$$ Macro to look for x in Columns and >>>>>>> paste data in worksheet in various folders >>>>>>> >>>>>>> Hello All, >>>>>>> I am using Excel 2010 and have the following problem. >>>>>>> >>>>>>> I need a macro to look for x in Columns J to AX (Sample File >>>>>>> Attached). >>>>>>> >>>>>>> If it finds x then it should go to the Folder “C:\Test\Macro” which >>>>>>> contains the Folder names shown in J3 to AX3. >>>>>>> >>>>>>> It should open the file inside the respective Folders 1, 2, 3….etc >>>>>>> and paste the values No1 to No5 shown in Cells A3, C3, E3, F3 H3 (see >>>>>>> various possibility shown here). >>>>>>> >>>>>>> No1-No2-No3-No4-No5 >>>>>>> No1-No2-No3 >>>>>>> No1-No2-No3-No4 >>>>>>> >>>>>>> It should be concatenated with a hyphen. If any No is blank then it >>>>>>> should not be concatenated (See Output Sheet on the sample file >>>>>>> attached) >>>>>>> >>>>>>> Thanks in advance >>>>>>> Rashid >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 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) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to excel-macros...@googlegroups.com. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> >>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>>> >>>>>>> -- >>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 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) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to excel-macros...@googlegroups.com. >>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
