![]() But, ultimately, I want the % Complete to be a double. Data in the spreadsheet is always going to be viewed by excel as text based on how it’s exported. TempDictionary.Value(CellValues(actidcol-1)) = CellValues(PcntCompletCol-1)Ī second problem is how to deal with numbers. 'MsgBox(CellValues(actidcol-1)) + Chr(9) + CellValues(PcntCompletCol-1) Lines = Split(c.Text,Chr(13)) //splitting into rows of dataĬellValues = Split(lines(i),Chr(9)) //splitting the row of data into columns copy the whole sheet into the clipboardĮxcel.range(excel.cells(3,ActIDCol),excel.cells(lastrow,PcntCompletCol)).copy ![]() PcntCompletCol = (“Activity % Complete(%)”).column (By the way, I have other methods that open and do some error checking before this method is called.)Į(“TASK”).activateĪctIDCol = (“Activity ID”).Column The problem I’m having is that the Key doesn’t get recorded by Xojo for the second row of data… it’s just null (blank) field, and I cannot figure out why.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |