ERIC14779
Member
I have a excel 2007 file with a VB Macro that the user will enter some data on what punch and where to start how many and the "pitch" between them.
My VB Macro expands them out, adds in the punch station zero offsets and sorts them by location from zero to the end... as an extra I save a ASCII file that has the first line showing the total number of items, then each position with the punch number apended onto the end of the 3 place decimal as below.
12 <----- Total "hits"
0.0081 <----- last digit at right is Punch # (this one is punch #1)
15.8862
18.8863 <----- Punch # 3
26.7722
37.6582
37.7708
37.7723
48.5442
83.5408
103.8751
129.3108
175.0808
all good so far, but now with Lookout Direct I can not find how to save from Excel 2007 to a Excel 4.0 Worksheet.. The customer may even have a newer version of Excel that I will be putting on the LKD computer for runtime.
Anybody have any ideas on how I convert the Excel file to what LKD can read, or a way to use my .TXT file to get the data into LKD ??
Thanks
My VB Macro expands them out, adds in the punch station zero offsets and sorts them by location from zero to the end... as an extra I save a ASCII file that has the first line showing the total number of items, then each position with the punch number apended onto the end of the 3 place decimal as below.
12 <----- Total "hits"
0.0081 <----- last digit at right is Punch # (this one is punch #1)
15.8862
18.8863 <----- Punch # 3
26.7722
37.6582
37.7708
37.7723
48.5442
83.5408
103.8751
129.3108
175.0808
all good so far, but now with Lookout Direct I can not find how to save from Excel 2007 to a Excel 4.0 Worksheet.. The customer may even have a newer version of Excel that I will be putting on the LKD computer for runtime.
Anybody have any ideas on how I convert the Excel file to what LKD can read, or a way to use my .TXT file to get the data into LKD ??
Thanks