Ive got the following code behind a command button:
DoCmd.TransferText transfertype:=acExportDelim, tablename:="Caterer Jobs", FileName:="e:\catererjobs.txt"
Dim WordDoc As Object
Dim WordApp As Object
Set WordApp = CreateObject(Word.Application)
Set WordDoc = GetObject("E:\catererjobs.txt", Word.Application)
I'm getting "Active X Component Can't Create Object" run time error....any ideas?!
DoCmd.TransferText transfertype:=acExportDelim, tablename:="Caterer Jobs", FileName:="e:\catererjobs.txt"
Dim WordDoc As Object
Dim WordApp As Object
Set WordApp = CreateObject(Word.Application)
Set WordDoc = GetObject("E:\catererjobs.txt", Word.Application)
I'm getting "Active X Component Can't Create Object" run time error....any ideas?!