Error message on export

  • Thread starter Thread starter matt
  • Start date Start date
M

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.
 
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.
 
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.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top