I have an application I'd like to develop and I believe it can be done through Excel. If anyone can help me determine if what I want to do is feasible and point me in the right direction I would appreciate it. I'm not an Excel expert but can make my way around it ok. I'd like to develop this but I know that I just don't know enough about the advanced features of Excel to pull it off myself.
I will create a template spreadsheet. It will be reused each day and will need to be saved at the end of each day. A new filename will be supplied each day. A triggering method will be provided to open it and close it. A new filename will be supplied each day.
I expect this will be a read only file which will be renamed automatically and saved as the assigned filename at the end of each day.
I have a device which will provide me a data string via TCP/IP containing 20 characters of data. I wish to store each string in a single column using sequential rows, one row for each string.
In short this will be a one column spreadsheet which will list each string received in it's own row.
I did search the forum and found that someone recommended a CSV file but I do not believe that I have the ability to do this as I will be connected directly to the device and receiving live data which needs to be logged. This has to be an automatic process and I cannot store to a CSV and then import the data into Excel.
I also have the possibility of having more than 65536 pieces of data arriving in a day. I'm using Excel 2003 and am not sure if that number (rows) has increased in later versions. If that is the max I will need to build in some inteligence to trap at a specific number and start a 2nd column from and fill it in with the data from top to bottom.
If anyone could make some suggestions on how to pull this off I would appreciate it. I'm not looking for someone to do the work but rather point me in the right direction(s). Also, if it isn't feasible in Excel 2003 and a later version would suit my needs better please let me know.
Thanks in advance for your help!
-MachineDr
I will create a template spreadsheet. It will be reused each day and will need to be saved at the end of each day. A new filename will be supplied each day. A triggering method will be provided to open it and close it. A new filename will be supplied each day.
I expect this will be a read only file which will be renamed automatically and saved as the assigned filename at the end of each day.
I have a device which will provide me a data string via TCP/IP containing 20 characters of data. I wish to store each string in a single column using sequential rows, one row for each string.
In short this will be a one column spreadsheet which will list each string received in it's own row.
I did search the forum and found that someone recommended a CSV file but I do not believe that I have the ability to do this as I will be connected directly to the device and receiving live data which needs to be logged. This has to be an automatic process and I cannot store to a CSV and then import the data into Excel.
I also have the possibility of having more than 65536 pieces of data arriving in a day. I'm using Excel 2003 and am not sure if that number (rows) has increased in later versions. If that is the max I will need to build in some inteligence to trap at a specific number and start a 2nd column from and fill it in with the data from top to bottom.
If anyone could make some suggestions on how to pull this off I would appreciate it. I'm not looking for someone to do the work but rather point me in the right direction(s). Also, if it isn't feasible in Excel 2003 and a later version would suit my needs better please let me know.
Thanks in advance for your help!
-MachineDr