Youtube Linkedin Twitter RSS
Logo
Automating Business Through Excel Soloutions
Contact Us | Newsletter | Blog | Members    +61 (7) 5641 2111

Posts tagged as:

getfile

Prompt user to select file

by Craig Stones on March 18, 2010

The following module is an interface which prompts the user of the document to select a text file from a pop up dialog box (similar to the Open or Save As window).  Once the file is selected, the pathname and document name is recorded.  This pathname/filename can then be used to automatically open the text file and further coding used to import and format the data. This macro is particularly useful for reporting purposes where data is imported on a regular basis.

[click to continue…]

{ 0 comments }