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