ExcelVBAでIE操作 キャッシュ無効でNavigate

Flagsに4を指定

Const navNoReadFromCache = 4

...

objIE.Navigate "https://www.yahoo.co.jp", navNoReadFromCache 

なぜ4なのかはここの定義参照

typedef enum BrowserNavConstants {
    navOpenInNewWindow = 0x1,
    navNoHistory = 0x2,
    navNoReadFromCache = 0x4,
    navNoWriteToCache = 0x8,
    navAllowAutosearch = 0x10,
    navBrowserBar = 0x20,
    navHyperlink = 0x40,
    navEnforceRestricted = 0x80,
    navNewWindowsManaged = 0x0100,
    navUntrustedForDownload = 0x0200,
    navTrustedForActiveX = 0x0400,
    navOpenInNewTab = 0x0800,
    navOpenInBackgroundTab = 0x1000,
    navKeepWordWheelText = 0x2000,
    navVirtualTab = 0x4000,
    navBlockRedirectsXDomain = 0x8000,
    navOpenNewForegroundTab = 0x10000
} BrowserNavConstants;

ネタ元

• http://stackoverflow.com/questions/3421144/how-to-disable-caching-in-the-net-webbrowser-control
• http://msdn.microsoft.com/en-us/library/aa752093(v=vs.85).aspx
• http://msdn.microsoft.com/en-us/library/aa768360(v=vs.85).aspx