Thanks for the response.
Does this mean that I would not use perl and only program in
VBA?
If I do need perl does it have to be installed on the Windows side?
Where can I get some examples with ODBC in VBA?
thanks.
Mike Hillyer <mikeh@stripped> wrote:
Annie Law wrote:
> Hi,I would appreciate help with the following. I would like to be ableto initiate a
> perl script that is residing on a linux server from anExcel workbook. I am working on the
> Excel workbook in Windows. Iwould appreciate any pointers, sample code for accomplishing
> this inVBA or some other method.The perl script that I am trying to call will take the
> informationfrom a mysql database and update the Excel sheet.The script will also take
> information from the Excel sheet and updatethe database.thanks very much.
>
>
>
>
> ---------------------------------
> Post your free ad now! Yahoo! Canada Personals
>
Why wouldn't you just use ODBC to connect to the server and work
directly? Remotely initiating a perl script would involve creating a
telnet or SSH session from within Excel using VBA, which would be a far
more complex undertaking.
--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
"The Open Source movement has become a major force across the software
industry, and MySQL is the world's most popular open source database."
--Fortune Magazine
begin:vcard
fn:Mike Hillyer
n:Hillyer;Mike
org:MySQL AB;Documentation Team
adr:;;;;;;Canada
email;internet:mhillyer@stripped
title:Technical Writer
tel;work:+1 403 686 0000
tel;home:+1 403 380 6535
tel;cell:+1 403 894 6535
x-mozilla-html:FALSE
url:http://www.mysql.com
version:2.1
end:vcard
---------------------------------
Post your free ad now! Yahoo! Canada Personals
