Menu

VB Script in Ecell

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Bob Phillips

Posts: n/a

Default

"Dennis Evans" <Dennis wrote in message
...
Hi

I have 2 basic questions

1. I have an Excel file with a Form I created in VB. How do I get this
from
to load automatically when the Speadsheet is open.

Private Sub Workbook_Open()
Userform1.Show
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

2. A VBscript that will open the above Form in Excel and bring it to the
forground from a 3rd part application

You need automation for this. Something along the lines of

Dim xlWb As Object
Dim sFile As String

sFile = "C:\Documents And Settings\Bob\Desktop\Area Codes.xls"
Set xlWb = GetObject(sFile)
'do more stuff
xlWb.Close
Set xlWb = Nothing

which assumes that Excel is already running, and that you have the previous
userform display code in that workbook.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB Script error	Anthony	Excel Discussion (Misc queries)	2	July 13th 05 03:09 PM
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem.	PriceTrim	Excel Discussion (Misc queries)	3	July 5th 05 05:27 PM
VBA script help..Please !!!!	Anthony	Excel Discussion (Misc queries)	6	June 6th 05 01:40 PM
Using a VB Script for barcodes - new to this	Jon	Excel Discussion (Misc queries)	2	May 13th 05 02:42 PM
Macro script error - pls help !!	Anthony	Excel Discussion (Misc queries)	3	February 28th 05 01:49 PM

All times are GMT +1. The time now is 11:14 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement