importing excel file to hp prime
|
12-30-2018, 12:08 AM
Post: #12
|
|||
|
|||
RE: importing excel file to hp prime
I am able to get this VB code to work...almost
Sub Copy_Excel_To_HP_Prime_format() Dim rowMax, colMax As Long Const vbDoubleQuote As String = """" 'represents 1 double quote (") Const vbSingleQuote As String = "'" 'represents 1 single quote (') 'Read the row,col of the last UsedRange cell rowMax = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row colMax = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Column 'MsgBox rowMax 'MsgBox colMax For i = 1 To rowMax For j = 1 To colMax 'Debug.Write(index.ToString & " ") texton = "" If TypeName(ActiveSheet.Cells(i, j).Value) = "String" Then texto = ActiveSheet.Cells(i, j).Value texton = vbDoubleQuote & vbDoubleQuote & vbDoubleQuote & texto & vbDoubleQuote & vbDoubleQuote & vbDoubleQuote ActiveSheet.Cells(i, j).Value = texton 'MsgBox ActiveSheet.Cells(i, j).Value End If Next Next End Sub It seems to work fine to get text cells and numbers. BUT...on both The emulator AND on my Prime I cannot put a number in, say, A1 and put a simple formula in, say, B1, that is '=A1' when I enter this (without quotes) in either the emulator OR use the keyboard On the PriMe, I get a syntax error. I see the formulas in the CK, but they do not get to the emulator. If I can determine why I can't enter a formula, I might get it all to work |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 1 Guest(s)