Clear contents from the "Excel Folder" in the drive C

[kelly mort]

Hello Geniuses,

How do I locate and clear the contents of the "Excel Folder" located under the "AppData" folder?

I mean with a vba code.

Thanks

 

[Logit]

.
This will get you to the folder :

https://stackoverflow.com/questions...-to-the-current-users-application-data-folder

http://codevba.com/office/environ.htm#.XHHdIYhKhhE

 

[kelly mort]

Okay. Thanks was very helpful

Just that I am not able to write the script that will locate the folder then delete all the contents of that folder.

I am still working on it. If someone can help in will be glad

 

[Logit]

.
This should do it.

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">[COLOR=#303336][FONT=inherit]Sub Del()
  Kill "C:\FolderName\*.*"
End Sub[/FONT][/COLOR]</code>

Change FolderName to the actual name of the folder. If the files you want to delete are further 'down' ... located in other folders,
you will need to provide the full path to the folder where the files are located.

Ex: "C:\Folder 1\Folder 2\Folder 3 (This is the folder where the files are located)"

 

[kelly mort]

Oh okay. Problem solved

 

[Logit]

.
Great !