none
Is there a way to check for the existence of a file located on the end users environment using VBA in Excel 2013? RRS feed

Answers

  • It might be better (for compatibility reasons) to simply forget about this particular library and use instead a calendar control formatted entirely in VBA. I personally rather like Trevor Eyre's version - You can find that here. You can call it on entry to your userform text field that takes the month.

    Graham Mayor - Word MVP
    www.gmayor.com

    • Marked as answer by KeithAul Sunday, April 19, 2015 12:40 AM
    Saturday, April 18, 2015 11:29 AM

All replies

  • There are several setup installers out there.  I prefer Inno Setup (free).  You'll need to add a line like this:

    [Files]
    Source: "cal\mscomct2.ocx"; DestDir: "{sys}";  Flags: restartreplace sharedfile regserver;

    This will install in the Windows C:\Windows\System32 dir and register it.

    http://www.jrsoftware.org/isinfo.php

    Friday, April 17, 2015 11:26 PM
  • It might be better (for compatibility reasons) to simply forget about this particular library and use instead a calendar control formatted entirely in VBA. I personally rather like Trevor Eyre's version - You can find that here. You can call it on entry to your userform text field that takes the month.

    Graham Mayor - Word MVP
    www.gmayor.com

    • Marked as answer by KeithAul Sunday, April 19, 2015 12:40 AM
    Saturday, April 18, 2015 11:29 AM