Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FileSystemObject not available in Access VBA? 1

Status
Not open for further replies.

ftpdoo

Programmer
Aug 9, 2001
202
GB

Im want to save a text file from Access VBA.. But get the error "User defined type not defined"! When i try to use the FileSystemObject object. Any ideas how i could do this?

Thanks,
Jonny


================================================
Dim pobjFso As FileSystemObject
Dim pobjStream As TextStream

Set pobjStream = pobjFso_OpenTextFile("")
 
You'll need to set a reference to 'Microsoft Scripting Runtime'

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top