exporting to excel and activating workbook

[JCBuffalo]

Just upgraded to Great Plains 9.0 and FRx 6.7 and when exporting drilldowns
to excel I can't get any of the excel files to pop up when they are finished.
If I use file/export/worksheet file/Excel - just a blank excel sheet pops
up. If I use file/export/worksheet file/formatted Excel - it gives me an
Excel error telling me that the file could not be found and to check the
spelling of the file and verify the correct location? But if I then try and
reopen it manually the file is there?? Why can I not get it to pop up
automatically?

[Rick Tenorio - FRx Software Corp]

JCBuffalo,

This is a known issue with Service Pack 9 for Microsoft FRx 6.7. It is
scheduled to be resolved in the next service pack.

The problem occurs whenever spaces are present in the directory path. For
example: “C:\Program Files\FRx” is split into “C:\program” and also
“Files\FRx”. Both of which are not valid locations.

There are two workarounds for this issue. First is to deselect the
“Activate Workbook” feature in the catalog screen for the report. This
obviously will stop the error, but will also stop Excel from opening up
automatically once the file is generated. The second option is to generate
the file to a directory path that does not have spaces in it. Something like
“C:\FRx”.

We realize that this is an inconvenience to our users.

Hope this helps.

Rick Tenorio MCDST, MCP [MSFT]
FRx Software Corporation - a subsidiary of Microsoft

**This posting is provided "AS IS" with no warranties, and confers no
rights.**

[Victoria [MVP]]

Rick,

Can you tell us if there is an expected date for the next service pack?

Thanks!
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"Rick Tenorio - FRx Software Corp"
<RickTenorioFR...@discussions.microsoft.com> wrote in message
news:E9628436-D2A8-4C01...@microsoft.com...

[Rick Tenorio - FRx Software Corp]

At this time no date has been announced.

Rick Tenorio MCDST, MCP [MSFT]
FRx Software Corporation - a subsidiary of Microsoft

**This posting is provided "AS IS" with no warranties, and confers no
rights.**

[anish...@gmail.com]

Hi i have an issue with FRx6 .When exporting to excel as a normal user it gives an error "Run Time error 91 Object Variable or with block variable not set".

When exporting as a administrator or running report designer as an administrator the export is successful.

Please help me.