Forms - VB

[rakstar]

Hi -

I'm creating a form but i need to open a file upon clicking a button on the form.

How would i do this?

I've created the form...just don't know how i should do the VB for clicking the button and the path of the file.

Thanks

 

[texasalynn]

to open a file here is an example

Workbooks.Open Filename:= _
"S:\Division\nat_acct\REPORTING ANALYSIS\REPORTING TOOLS\District and Division Names and Numbers.xls"

 

[rakstar]

Thanks

 

[texasalynn]

here is an example

Set rngeSend = Application.InputBox("Please select range you wish to send.", _
, Selection.Address, , , , , 8)
If rngeSend Is Nothing Then Exit Sub 'User pressed Cancel

to close a form

Unload UserForm1