PDA

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.