When I create an Excel spreadsheet via Automation (from Access) and
then open it by double-clicking it, the Excel GUI has no visible
workbook until I click View|Full Screen. Any idea why?

The workbook opened off the viewable window???

Window|Arrange|tiled
is another way to see stuff that's off the visible screen.

wrote:

When I create an Excel spreadsheet via Automation (from Access) and
then open it by double-clicking it, the Excel GUI has no visible
workbook until I click View|Full Screen. Any idea why?

--

Dave Peterson

That seems to be the case. The entire area where the worksheetbook
should appear (i.e., between the window border / menubars at the top
and the status bar / window border at the bottom) is not just empty,
it's transparent! I can see my desktop through it -- weird, eh?

This started happening as I was trying to figure out how to send Access
report data to a spreadsheet via Automation without data being
truncated to 255 characters (DoCmd.OutputTo) or losing all formatting
(TransferSpreadsheet). The documentation being what it is, I had to
experiment with the usual snippets of code gleaned from various places,
and I suspect I managed to clobber a setting in the Registry that's now
causing Excel to start up with no active workbook being displayed. Any
ideas on how to undo whatever I did wrong will be greatly appreciated.

There have been a few posts about that transparency problem (I've never seen it,
though).

I think the solution was to reboot when this happens. (Not much of a solution,
huh?).

I don't speak the Access, but maybe this post from Debra Dalgleish (who does
speak the Access) will help:

http://google.co.uk/groups?threadm=4...resXSPAM .com

wrote:

That seems to be the case. The entire area where the worksheetbook
should appear (i.e., between the window border / menubars at the top
and the status bar / window border at the bottom) is not just empty,
it's transparent! I can see my desktop through it -- weird, eh?

This started happening as I was trying to figure out how to send Access
report data to a spreadsheet via Automation without data being
truncated to 255 characters (DoCmd.OutputTo) or losing all formatting
(TransferSpreadsheet). The documentation being what it is, I had to
experiment with the usual snippets of code gleaned from various places,
and I suspect I managed to clobber a setting in the Registry that's now
causing Excel to start up with no active workbook being displayed. Any
ideas on how to undo whatever I did wrong will be greatly appreciated.

--

Dave Peterson

Dave,

Thanks for the reply. Rebooting did indeed fix the problem. It sure
would be interesting to know why it happened in the first place, but
knowing how to fix it is definitely more important!

Jeff