VBA to Import Updated Forms in Text Files

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,670
Office Version
2013
Platform
Windows
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:

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,102,363
Messages
5,486,409
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top