J
Jean-Philippe
Hello,
I have been scratching my head over this school project for a few days now.
I am not used to access the comm port so I have difficulties to understand
how Windows interacts with it. I have been searching the web but most users
are looking for real time input (e.g. GPS), which is not my case here.
I am successfully using hyperterminal under Win98SE to send and receive the
data via COM1:
1) menu > Transfert > Capture Text > save as test.csv
.... press OK
2) I then type the characters "*D"
.... the data is received...
3) When the dowload is finished I type "*C" to clear the memory of the
device I am communicating with
4) Close Hyperterminal
5) Open the "test.csv" file under Excel 97 to process the data and create
some nice graphs.
Now I am trying to create an Excel form (or Access if it's easier) which is
going to do all that for me.
On open form event:
1) Open communication and setup COM1
On click event:
1) send "*D" to COM1 and start Timer
2) receive the data from COM1
3) when timer is up
4) paste the data on a spreadsheet
5) send "*C" to COM1
On form close event:
1) Close COM1
I would like to know what is the best approach to achieve what I want and do
I really need to install an add-on into Excel 97 since the data received is
already formatted (I think)?
If you have already seen a similar problem could you please direct me to the
link ?
Many thanks in advance.
Jean-Philippe
I have been scratching my head over this school project for a few days now.
I am not used to access the comm port so I have difficulties to understand
how Windows interacts with it. I have been searching the web but most users
are looking for real time input (e.g. GPS), which is not my case here.
I am successfully using hyperterminal under Win98SE to send and receive the
data via COM1:
1) menu > Transfert > Capture Text > save as test.csv
.... press OK
2) I then type the characters "*D"
.... the data is received...
3) When the dowload is finished I type "*C" to clear the memory of the
device I am communicating with
4) Close Hyperterminal
5) Open the "test.csv" file under Excel 97 to process the data and create
some nice graphs.
Now I am trying to create an Excel form (or Access if it's easier) which is
going to do all that for me.
On open form event:
1) Open communication and setup COM1
On click event:
1) send "*D" to COM1 and start Timer
2) receive the data from COM1
3) when timer is up
4) paste the data on a spreadsheet
5) send "*C" to COM1
On form close event:
1) Close COM1
I would like to know what is the best approach to achieve what I want and do
I really need to install an add-on into Excel 97 since the data received is
already formatted (I think)?
If you have already seen a similar problem could you please direct me to the
link ?
Many thanks in advance.
Jean-Philippe