The code to open the selected file becomes
Workbooks.open FileName:=cboSelectedFile.List(,1) & cboSelectedFile.List(,0)
(You might have got confused because I had earlier used cboSelectedFile as
the name of the combobox and later used the name ComboBox1. Sorry for that.)
So you put this piece of code whereever you want to open the file. If you
want to open the file when a user clicks on a button then you put this in the
button's click event. Yoou could also put this code in the combobox's click
event. If you do this then everytime a user click and selects an entry from
the Combobox the corresponding file will open. Hence it all depends on the
design of your application.
Alok
"RSHF" wrote:
> Alok,
> I understand the first part of your instructions but, where do I input
> ComboBox1.List(,1) & ComboBox1.List(,0)
>
> Where does that go in relation to this, Workbooks.open
> FileName:=cboSelectedFile, in the button's click event?
>
> As you can tell, I am still an amateuer!!
>
> "Alok" wrote:
>
> > Yes if you want the file locations(paths or folders) to be hidden from the
> > user you can do that by having the next column list them. When setting the
> > ListFillRange of the combo box you will include this column. Set the number
> > of columns property of the combo box to 2 and set the width of the second
> > column to 0 so that it does not show up. (;0 pt)
> > Then you can create the full file name by
> > ComboBox1.List(,1) & ComboBox1.List(,0)
> > this assumes that the path name includes the "\" at the end.
> >
> >
> > "RSHF" wrote:
> >
> > > Ok, I presume the first step I need to take would be to link the real file
> > > version, to the corresponding entry on the drop down box then. In other
> > > words, on my current sheet the drop down box just lists the names of the
> > > files. I have the files listed as an array which only displays their names.
> > > How do I attach their file loccation without having that shown in the drop
> > > down menu, so that users can scroll through the drop down and select the file
> > > they choose and then use the command button to open that file?
> > >
> > >
> > > "Alok" wrote:
> > >
> > > > If the combo box is called cboSelectedFile then
> > > > add the following code in the button's click event
> > > >
> > > > Workbooks.open FileName:=cboSelectedFile
> > > >
> > > >
> > > > "RSHF" wrote:
> > > >
> > > > > I have a combo box on a master sheet that lists an alphabetical menu of files
> > > > > for users to open. How do I attach hyperlinks to these files in the dropdown
> > > > > menu, so that users may scroll through the menu pick the file they want and
> > > > > then press a command button to open up the chosen file from the master sheet.
> > > > > The drop down menu also functions as a link to a seperate database so I may
> > > > > have to combine the code. Any suggestions?
|
Similar Threads
