Is there or has anyone coded Excel VBA to run CCleaner ?
The reason is because Excel hangs when doing continuous web queries and we don't want to have to stop the process and use CCleaner every ~ 15 minutes or so.
Thanks
Is there or has anyone coded Excel VBA to run CCleaner ?
The reason is because Excel hangs when doing continuous web queries and we don't want to have to stop the process and use CCleaner every ~ 15 minutes or so.
Thanks
Bump,
I'm sure if someone sees your thread, and can help, they will.
Meanwhile, have you tried the fount of all wisdom - The Internet?
Meanwhile, have you tried the fount of all wisdom - The Internet?
Yes.
The reply was to ask here, at this forum.
this should get you started;
Sub test()
program = “C:\Program Files (x86)\Notepad++\notepad++.exe”
File = “C:\Program Files (x86)\Notepad++\readme.txt”
x = Shell(program + " " + File, vbNormalFocus)
End Sub
obviously adjust accordingly.
Most of the options are here,
http://superuser.com/questions/450014/clearmytracksbyprocess-all-options
Some of the VBA code/options to use is;
obviously adjust accordingly.
Adjust what ?
That macro example I gave you.
It opens a file called readme.txt using NotePad++
So for your needs, change the program variable to use CCleaner and the file variable wouldn't be needed.