FoxPro JustFName() function

The VFP JustFName() function returns the name of a file complete with its extension.

JustFName ("C:\Microsoft Visual FoxPro 9\vfp9.exe")

would return:

"vfp9.exe"

Use the JustStem() function if you want the stem of the filename without any extension.

VBA equivalent

Microsoft Access does not have equivalents to these FoxPro file name commands so I wrote this library Visual Basic functions to do give me the same facilities in VBA.

FoxPro DefaultExt function

Using DefaultExt() to correct file extensions in a FoxPro program.

FoxPro ForceExt function

Using ForceExt() to correct file extensions in a FoxPro program.

FoxPro ForcePath function

Using ForcePath() to correct path names in a FoxPro program.

FoxPro JustExt function

Using JustExt() to get the extension from a file name.

FoxPro JustPath function

Using JustPath() to get the path from a full file name.

FoxPro JustFName() function

VBA equivalent

FoxPro DefaultExt function

FoxPro ForceExt function

FoxPro ForcePath function

FoxPro JustExt function

FoxPro JustPath function

January 2014

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro database training and development

Phone us on 0121 445 1300, email [email protected], or use our contact page