importing excel file to hp prime

[Ninetrees]

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