hyperlinks out of a combo box

This is hopfully a simple thing to do. I currently have a list of files as
choices in a combo box. I would like to be able to hyperlink out to the
appropriate file when the file is chosen in the combo box. Using the forms
combo box is a little awkward, and in my primitive way of doing things,
requires helper cells for the index and hyperlink functions. I know next to
nothing of VBA, so any help would be appreciated. I would only require an
example; hopefully, I will be able to modify whatever code is given me to
suit my needs.

wazooli

Why use a hyperlink. why not just have the event code open the workbook
with the standard Workbooks.Open "C:\MyFile.xls"

--
Regards,
Tom Ogilvy

"Wazooli" <[email protected]> wrote in message
news:[email protected]...
> This is hopfully a simple thing to do. I currently have a list of files
as
> choices in a combo box. I would like to be able to hyperlink out to the
> appropriate file when the file is chosen in the combo box. Using the
forms
> combo box is a little awkward, and in my primitive way of doing things,
> requires helper cells for the index and hyperlink functions. I know next
to
> nothing of VBA, so any help would be appreciated. I would only require an
> example; hopefully, I will be able to modify whatever code is given me to
> suit my needs.
>
> wazooli

Thanks for the reply, and good question. Straight up answer: I didn't know
I could use Workbooks.Open "C:\MyFile.xls". Like I said, I know nothing
about VBA. Thanks for the suggestion. The only other question I have is how
do I translate the choice made in the combo box into what you suggested?

Wazooli

"Tom Ogilvy" wrote:

> Why use a hyperlink. why not just have the event code open the workbook
> with the standard Workbooks.Open "C:\MyFile.xls"
>
> --
> Regards,
> Tom Ogilvy
>
> "Wazooli" <[email protected]> wrote in message
> news:[email protected]...
> > This is hopfully a simple thing to do. I currently have a list of files
> as
> > choices in a combo box. I would like to be able to hyperlink out to the
> > appropriate file when the file is chosen in the combo box. Using the
> forms
> > combo box is a little awkward, and in my primitive way of doing things,
> > requires helper cells for the index and hyperlink functions. I know next
> to
> > nothing of VBA, so any help would be appreciated. I would only require an
> > example; hopefully, I will be able to modify whatever code is given me to
> > suit my needs.
> >
> > wazooli
>
>
>

a dropdown box from the forms toolbar

Sub Drpdwn_Click()
sname = Application.Caller
With Activesheet.DropDowns(sName)
sFile = .List(.ListIndex)
End With
if dir("C:\MyFiles\" & sfile) <> "" then
workbooks.Open "C:\MyFiles\" & sFile
else
msgbox "Bad File name"
end if
End Sub

Assign this macro to the dropdown. Assumes the dropdown contains filenames
and all file choices are in a single directory.

--------------

a combobox from the control toolbox toolbar.


Private Sub Combobox1_Click()
if dir ("C:\MyFiles\" & Combobox1.Value) <> "" then
workbooks.Open "C:\Myfiles\" & Combobox1.Value
else
msgbox "File does not exist"
End if
End Sub

It depends on what is in the combobox. I am assuming it has somthing like
MyFile.xls in the dropdown and all files are in the same directory.



http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://j-walk.com/ss/excel/tips/tip84.htm

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp



"Wazooli" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the reply, and good question. Straight up answer: I didn't
know
> I could use Workbooks.Open "C:\MyFile.xls". Like I said, I know nothing
> about VBA. Thanks for the suggestion. The only other question I have is
how
> do I translate the choice made in the combo box into what you suggested?
>
> Wazooli
>
> "Tom Ogilvy" wrote:
>
> > Why use a hyperlink. why not just have the event code open the workbook
> > with the standard Workbooks.Open "C:\MyFile.xls"
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Wazooli" <[email protected]> wrote in message
> > news:[email protected]...
> > > This is hopfully a simple thing to do. I currently have a list of
files
> > as
> > > choices in a combo box. I would like to be able to hyperlink out to
the
> > > appropriate file when the file is chosen in the combo box. Using the
> > forms
> > > combo box is a little awkward, and in my primitive way of doing
things,
> > > requires helper cells for the index and hyperlink functions. I know
next
> > to
> > > nothing of VBA, so any help would be appreciated. I would only
require an
> > > example; hopefully, I will be able to modify whatever code is given me
to
> > > suit my needs.
> > >
> > > wazooli
> >
> >
> >

Wow. Thanks so much for the quick fix (hopefully), as well as the online
resources.

Wazooli

"Tom Ogilvy" wrote:

> a dropdown box from the forms toolbar
>
> Sub Drpdwn_Click()
> sname = Application.Caller
> With Activesheet.DropDowns(sName)
> sFile = .List(.ListIndex)
> End With
> if dir("C:\MyFiles\" & sfile) <> "" then
> workbooks.Open "C:\MyFiles\" & sFile
> else
> msgbox "Bad File name"
> end if
> End Sub
>
> Assign this macro to the dropdown. Assumes the dropdown contains filenames
> and all file choices are in a single directory.
>
> --------------
>
> a combobox from the control toolbox toolbar.
>
>
> Private Sub Combobox1_Click()
> if dir ("C:\MyFiles\" & Combobox1.Value) <> "" then
> workbooks.Open "C:\Myfiles\" & Combobox1.Value
> else
> msgbox "File does not exist"
> End if
> End Sub
>
> It depends on what is in the combobox. I am assuming it has somthing like
> MyFile.xls in the dropdown and all files are in the same directory.
>
>
>
> http://support.microsoft.com/default.aspx?kbid=213749
> XL2000: How to Use a UserForm for Entering Data
>
> http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
> Lesson 11: Creating a Custom Form
> Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
> http://j-walk.com/ss/excel/tips/tip84.htm
>
> http://support.microsoft.com/default...b;en-us;829070
> How to use Visual Basic for Applications examples to control UserForms in
> Microsoft Excel
>
>
> http://support.microsoft.com/?id=168067
> File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
> Controlling UserForms in Microsoft Excel 97
> File Name: WE1163.EXE
> File Size: 161742 bytes
> File Date: 05/08/97
> Keywords: kbfile
> Description: This Application Note is an introduction to manipulating
> UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
> Basic for Applications macros that show you how to take advantage of the
> capabilities of UserForms and use each of the ActiveX controls that are
> available for UserForms
>
> Peter Aiken Articles:
> Part I
> http://msdn.microsoft.com/library/en...FormsPartI.asp
> Part II
> http://msdn.microsoft.com/library/en...ormsPartII.asp
>
>
>
> "Wazooli" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks for the reply, and good question. Straight up answer: I didn't
> know
> > I could use Workbooks.Open "C:\MyFile.xls". Like I said, I know nothing
> > about VBA. Thanks for the suggestion. The only other question I have is
> how
> > do I translate the choice made in the combo box into what you suggested?
> >
> > Wazooli
> >
> > "Tom Ogilvy" wrote:
> >
> > > Why use a hyperlink. why not just have the event code open the workbook
> > > with the standard Workbooks.Open "C:\MyFile.xls"
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Wazooli" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > This is hopfully a simple thing to do. I currently have a list of
> files
> > > as
> > > > choices in a combo box. I would like to be able to hyperlink out to
> the
> > > > appropriate file when the file is chosen in the combo box. Using the
> > > forms
> > > > combo box is a little awkward, and in my primitive way of doing
> things,
> > > > requires helper cells for the index and hyperlink functions. I know
> next
> > > to
> > > > nothing of VBA, so any help would be appreciated. I would only
> require an
> > > > example; hopefully, I will be able to modify whatever code is given me
> to
> > > > suit my needs.
> > > >
> > > > wazooli
> > >
> > >
> > >
>
>
>

and, P.S. - the second snippet of code works fantastically. thanks again.

wazooli

"Tom Ogilvy" wrote:

> a dropdown box from the forms toolbar
>
> Sub Drpdwn_Click()
> sname = Application.Caller
> With Activesheet.DropDowns(sName)
> sFile = .List(.ListIndex)
> End With
> if dir("C:\MyFiles\" & sfile) <> "" then
> workbooks.Open "C:\MyFiles\" & sFile
> else
> msgbox "Bad File name"
> end if
> End Sub
>
> Assign this macro to the dropdown. Assumes the dropdown contains filenames
> and all file choices are in a single directory.
>
> --------------
>
> a combobox from the control toolbox toolbar.
>
>
> Private Sub Combobox1_Click()
> if dir ("C:\MyFiles\" & Combobox1.Value) <> "" then
> workbooks.Open "C:\Myfiles\" & Combobox1.Value
> else
> msgbox "File does not exist"
> End if
> End Sub
>
> It depends on what is in the combobox. I am assuming it has somthing like
> MyFile.xls in the dropdown and all files are in the same directory.
>
>
>
> http://support.microsoft.com/default.aspx?kbid=213749
> XL2000: How to Use a UserForm for Entering Data
>
> http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
> Lesson 11: Creating a Custom Form
> Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
> http://j-walk.com/ss/excel/tips/tip84.htm
>
> http://support.microsoft.com/default...b;en-us;829070
> How to use Visual Basic for Applications examples to control UserForms in
> Microsoft Excel
>
>
> http://support.microsoft.com/?id=168067
> File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
> Controlling UserForms in Microsoft Excel 97
> File Name: WE1163.EXE
> File Size: 161742 bytes
> File Date: 05/08/97
> Keywords: kbfile
> Description: This Application Note is an introduction to manipulating
> UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
> Basic for Applications macros that show you how to take advantage of the
> capabilities of UserForms and use each of the ActiveX controls that are
> available for UserForms
>
> Peter Aiken Articles:
> Part I
> http://msdn.microsoft.com/library/en...FormsPartI.asp
> Part II
> http://msdn.microsoft.com/library/en...ormsPartII.asp
>
>
>
> "Wazooli" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks for the reply, and good question. Straight up answer: I didn't
> know
> > I could use Workbooks.Open "C:\MyFile.xls". Like I said, I know nothing
> > about VBA. Thanks for the suggestion. The only other question I have is
> how
> > do I translate the choice made in the combo box into what you suggested?
> >
> > Wazooli
> >
> > "Tom Ogilvy" wrote:
> >
> > > Why use a hyperlink. why not just have the event code open the workbook
> > > with the standard Workbooks.Open "C:\MyFile.xls"
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Wazooli" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > This is hopfully a simple thing to do. I currently have a list of
> files
> > > as
> > > > choices in a combo box. I would like to be able to hyperlink out to
> the
> > > > appropriate file when the file is chosen in the combo box. Using the
> > > forms
> > > > combo box is a little awkward, and in my primitive way of doing
> things,
> > > > requires helper cells for the index and hyperlink functions. I know
> next
> > > to
> > > > nothing of VBA, so any help would be appreciated. I would only
> require an
> > > > example; hopefully, I will be able to modify whatever code is given me
> to
> > > > suit my needs.
> > > >
> > > > wazooli
> > >
> > >
> > >
>
>
>