Jump to content

Taurillon

Members
  • Posts

    8
  • Joined

  • Last visited

Taurillon's Achievements

Seeker

Seeker (1/7)

1

Reputation

  1. Code works perfectly the listobjects.add method calls for an range object. Is .Range(... ) a valid range object or is only $oExcel.activeSheet.Range(...) a valid range object in autoit? Taurillon
  2. Thanks a lot. I am having real trouble taking information about the Objects and Methods and using it in autoit. I can use the VBA code just fine but i dont know how to put it in autoit Do you know of any rescources that can bridge that gap ? I am learning from the autoit help file just fine. I am trying to find the missing pieces that allow me to learn what Excel Com has to offer on my own. @water I am getting: error And error: Taurillon
  3. This was very helpfull thanks a lot Taurillon
  4. you are right changing the encoding to UTF-8 removed the behavior too. The file is not making any real issues apart from me having to delete the unicode char every time i open the file. I just this is weird behavior that i cant expain, maybe someone else can. Taurillon
  5. thats for the link. I was hoping you could provice more information about the excel com. I am still unsure about how to format a range with a "table style". I am referring to this bit ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$64:$F$68"), , xlYes).Name = _ "Tabelle3" Range("Tabelle3[#All]").Select ActiveSheet.ListObjects("Tabelle3").TableStyle = "TableStyleMedium4" thanks for your help taurillon
  6. I have an Autoit file that generates a unicode character everytime i open the source code as the first symbol. I have no idea how it is possible, no other file does this. I can create muliple symbols by just saving the file with a generated symbol. Saving the file after deleting the symbol doesn´t fix the behaviour. I can copy the Source code and paste it into a diffrent Autoit file and its gone. When i use the save as function the symbols stay with the file. The symbol is constandly switching after closing and opening, this is not the case if the editior window stays open because of another source code in this case the symbol is static. Is this a possible bug in the Editor ? I Added the Autoitfile itself and 2 Screenshots. Unlikly that you will be able to experice the behaviour of this unique file but the least we can do is try. I am using the SciTE Version 3.6.6 and Autoit version 3.3.14 Best wishes Taurillon what1.au3
  7. I just noticed that i posted in the wrong forum i think this belongs into general help. Is there a way to delete my post or move it over to general help ? best wishes Taurillon
  8. Hello Autoiforum Users, i just search trough the autoit help file but i couldnt find a way to format cells. I started playing around with Autoit just recently. In the wiki file about the Excel UDF is a remark about using the excel Com on its own. Right now i am not sure how to do that. I would be happy about every bit of information regarding how to use the excel Com and how it works/ how to use it in autoit. I cant find a good site/link when searching for Excel Com Regarding my specific case, i am having trouble changing the "format" of cells. I added a picture to make it more clear what i am trying to say. In another post it seemed like an Excel macro documents the changes well for others. Sub Makro1() ' ' Makro1 Makro ' ' Range("B63:F63").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Selection.Merge Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Color = -16776961 .TintAndShade = 0 .Weight = xlMedium End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Color = -16776961 .TintAndShade = 0 .Weight = xlMedium End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Color = -16776961 .TintAndShade = 0 .Weight = xlMedium End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Color = -16776961 .TintAndShade = 0 .Weight = xlMedium End With Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone Range("B64:F68").Select ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$64:$F$68"), , xlYes).Name = _ "Tabelle3" Range("Tabelle3[#All]").Select ActiveSheet.ListObjects("Tabelle3").TableStyle = "TableStyleMedium4" End Sub This is the macro i created. I merged cells, gave them a border and chose a range under that to turn into a table with a predetermined template. Thanks a lot for your help. best wishes Taurillon
×
×
  • Create New...