VBA to Clear Cache in Excel

[Pinaceous]

Good Day All,

Is there a vba macro to clear cache in excel?

For example as in;

Clear Cache in Excel

Please let me know!

Thank you!
pinaceous

 

[johnnyL]

I am guessing that it could be done via SendKeys:

Alt f
t
s
Alt d
Alt d
Space bar
Tab
Space bar


But I am not that familiar with that type of coding.

 

[Pinaceous]

I am guessing that it could be done via SendKeys:

Alt f
t
s
Alt d
Alt d
Space bar
Tab
Space bar


But I am not that familiar with that type of coding.

Okay thank you for responding but I'm looking for a vba solution.

When I go to record a macro for that purpose it turns up blank.

Do you know if there is a macro solution?

 

[johnnyL]

I gave the hint for the VBA solution ... SendKeys

 

[Pinaceous]

Okay thank you for the hint!

 

[Pinaceous]

Good Day,

In working with the provided suggestions of this post above, is there a way to access the Delete Cached Files icon in the screen shot below in lieu of using the send keys tab key (17 x's) then the spacebar?

Thanks!
pinaceous

 

[johnnyL]

What code are you using to get to that point?

 

[Pinaceous]

What code are you using to get to that point?

Good Day johnnyL,

Sub Macro4()
'
' Macro4 Macro
'

'
    Range("A1").Select
   
    SendKeys "%"
   
    SendKeys "(F)"
   
    SendKeys "(T)"
   
    SendKeys "^"
   
    SendKeys "(S)"
   
       
    SendKeys "%"
   
    Application.SendKeys "(D)"
   
   
    Application.SendKeys ""
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
    'SendKeys "(TAB)"
   
    'Application.SendKeys ("%mn")
   
End Sub

I cannot get the last half to work.

Thank you!

pinaceous

 

[johnnyL]

That code does not get you to the window you showed.

 

[Skyybot]

I saw this on the web. Is it what you're looking for?

Application.RecentFiles.Maximum = 0