A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access export to Excel and open/show excel sheet



 
 
Thread Tools Display Modes
  #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


  #2  
Old October 23rd, 2009, 09:55 PM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Access export to Excel and open/show excel sheet

"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



  #3  
Old October 24th, 2009, 10:22 AM posted to microsoft.public.access
Vsn
external usenet poster
 
Posts: 39
Default Access export to Excel and open/show excel sheet

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





  #4  
Old October 24th, 2009, 01:02 PM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Access export to Excel and open/show excel sheet

You'll need to use Automation, and use a command along the lines of

appExcel.ActiveWindow.WindowState = xlMaximized

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


"Vsn" vsn_hotmail_kom wrote in message
...
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







  #5  
Old October 25th, 2009, 07:53 AM posted to microsoft.public.access
Vsn
external usenet poster
 
Posts: 39
Default Access export to Excel and open/show excel sheet

Thx, for the input, it did work out for now. Now need to find the time to
implement your code suggestions.

Ludovic
"Douglas J. Steele" schreef in bericht
...
You'll need to use Automation, and use a command along the lines of

appExcel.ActiveWindow.WindowState = xlMaximized

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


"Vsn" vsn_hotmail_kom wrote in message
...
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









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.