Hi all,
I have following code which works fine to create folder.
I want to include columns A, B, C as name of the file from Range A2 down and if folder is already created then it will not duplicate it.
I am planning to incorporate this code while file is opened or assign it to userform submit button
Need some help please.
many thanks
Please Login or Register to view this content.
Kind regards
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Olly,
Thanks for a prompt reply.
-It still takes values from Row1 to 4 and creates 4 folders, as I want to create 1 folder taking values from 1 to 3.
-It needs to take values from row 2 on wards down ( 1 to 3)
And Following goes to debug
fso.CreateFolder (xdir)
We are almost there
Thanks
Kind regards
Sorry forgot code tagsPlease Login or Register to view this content.
Sorry again I stand corrected
It still takes values from COLUMNS1 to 4 and creates 4 folders, as I want to create 1 folder taking values from 1 to 3.
Sorry, I'm now even less clear on your requirement.
Can you attach an example workbook, and show what your required output (folders) would be...
Hi apology for bit confusing. It happens some times.
Really appreciate your help.
I have attached the sample workbook
Kind regards
Better
Use:
Note that you can't use either / or \ in a file or folder name, so I've formatted your dates as dd-mm-yyyy.Please Login or Register to view this content.
Last edited by Olly; 04-04-2014 at 03:49 PM. Reason: oops - changed my dev folder path!
Hi Olly,
Perfect solution mate.
You made my day. I have understood it now.
Many Thanks
Kind Regards
Glad you're sorted! Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks