xcaliber13

Excel Macro to AutoIt not working

2 posts in this topic

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?

Share this post


Link to post
Share on other sites



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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now