DoCmd.outputto excel problem

[jrmurphy82]

Hi,

I have an access database that works on every computer except one. The
computers are all running the same version of Windows (XP Pro) and Office
2007.

The line of code causing my problem is shown below:

DoCmd.OutputTo acOutputReport, stDocName, , , True


stDocname is a string.

The line of code originally contained acFormatXLS for the OutputFormat
argument, but it kept throwing an error on the one computer. So I took it
out of the code in order to have Access prompt the user to choose a file type.


On the computers that work, we get the full list of output types including
two .xls formats.

On the computer that doesn't work, the .xls formats are missing from the list.


Many other forums have suggested using the TransferSpreadsheet method, but
this will not be suitable for our purposes.

Can anyone please suggest a reason why .xls would not show up as an output
format?

Thank you in advance for any help.

 

[Jerry Whittle]

On that computer got to the Windows button, Programs, Microsoft Office,
Microsoft Office Tools, Microsoft Office Diagnostics. See if that can find
the problem with the Office installation and fix it.

 

[jrmurphy82 via AccessMonster.com]

Thanks for the suggestion, but this did not fix the problem. Any other ideas?


Thanks!

 

[Jerry Whittle]

What happens when you go up to the External Data tab on the Ribbon and try to
use Excel in the Export box?

 

[jrmurpnhy82 via AccessMonster.com]

The excel option is grayed out in the ribbon on the problem computer, but
works on all the other computers. I wonder if uninstalling and then
reinstalling would fix the problem, but that would be a big pain and I feel
like there should be another solution.

Thanks!

 

[Jerry Whittle]

This might be a stupid question on my part, but is Excel installed on that
computer?

It's also possible that someone did a partial install of Office on that
computer and didn't install the needed files. I don't think that you need to
do an uninstall. Just put in the installation disk and see if it allows you
to install more options to the existing install.