Jump to content

Search the Community

Showing results for tags 'vba'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements and Site News
    • Administration
  • AutoIt v3
    • AutoIt Help and Support
    • AutoIt Technical Discussion
    • AutoIt Example Scripts
  • Scripting and Development
    • Developer General Discussion
    • Language Specific Discussion
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Categories

  • AutoIt Team
    • Beta
    • MVP
  • AutoIt
    • Automation
    • Databases and web connections
    • Data compression
    • Encryption and hash
    • Games
    • GUI Additions
    • Hardware
    • Information gathering
    • Internet protocol suite
    • Maths
    • Media
    • PDF
    • Security
    • Social Media and other Website API
    • Windows
  • Scripting and Development
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Location


WWW


Interests

Found 14 results

  1. Excel VBA's IDE registers a Control-y as "cut this line of code". For those prone to Undo/Redo (Ctrl+Z/Ctrl+Y) you may find frustration when your code in the editor does not redo, but in fact clears your active line of code while killing redo history. Though not perfect, I keep this tool running in background on startup. The purpose is to allow Cltr+Y to act normally throughout Windows and Office and only interact *differently* with the "Microsoft Visual Basic for Applications" window that is active. If the Standard Menu bar exists, it'll try to click the ReDo (Blue Arrow t
  2. Good morning Forums In these days, I am working on a project that involved me to use some Windows APIs to obtain some information about Terminal Servers. I'm doing this using wtsapi32.dll in a VBA Project, but, the lack of knowledge about few things threated in the articles make this quite difficult to implement and understand at the same time. The most difficult thing I'm facing is "translating" C/C++ functions or struct in VBA when pointers are used, or pointers of pointers, and so on. Since VBA seems to not have a pointer type, to make those functions work I need to implement oth
  3. Hi all, I'm trying to write a script that connects with a VBA/COM API to get the status of a connected phone. I've been looking up and down this forum for tips or other user's experiences, but I can't seem to find anything (even remotely) similar. It shouldn't be so hard to do, however. Software I'm trying to connect to I'm trying to integrate CallCenter by using their API, which is documented over here : JustRemotePhone API Reference Things I've tried I've tried using ObjCreate but I don't get any result, it always returns the same (negative) error. #Version 1 tr
  4. How do I properly convert this to Autoit? This is a VBA macro that I recorded in Excel.  ActiveSheet.Outline.ShowLevels RowLevels:=2 I need this to close my subtotal once it is finished. any help will be greatly appreciated.
  5. I am using Autoit to automate another software. I am looking to create a piece of code which can select the option from a combo box. I know what option I want to select and I have stored it in a string but nothing seems to be working for me. I am able to click on the Control by using this code. ControlClick("Import/Export Table Name", "","[NAME:cmbTableName]"); This is what I was thinking but doesn't work for me. ControlCommand("Import/Export Table Name", "", "[NAME:cmbTableName]", "SelectString", $MyOpt
  6. Hi, I am trying to use ControlMove function AU3 DLL in VBA. The function instead of moving the control just makes it disappear. It only appears when I resize notepad manually. Can anybody please help me and let me know whats the miss here Here's the code I am working on: Private Declare PtrSafe Function AU3_ControlMove Lib "C:\Program Files\AutoIt3\AutoItX\AutoItX3.dll" (ByVal szTitle As LongPtr, ByVal szText As LongPtr, ByVal szControl As LongPtr, ByVal nX As Integer, ByVal nY As Integer, nWidth As Integer, nHeight As Integer) As Long Private Function ControlM
  7. Hi, I want to send text into a VBA form's text field. Can someone please guide me on the autoit script that can help me. Below is the sample code that I need help on: #include <Excel.au3> #include <FileConstants.au3> #include <MsgBoxConstants.au3> @ScriptDir ="D:\\AutoIT\" $sFilePath = @ScriptDir & "\ExcelForm.xlsm" Local $oAppl = _Excel_Open() ;Local $oAppl = _Excel_Open(False, Default, Default, Default, True) Local $sWorkbook = $sFilePath Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook) ConsoleWrite('before o
  8. Hi, Can someone help me with how to translate this correctly? I've been working on it for a few hours and I just can't quite get it right. Columns("G:G").Select Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""Purchase""" Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font .Color = -16383844 .TintAndShade = 0 End With With Selection.FormatConditions(1).Interior .PatternColorIndex = xlAutomatic .Color = 13551615 .
  9. I'm trying to create a simple outlook function that validates the email addresses before sending. I'm trying adapt this script: https://msdn.microsoft.com/EN-US/library/office/ff867165.aspx Func SendEmails() $olApp = ObjCreate("Outlook.Application") $olMailItem = 0 $objMail = $olApp.CreateItem($olMailItem) With $objMail .Save .Subject = ("TEST") .Display $oRecipients=.Recipients EndWith With $oRecipients .Add("User1") .Add("User2") If not .ResolveAll Then For $z In $oRecipients If not .Resolved then MsgBox(0,&q
  10. I am restating a topic that was not solved from >here (I am not sure what are the rules of restarting a already discussed topic) I am using the following code in VBA to run Autoitcode.au3 file.
  11. I am using the following code in VBA to run Autoitcode.au3 file. Sub RunFileName() Dim runscript Dim FileName As String FileName = ThisWorkbook.Path & "\Autoitcode.au3" MsgBox (FileName) runscript = Shell("C:\Program Files (x86)\AutoIt3\AutoIt3_x64.exe " & FileName) End Sub The Autoit code I want to run, works fine when I directly run by double clicking the file in folder, but when I use this VBA code it gives me error of Autoit Line 0 Error ("File: E:\Data\Point") Error : Error Opening the file Actually this line should be reading this path: E:\Data\Point Data\Folder\Folder\My
  12. I have done extensive programming in vb vba and autoit. Currently, I have a fairly complex application using word, autoit compiled exe's and vba. Various functions in my application shell to dos and run various autoit scripts that have been compiled into 'exe's. Calling a function in the autoitx dll has to be faster and cleaner. I have been just told in the autoit forum about autoitx. If I could just see sample code for autoitx and how to call it from vba I think I can run with it and figure out everything I need to do. Let's say I want autoitx to get the name of a window to activate
  13. This is what is needed to use AutoItX3 Dll in Word VBA 1. Check the checkbox in references for Autoit type Lib 2. Diminsion a variable to use as the parent for all AutoIt functions. EG: Dim AutoIt As New AutoItX3Lib.AutoItX3 3. Type the parent name followed by a dot. You will right away see a drop down list of Autoit functions. 4. Select the function needed. The syntax is different in VBA for word. EG: In the Scite editor you would use the WinActivate like so: WinActivate("My Window", "Text in the window") In VBA for Word (and all other office products probably) you us
  14. I am developing some excel export code. A small part is outputting some constants not in the excel UDF. I can find the constant using VBA editor from Excel. But my question is basically (since it did not work in AutoIT): In terms of VBA code, which object type is $oExcel in this code: Local $oExcel = _ExcelBookOpen(@ScriptDir & "\" & "tstfile.xlsx", 1) I tried to do this: ; VBA CODE which works Sub s() MsgBox Application.ThisWorkbook.FullName End Sub personally I think $oExcel is an application object, so this should work: ConsoleWrite("From Excel file : " & $oEx
×
×
  • Create New...