View Full Version : Auto open procedure via vbscript
circaa
06-27-2006, 08:09 AM
I know how to open an excel file with vbscript(notepad saved as .vbs). My excel file contains forms and an auto open macro. When the .vbs is clicked, I want the excel application to be hidden but the macro to run and show the form.
Any ideas ?
Joey
Bob Phillips
06-27-2006, 08:17 AM
Auto_Open will not run, but the Workbook_Open event does. Move your code to that
Private Sub Workbook_Open()
'your code
End Sub
This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code
circaa
06-27-2006, 08:49 AM
Thanks a lot
another issue
When a button is clicked on my form, I want excel to become visible again to show the sheet. How do i dot that ?
Joey
Bob Phillips
06-27-2006, 08:50 AM
How does it get non-visible? Just reverse that.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.