Anyone familiar with BPCS?
 

Hi. Has anyone here ever written a VBA routine in Excel to call to BPCS
to run a report? Could you share some sample code of the objects and
such used? Or could someone point me to a resource where I could
research this?

Thanks,
Chuck

Anyone familiar with BPCS?
 

Could you please advise the vendor?

--
Rob van Gelder - http://www.vangelder.co.nz/


"c mateland" wrote in message
oups.com...
Hi. Has anyone here ever written a VBA routine in Excel to call to BPCS
to run a report? Could you share some sample code of the objects and
such used? Or could someone point me to a resource where I could
research this?

Thanks,
Chuck

Anyone familiar with BPCS?
 

They're using Reflections 4.

Sorry to have left that out.

-Chuck

Anyone familiar with BPCS?
 

Hi,

I have an xla file at work that I can post tomorrow - it -may -come in
handy for you (I'm not sure if the VBA project is locked or not). I
have only used it twice & believe that was created quite some time ago
but it's tidy & has error traps etc.
The difficulty I have with using it is the need to be able to identify
the library & table etc that the data is to be pulled from.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=509025

Anyone familiar with BPCS?
 

Thanks, Rob. I'd love to look at it.

I'm not sure posting files here is allowed, but feel free to send it to
my email address. Just add @yahoo.com after my name. My name is
chuckmateland.

Thanks,
Chuck

Anyone familiar with BPCS?
 

Hi Chuck,
Sorry, I kept forgetting to post it & I was mistaken, it is not an xla
file it is an ".xll" file (another type of addin - I think). Also, I
can't see any way of breaking in to it to see how it works - good
luck!
It is installed through tools & addins and when you want to use it look
for the 2 options under the Data menu ("transfer data from as400" &
transfer data to as400").

I can post it through www.excelforum.com so hopefully you can download
it. If not try getting it from this thread:
http://www.excelforum.com/showthread.php?t=509025

another thread you may find more helpful is:
http://www.excelforum.com/showthread.php?t=495690

hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


+-------------------------------------------------------------------+
|Filename: Copy of cwbtfxla.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4337 |
+-------------------------------------------------------------------+

--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=509025