How to Use the Shell Automation Library in VBA | Part 1

Thanku sigma coding...love you

Thank you for the beautiful code.

There is a requirement like creating folders on daily basis naming them with current date n month. But the issue is everything day I need to collate data in Excel from different sources (may be 50 or so) and flash them to management keeping segregated regional folders n at the same time I need to attach bunch of Excel files which is awkward.. is there any way to zip those files using VBA script before sending them.

That will be very helpful to me.

I know you are genius you can do it..

Also pardon me if I am expecting more from you..

Thank you in advance

Does the ShellExecute method wait until the called script has ended executing to move on with the program? I've been using the default vba shell command and that's an annoying issue I have. Obviously I can put an application.wait after it, but that's just a workaround.



Thanks.

Hi, is there a way to create zip folder using vba. .i need to have many excel files in them

Thanks a lot. The link to Github seems to be broken. Can you provide with the code please?

Thank you!
Sorry, but the link is broke. Further, the content for the .py file is needed.

Hey: how do you handle namespace with variable inputs?
Set objFolder = shellObj.namespace("C:\ExampleFolder") will work fine for me, but if I have something like
folderName = "C:\ExampleFolder"
Set objFolder = shellObj.namespace(folderName)
I end up with errors.

wow, this actually looks really useful

File System Objects can do the folders

good lesson

Is part two coming soon?

GREAT! How Can I export the first four sheets of the workbook as PDF and export another word file in the same folder then export the rest of sheets. All these exported should be merged in one PDF in that order

i have a scenario where i need to write file properties like Tags and Comments to any file type. Is there a way i can do this using Shell32?