requirement to run OutputToText, OutputToExcel commands

M

Ming

I have a macro which use several RunCommands with different command arguments

Two of command arguments are disabled (greyed)-- OutputToText and
OutputToExcel when running application. But, They are available in the debug
mode. Is there any special permissions or settings required to run these
commands? We noticed this issue starts to happen since we use InstallShield
WindowInstaller project to install this application.
 
B

BeenPuzzled44

I do not know exactly what it is called but there are add-ins for this that
must be selected when you install Access. Did you choose to install all
add-ins? If not, maybe this one was not selected. It's been a long time
since I last installed Access but I know there is at least one that allows
Access to communicate with other Office apps. You should be able to install
or remove any add-ins from the install disc. I always install all features
just in case I ever need something. Strangely though, we had a problem on a
PC at my job where all Office features were installed and the option you are
talking about was still grayed out so it may actually be a Windows problem.
Actually our IT department didn't know how to fix it without reinstalling
Windows. Hopefully you are just missing an add-in though and won't have to
do that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top