Re: Win32::OLE

2011-06-29 Thread John Harrington
-routine-in-access-module-from-net On Wed, Jun 29, 2011 at 10:19 AM, John Harrington bearti...@gmail.com wrote: Hi Leo, Thanks for this. I tried this script on one of the machines that wasn't working yesterday and received only this error: Last OLE32 error: Win32::OLE(0.1709

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