How to create folders and files automatically using VBA. More details available on this web link: www.exceltrainingvideos.com/c...
Пікірлер: 24
@shirish71483 жыл бұрын
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.
@Exceltrainingvideos3 жыл бұрын
No idea.
@srinivassri70673 жыл бұрын
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.
@Exceltrainingvideos3 жыл бұрын
Concatenate 'Testing' with String from inputbox like 1, 2, 3, etc.
@nyarach3 жыл бұрын
Sir, can we copy a range of data from another workbook into the files in the folder you have just created automatically?
@Exceltrainingvideos3 жыл бұрын
Yes.
@nandhad45573 жыл бұрын
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.
@Exceltrainingvideos3 жыл бұрын
Ok I will try
@sritharank93663 жыл бұрын
Sir I want to allow users to do data entry based on his rights while login. Kindly enlighten me and thanks
@Exceltrainingvideos3 жыл бұрын
Use a database like MS Access.
@abdel-fattahmaghari98063 жыл бұрын
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
@Exceltrainingvideos3 жыл бұрын
You can place file names in the worksheet and loop through them. You can also use arrays, etc. etc.
@kalpeshparkar98523 жыл бұрын
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.
@Exceltrainingvideos3 жыл бұрын
Noted.
@AnilKumar-vi8oe3 жыл бұрын
Hello sir, please make a video on unzipping zip file and to copy recent file from a folder
@Exceltrainingvideos3 жыл бұрын
Will work on this idea.
@raghvendranathmishra72493 жыл бұрын
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
@Exceltrainingvideos3 жыл бұрын
Noted.
@raghvendranathmishra72493 жыл бұрын
Dinesh Kumar Takyar Sir Pls make the video on my query pls