Excel Macro to AutoIt not working

[xcaliber13]

I have an Excel Maco that works in Excel:

Dim oRng As Range
    Set oRng = Selection
    Selection.Font.Bold = True
    Selection.SpecialCells(xlCellTypeBlanks).Select
    Selection.Font.Bold = False
    Selection.FormulaR1C1 = "=R[-1]C"
    oRng.Copy
    oRng.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
       SkipBlanks:=False, Transpose:=False

I have tried to convert to AutoIt but it is not working????

#include <Excel.au3>
#include <ExcelConstants.au3>
Local $oExcel = ObjCreate("Excel.Application")
Const $sType = $xlCSVMSDOS
;Const $xlToRight = -4161
;Const $xlValues = -4163
;Const $xlNone = -4142
Global $oExcel = _Excel_Open()
Global $sTextFile = "Path to File\temp.csv"
Global $oWorkBook = _Excel_BookOpenText($oExcel, $sTextFile, Default, $xlFixedWidth)
$oWorkbook.Range = .Selection
$oWorkbook.Selection.SpeciallCells(xlCellTypeBlanks).Select
$oWorkbook.Selection.FormulaR1C1 = "=R[-1]C"
$oWorkbook.Copy
$oWorkbook.Selection.PasteSpecial($xlvalue,Default,Default,Default)

Can anyone tell me what I have missed?

[water]

Remove

#include <ExcelConstants.au3>

It's not needed.

Remove

Local $oExcel = ObjCreate("Excel.Application")

It's done by _Excel_Open.

I'm not sure this solves all problems, but I can't test as I have no access to a computer right now.