Lengthen "Insert Hyperlink dialog box"

[Grandma's Trying]

How do I Lengthen "Insert Hyperlink dialog box" so my list of choices in the
file is longer. I am linking data in an Excel sheet with 650 pictures in one
folder, but the dialog box only shows about 10 files on the list. To reach
the other 640 pictures I would have to "click" forever. I have been
"clicking" up to twenty pictures, then transferring the pictures to a
temporary file, then going on the next set. The dialog box does not have the
"pull down/expand feature" that I can find. Can someone out there help me?
Thanks
Va

 

[alborg]

Hi Grandma:

I'm not familiar with the "dialog box" that you are talking about. Can you
upload a version of your program, or at least a jpg of what you are trying to
do?

Are the pics actually on the spreadsheet or does the Excel sheet have a list
of hyperlinks?

With Word VBA, you can do several methods of bringing up a UserForm with
hyperlinks:

1) Have the UserForm gather up all the jpgs, bmps, pngs etc from a single
Windows folder and list them in hyperlink format so that a doubleclick will
show the pic.
2) Use the Windows API to bring up a Window Explorer like popup to show the
various files in a Windows folder.
3) Directly link to your Excel file and list the files (URLs in this case)
inside a ListBox which resides in a Word UserForm.

If you can pinpoint what exactly you wish to do, we could help you out more.

Sincerely,
Al

 

[Graham Mayor]

The short answer is that you can't lengthen the Hyperlink dialog. You can
however click the 'browse for file' button on that dialog, which will give
you a full screen view of the File dialog if you require it.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[alborg]

Hi grandma:

Graham's right... gosh, I didn't realize that you were asking about the
basic hyperlink dialog box.

What I meant by #1 is that if your files all reside inside a Window's
folder, you can get the functionality of the "hyperlink dialog box" with vba
with a bit of neat code. In fact, you can search your whole C: drive if you
wish, for a certain group of files, but it would take a long time.

It's just slightly easier done in MS Access, but in MS Word you simply
change the code a bit. Here's the functionality how it would look like in MS
Access and MS Word (picture)-
http://i38.photobucket.com/albums/e103/alborgmd/Software/page-search.png.

In both instances, All the URLs are stored inside a MS Access table that has
a hyperlink field. In Access you just click on any item in the field; in Word
you have to manually link to this table, then you have to do a shell routine
to see the selected file. Now, instead of doing the shell routine, you can
write vba code to capture then place the URL onto your document (either in
Excel or in a Word table), and if you keep your UserForm visible, in theory,
you can rapidfire entry all the URLs onto your spreadsheet easily. Now, I've
yet to attempt that, so it's all theory, but I'm pretty sure it should work
fine.

In writing this I just realized, BTW, that it probably could be done in
Word/Excel without using an Access table at all, just add the items into a
Listbox... (I degress).

If you wish to see the MS Access hyperlink form, go to
http://msofficeemrproject.com/Page2.htm, and click on the appropriate
download link. It's a small Access MDB file. If you wish to see how it works
in MS Word, you need to download one of the three WordEMRProjects (MS Word
2000, 2002, or 2003 versions-> all are free). I use the method twice- once to
look for patient handouts, and another time to look for patient workups.

If you want to dive into the code here, I can continue, but I don't want to
lose you, nor do I want to go into the exercise if it is of no interest. I
may actually finish the chapter on that very topic in the next 48 hours if I
can find the time (see http://msofficeemrproject.com/Page6.htm, chapter 13).

Cheers,
Al