Create Folders and Files Automatically

  Рет қаралды 14,096

Dinesh Kumar Takyar

Dinesh Kumar Takyar

3 жыл бұрын

How to create folders and files automatically using VBA.
More details available on this web link: www.exceltrainingvideos.com/c...

Пікірлер: 24
@shirish7148
@shirish7148 3 жыл бұрын
Hello sir, firstly I would like to say thank you so much for your videos... They're really helpful. Could you please help us in understanding on if we can create json files with various child n parent nodes from Excel tabular information please. Thank you again.
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
No idea.
@srinivassri7067
@srinivassri7067 3 жыл бұрын
Hello Sir, How can i create a folder with name as " Testing ". This number user should be able to give as it changes every time when worked on a different project. and within this folder can we create sub folders and how can we do so. Is it possible to give a specific path where the folder can be created apart from creating in local. can we create folder in shared location i.e. in shared enterprise workspace.
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Concatenate 'Testing' with String from inputbox like 1, 2, 3, etc.
@nyarach
@nyarach 3 жыл бұрын
Sir, can we copy a range of data from another workbook into the files in the folder you have just created automatically?
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Yes.
@nandhad4557
@nandhad4557 3 жыл бұрын
Hello sir, please make a video on taking a screenshot and uploading the image to share path in a particular folder automatically in VBA coding.
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Ok I will try
@sritharank9366
@sritharank9366 3 жыл бұрын
Sir I want to allow users to do data entry based on his rights while login. Kindly enlighten me and thanks
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Use a database like MS Access.
@abdel-fattahmaghari9806
@abdel-fattahmaghari9806 3 жыл бұрын
nice lesson but to make the code more better if somebody want to create more than files in one time it supposes making inputbox shows more than time after create firs file and ask me if i would create another file or write more than file inputbox and create one time it just idea
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
You can place file names in the worksheet and loop through them. You can also use arrays, etc. etc.
@kalpeshparkar9852
@kalpeshparkar9852 3 жыл бұрын
Sir I have emailed you 1 query... Please let me know if it's possible in VBA coding... I am struggling a lot to find any kind of solution.
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Noted.
@AnilKumar-vi8oe
@AnilKumar-vi8oe 3 жыл бұрын
Hello sir, please make a video on unzipping zip file and to copy recent file from a folder
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Will work on this idea.
@raghvendranathmishra7249
@raghvendranathmishra7249 3 жыл бұрын
Sir Pls resolve my query I have data in row as below Row A Product Name Row B PO Number Example Product PO no A 201 A 202 A. 302 B. 401 B. 402 B. 403 We want report as below Product A. 201 202. 203 B. 401. 402. 403 We have required Product In unieque and PO in multiple column to minimise our report Pls
@Exceltrainingvideos
@Exceltrainingvideos 3 жыл бұрын
Noted.
@raghvendranathmishra7249
@raghvendranathmishra7249 3 жыл бұрын
Dinesh Kumar Takyar Sir Pls make the video on my query pls
Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)
48:33
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 165 МЛН
Became invisible for one day!  #funny #wednesday #memes
00:25
Watch Me
Рет қаралды 59 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 41 МЛН
Survival skills: A great idea with duct tape #survival #lifehacks #camping
00:27
Reduce VBA Errors by 90% (with this little-known Method)
16:59
Excel Macro Mastery
Рет қаралды 57 М.
Create reports from raw data automatically with loops, auto-filter and VBA
18:38
Excel VBA | Get File Names and Details in folders and sub folders
20:03
Extreme Automation - Kamal Girdher
Рет қаралды 61 М.
VBA: Create Multiple Folders from Excel Range
7:47
PK: An Excel Expert
Рет қаралды 41 М.
VBA to BROWSE & COPY Data from SELECTED File in Excel
10:00
Leila Gharani
Рет қаралды 323 М.
How to make your Excel VBA code run 1000 times faster
16:55
Excel Macro Mastery
Рет қаралды 358 М.
The 7 Keys Areas of Excel VBA (with code examples)
28:00
Excel Macro Mastery
Рет қаралды 64 М.
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 165 МЛН