Hi,
I have an output file from a device which is appended to each time the device is used. I then need to add some additional data to output in a separate excel sheet via some control buttons. My plan is to import the last line from the output csv in to a results sheet then add some qualifiying data via some control buttons. The bit that I cant seen to find any help on is the initial import. The device output file would be c:\temp\output.csv and the copy location would be the next empty row in the results sheet in the current workbook. Ideally this would be done in the background so not to confuse the end users! Can anyone point me in the right direction for this?
Many thanks
I have an output file from a device which is appended to each time the device is used. I then need to add some additional data to output in a separate excel sheet via some control buttons. My plan is to import the last line from the output csv in to a results sheet then add some qualifiying data via some control buttons. The bit that I cant seen to find any help on is the initial import. The device output file would be c:\temp\output.csv and the copy location would be the next empty row in the results sheet in the current workbook. Ideally this would be done in the background so not to confuse the end users! Can anyone point me in the right direction for this?
Many thanks
