Hello all,
Here's my scenario. I have an Access app that needs to grab data from
an Excel worksheet. What I've done is create a function in Access
that simply calls excel.run(mypro c(arg1, arg2)).
The excel proc needs to return a bunch of numbers so I pass ByRef. I
can't think of a cleaner way of doing this without updating the db in
excel itself.
My question:
In Access, when I declare my excel object as an object, the byref
works, but if I declare it as Excel.Applicati on then it doesn't work.
Why?
In both tests, I use set xlsApp = new excel.applicati on, the only
difference is in the actualy dim statement.
Am I missing something here, cause I'd really like to bind early, it's
just cleaner.
Thx,
Bodi
Here's my scenario. I have an Access app that needs to grab data from
an Excel worksheet. What I've done is create a function in Access
that simply calls excel.run(mypro c(arg1, arg2)).
The excel proc needs to return a bunch of numbers so I pass ByRef. I
can't think of a cleaner way of doing this without updating the db in
excel itself.
My question:
In Access, when I declare my excel object as an object, the byref
works, but if I declare it as Excel.Applicati on then it doesn't work.
Why?
In both tests, I use set xlsApp = new excel.applicati on, the only
difference is in the actualy dim statement.
Am I missing something here, cause I'd really like to bind early, it's
just cleaner.
Thx,
Bodi