Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using VBA in excel to how to delete temporary files or coo..

 
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Formatting number in Data Table  
Author Message
Hans

External


Since: Dec 9, 2008
Posts: 3



(Msg. 1) Posted: Tue Dec 09, 2008 8:40 am
Post subject: Using VBA in excel to how to delete temporary files or cookies
Archived from groups: microsoft>public>excel (more info?)

Is there any way to delete temporary files or cookies by using vba ocde from
excel?

 >> Stay informed about: Using VBA in excel to how to delete temporary files or coo.. 
Back to top
Login to vote
Garys Student

External


Since: Nov 19, 2008
Posts: 6



(Msg. 2) Posted: Tue Dec 09, 2008 11:55 am
Post subject: RE: Using VBA in excel to how to delete temporary files or cookies
Archived from groups: per prev. post (more info?)

Sub marine()
Kill "C:\test\sample.doc"
End Sub

 >> Stay informed about: Using VBA in excel to how to delete temporary files or coo.. 
Back to top
Login to vote
Harlan Grove

External


Since: Dec 4, 2008
Posts: 4



(Msg. 3) Posted: Tue Dec 09, 2008 5:26 pm
Post subject: Re: Using VBA in excel to how to delete temporary files or cookies
Archived from groups: per prev. post (more info?)

Hans wrote...
>Is there any way to delete temporary files or cookies by using vba ocde from
>excel?

Sub foo()
Shell Environ("Comspec") & " /c del ""%TEMP%""\*.tmp"
End Sub
 >> Stay informed about: Using VBA in excel to how to delete temporary files or coo.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Opening old excel files - I have a spread sheet application that I have been using for years. I started with SuperCalc, imported to Quttro Pro and then to Lotus 123 and later to Excel. I had to make minor changes to the macros and the data base operations. It has been..

Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..

Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel Licensing? - I have the Student/Teacher version of Office, licensed for 3 machines. And it's installed on three machines and all is well with the world. Almost... My wife was upset with the performance of Vista on her computer so I installed XP on it in a dual boot....

Date in excel - When I start Excel I would like to set the system time automatic back. Something like this Read current date Set date to 25-12-9 start excel stop excel Set date to curret date Can anybody help with this ?
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]