Creating Excel file from VBasic was >
Archiver
Posts: 46,084
Michael,
I can't get that link to work. Are you sure it's valid?
Thanks!!
/Henrik Olsson.
Original Message
From: "Witherspoon, Michael J" <michael.j.witherspoon@i...>
To: <basicstamps@yahoogroups.com>
Sent: Monday, January 21, 2002 6:20 PM
Subject: [noparse][[/noparse]basicstamps] Creating Excel file from VBasic was > "Logging Data
from a Temperature Sensor"
> Here is a great place to start if you want to create an Excel file from
data
> collected from your stamp (or any other).
>
> This guy has a class module that does all the excel stuff for you, no
DLL's
> or Excel required on the PC. All that's left is for someone to create the
> stamp interface to collect the data.
>
> I'd work on it but I'm already under the gun on a paying client's
project...
>
> (you'll have to piece this URL back together as the emailer will break it
> up)
>
>
http://www.planetsourcecode.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/script
> s/ShowCode.htm
I can't get that link to work. Are you sure it's valid?
Thanks!!
/Henrik Olsson.
Original Message
From: "Witherspoon, Michael J" <michael.j.witherspoon@i...>
To: <basicstamps@yahoogroups.com>
Sent: Monday, January 21, 2002 6:20 PM
Subject: [noparse][[/noparse]basicstamps] Creating Excel file from VBasic was > "Logging Data
from a Temperature Sensor"
> Here is a great place to start if you want to create an Excel file from
data
> collected from your stamp (or any other).
>
> This guy has a class module that does all the excel stuff for you, no
DLL's
> or Excel required on the PC. All that's left is for someone to create the
> stamp interface to collect the data.
>
> I'd work on it but I'm already under the gun on a paying client's
project...
>
> (you'll have to piece this URL back together as the emailer will break it
> up)
>
>
http://www.planetsourcecode.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/script
> s/ShowCode.htm
Comments
is limited to 80 character wide strings. So any strings longer than 80
char's get wrapped to the next line.
See this is from the email sent by yahoo...
>
http://www.planetsourcecode.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/script
> s/ShowCode.htm
Notice part of the URL has been wrapped to the next line, "s/ShowCode.htm".
If that still does not work here is the long route.
Click this to get to the site
http://www.planetsourcecode.com
At the top of the page there are "Quick Search" inputs.
In the "Quick Search For" box enter "Excel Class - write to an XLS file"
In the "Language" selection list select "Visual Basic"
Click the "Quick Search" button.
This should get a results list with only this artical. Click on the link
and you'll get more details and information on the code as well as a
"Download Code" link
Hope this helps...
Mike
Original Message
From: Henrik Olsson [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=7Sx5lskMS5JTBNbr3VG4uArcprAYlDu-hkQ7Ira5u-gALs1YVIik2mupOGl04YSeOBvqPa0CPU48IS6TPEfbnvEa]henrik-olsson@t...[/url
Sent: Monday, January 21, 2002 1:26 PM
To: basicstamps@yahoogroups.com
Subject: Re: [noparse][[/noparse]basicstamps] Creating Excel file from VBasic was >
"Logging Data from a Temperature Sensor"
Michael,
I can't get that link to work. Are you sure it's valid?
Thanks!!
/Henrik Olsson.
Original Message
From: "Witherspoon, Michael J" <michael.j.witherspoon@i...>
To: <basicstamps@yahoogroups.com>
Sent: Monday, January 21, 2002 6:20 PM
Subject: [noparse][[/noparse]basicstamps] Creating Excel file from VBasic was > "Logging Data
from a Temperature Sensor"
> Here is a great place to start if you want to create an Excel file from
data
> collected from your stamp (or any other).
>
> This guy has a class module that does all the excel stuff for you, no
DLL's
> or Excel required on the PC. All that's left is for someone to create the
> stamp interface to collect the data.
>
> I'd work on it but I'm already under the gun on a paying client's
project...
>
> (you'll have to piece this URL back together as the emailer will break it
> up)
>
>
http://www.planetsourcecode.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/script
> s/ShowCode.htm
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject and
Body of the message will be ignored.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
either.
Original Message
From: Witherspoon, Michael J [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=ctIaW4vXLBAYGxmhg8jADPxPk4jMLbG1FyNPunbubFuAAtv4k-q2QPXb9xIzbaYwnhrpWGhINhYJezXuAJI2PUNLySlC5A]michael.j.witherspoon@i...[/url
Sent: Monday, January 21, 2002 11:20 AM
To: 'basicstamps@yahoogroups.com'
Subject: [noparse][[/noparse]basicstamps] Creating Excel file from VBasic was > "Logging
Data from a Temperature Sensor"
Here is a great place to start if you want to create an Excel file from data
collected from your stamp (or any other).
This guy has a class module that does all the excel stuff for you, no DLL's
or Excel required on the PC. All that's left is for someone to create the
stamp interface to collect the data.
I'd work on it but I'm already under the gun on a paying client's project...
(you'll have to piece this URL back together as the emailer will break it
up)
http://www.planetsourcecode.com/xq/ASP/txtCodeId.11898/lngWId.1/qx/vb/script
s/ShowCode.htm
To UNSUBSCRIBE, just send mail to:
basicstamps-unsubscribe@yahoogroups.com
from the same email address that you subscribed. Text in the Subject and
Body of the message will be ignored.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> from data collected from your stamp (or any other).
You can also just write a "csv" file and read that into excel:
iCsvFile As Integer, sData as string
iCsvFile = FreeFile
Open "LaserMonitor.csv" For Output As #iCsvFile
'
' this writes the headings on your excel spreadsheet
'
Write #iCsvFile, "date", "data" ' write adds quotes and commas
'
' this writes your data to your excel spreadsheet
'
Write #iCsvFile,, Format(Now, "dddd, mmm d yyyy hh[noparse]:mm:[/noparse]ss"), sData
Close #iCsvFile
Jay