On Wed, 17 May 2000 3:15:7, "Kuhnibert" <[EMAIL PROTECTED]>
wrote:
>good morning,
Moin moin,
>i have a perl program which appends data related to filenames to an
>XL-sheet by using Win32::OLE! currently i'm just filling the field which
>refers to the file location with, well, with the_location_of_the_file.
>within EXCEL i found the possibility to insert an hyperlink pointing to the
>file, which would be really cool for people using the sheet, because they
>would be able to call the file directly by clicking the link instead of
>walking through the explorer. anybody happens to know how i can create
>these XL-hyperlinks from my perlsript? in general, does anybody know a nice
>manual giving an overview about which XL-functions can be used, most of the
>OLE part of my script consists of snippets i found on other pages...
The easiest way to find out how to do this is turning on the Excel macro
recorder and do this once "by hand". Then look at the recorded VBA code
and translate into Perl.
The Excel object model documentation is included on the office CD, but not
installed by default. Run setup again and add it to your installation.
You can also find it (for Excel 2000) at MSDN. I've posted the URL for
the Excel object model in the last couple of days to this very list in
case you cannot find it on the MSDN site.
-Jan
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
