Douglas,

Thanks for advice, it works.

Would you as well be be able to tel me how I could maximize the child window
(sheet to which I exported the data), it now opens and a child window wich
has a smaller size as the parent window.

I have been looking at your code examples and they look much more
sophisticated and well explaned. I will later replace the code. But for now
it will work with this modified code until i have dealed with some other
outstanding issues in the app.

Cheers,
Ludovic

"Douglas J. Steele" schreef in bericht
...
"Why" is because Danny didn't write the code to do so. g

Easiest way to have the workbook open would be to use the code:

Application.FollowHyperlink sOutput

and the end of the routine.

If that doesn't work, you might check out my July, 2005 "Access Answers"
column in Pinnacle Publication's "Smart Access". You can download the
column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Vsn" vsn_hotmail_kom wrote in message
...
Hi all,

I have used some prety code to export and query or tabel from my access
application to excel file, sheet and finaly cells from

http://www.databasejournal.com/featu...a-To-Excel.htm

All works fine on the exporting side.

Only question i have, i am not able to figure it, why does the excel file
not come 'open/show' to the screen? Moreover when i try to open the file
form its location, it gives a message that the file is already open and
would i like to open it again and loose anychanges to the last open
version. By clikking NO the created file shows to the screen.

Could any one tell me how i could open to the screen directly after it
creates the file. It would be to great help for me.

Thx a lot,
Ludovic