Delete Function in macro tool

[laxmanann]

Hi there,

I have macro to fetch all the files and files related details.I'm Struck with the empty files and folder derivation.
Here i need to add a button to select the empty files and folders and delete the selected empty files from the directory.


Thanks,

[nathansav]

Please Login or Register  to view this content.

Where fl is scripting.file and fld is scripting.folder.

[laxmanann]

Thanks Nathan for the quick reply..Here im not only gonna to delete 0MB folder and file..File which means all type of files (Which has any type of extension) need to delete

And where i need to add this code..new module or ?

Thanks.

[noboffinme]

OK, so you use the 'Browse' button to upload data to your userform.

What do you mean by being "Struck with the empty files and folder derivation" (I assume you mean stuck not struck)

What do these entries look like?

I need a working example of the problem.

Cheers

[laxmanann]

Dear noffoffine,

Thanks..here with the macro im able to reterieve the file details of any folder or from directory.If i have any empty files/folders in the selected folder or directory means it should be listed out after clicking fetch button..Now i need a button which should retreive only a empty files and folders after fetching the results and i need to delete all the unwanted files(Means 0MB,KB) files and folders from the diretory or our local directory.Which should be done by the newly added button.Because it's very difficult to delete all the files manually ...

Before deleting the pop up mesage should ask us for a confirmation
And is there any option to display the deleted empty file names alone after and before deleting.

Thanks

[noboffinme]

OK, it would help if you could post some data to Browse to.

It might help me understand this issue better.

Cheers

[laxmanann]

OK..this is a macro which will fetch our own system files..Pls follow the below steps .
First Click browse button ->Select any of your folder from your system->Select the button Fetch all type of files->Then select "Fetch all files and details" button..it should display all the files details in the down excel column and rows.

Let me know for any questions

[noboffinme]

OK, I know that I can browse to a file & fetch it but I want to use the same data as you are using.

Can you post your file (that you browse to) or a similar example & attach it to this post?

Thanks

[laxmanann]

Dear Nof,

As Discussed i have atttached the sample file.Pls chk and help me out.

Thanks

[noboffinme]

Thanks so the Delete button will delete the Rows where the 'File Size' value = 0, is that what you want?

[laxmanann]

Exactly Nob,

Thanks..It would be great if i have one clear button to clear all the felds.

Thanks

Thanks so the Delete button will delete the Rows where the 'File Size' value = 0, is that what you want?

[noboffinme]

Here's the script, there is already some code in your file.

Have you written that?

Please Login or Register  to view this content.

[laxmanann]

Dear nob,
Thanks..yes I have written code.I just want to add this retrived cells data clear cell and I want to delete those 0 weight files with this macro.can you please help me to delete those 0 or empty files from the directory using the button from macro tool itself..

Thanks,

[noboffinme]

Here you go.

See the attached.

Cheers

[laxmanann]

Hi Nob,

Thanks for the response..This macro can delete the rows which has 0 mb files reports.But my requirement is ..after fetching all the file details using macro i need to delete the file/empty files from the Folder or directory path (Which path or folder we are browsing).
Please help me on the same..
Thanks

[laxmanann]

By using the below code am able to delete the empty folders.But i need delete all the 0 kb files present in the particular folder or directory.
Pls help me..Also where i ll update the below code in my macro..

Please Login or Register  to view this content.