Error message on export

[matt]

I recieve the following error message when I attempt to
run a macro with an export as excel file action in it. It
reads, "The Formats that enable you to output data as a
Microsoft Excel, Rich text format, MS-DOS text, or HTML
file are missing from the windows registry."
Does anyone know the solution to this? Any help would be
great. thanks, matt.

 

[John Nurick]

Hi Matt,

The first thing to try is re-registering some DLL files. If the
import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

 

[matt]

John,
thanks for your help. I followed your instructions and
all is working properly now. thanks again. matt.

-----Original Message-----
Hi Matt,

The first thing to try is re-registering some DLL files. If the
import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re- register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

I recieve the following error message when I attempt to
run a macro with an export as excel file action in it. It
reads, "The Formats that enable you to output data as a
Microsoft Excel, Rich text format, MS-DOS text, or HTML
file are missing from the windows registry."
Does anyone know the solution to this? Any help would be
great. thanks, matt.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.