Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: VBA to Import Updated Forms in Text Files

  1. #11
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,474
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA to Import Updated Forms in Text Files

    okay good.
    Note that I chose to declare the base_directory as a variant because it's easy and convenient to check its status as Empty. That way I don't have to worry about Null strings or empty strings or blank strings As you can see from the sample sub, it works whether or not the calling function expects a string or a variant/string. It also tends to work well in Access generally since we have database data types and vba data types and that can be confusing in its own right.
    Last edited by xenou; Feb 19th, 2019 at 04:16 PM.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •