PEP Phoenix Excel Program - Kåre Halvorsen alias Zenta

sswcharlie · February 4, 2015, 6:35am

Hi

I would like to make contact with Mr. Halvorsen, or receive info from this forum.

On this page:

It describes the project for the Phoenix etc.

I would like to do a similar thing but very much more simple. The
program is remarkable in what it does.

In my case I want to use Excel2000 in the same way but to send via
bluetooth to a Arduino processor. For a model railroad project. The
objective in the end is to use a Android phone/tablet to control speed
of a locomotive, using a slider and a couple of buttons for forward and
reverse direction.

At the moment I have not found any android app with Excel and VBA. All
do not have the vba option. Except that is for the PEP

The normal Excel ok for me, it is just the coding that sends a sequenced
set of numbers to the device, which in turn simulates key presses on the model railroad controller.
Google Hornby Zero1 and look at images.

Is there any info available, or astripped down version of the spreadsheet, for the Excel to bluetooth coding for Excel.

Comments would be much appreciated.

CharlesHarris

zenta · February 4, 2015, 9:19pm

Hi,

I’m not sure what you really are asking for here?

It’s been many years since I worked on PEP. As far as I remember I’m using the modCOMM module. PEP simply sends out serial data through the com port of a bluetooth USB adapter on PC. Also used a blue-SMIRF bluetooth adapter connected to the SSC-32.
The only info on the code is the code itself that you can find in the VBA project of the Excel sheet called PEP.