Re: Win32::OLE

2011-06-29 Thread John Harrington
AM, Leo Susanto wrote: > Try this: > http://stackoverflow.com/questions/837754/call-routine-in-access-module-from-net > > On Wed, Jun 29, 2011 at 10:19 AM, John Harrington > wrote: > > Hi Leo, > > Thanks for this. > > I tried this script on one of the machines

Win32::OLE

2011-06-28 Thread John Harrington
I have a very simple script using Win32::OLE that works perfectly on my machine but not on other people's machines and I can't figure out why. The script is as follows: use strict; use warnings; use Win32::OLE; my $oAccess; $oAccess = Win32::OLE->new('Access.Application') or die "Unable to start

Question about calling my own Access VBA function using Win32::OLE

2011-06-09 Thread John Harrington
This question has to do with automating Access. I simply want to run my own function in Access and pass it parameters. Let's say I have written a public function called foo() in a module in my Access database. Foo() takes a couple of arguments, param1 and param2, the first a string, the second a