View Single Post
  #1  
Old October 23rd, 2009, 09:34 PM posted to microsoft.public.access
Vsn
external usenet poster
 
Posts: 39
Default Access export to Excel and open/show excel sheet

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