Send text to VBA form

[RamPalav]

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 opening macro.........1')
$oAppl.Run('mymacro')

Sleep(3000)
ConsoleWrite('After opening macro.........1')

Send('First text')
ConsoleWrite('After opening macro.........2')
Send('{TAB}')
ConsoleWrite('After opening macro.........3')
Send('Second text')
ConsoleWrite('After opening macro.........4')
Send('{TAB}')
Send('{Enter}')
ConsoleWrite('After opening macro.........5')

thanks,

 

Edited May 17, 2016 by Melba23
Added code tags

[Melba23]

RamPalav,

Please pay attention to where you post - the "Developer General Discussion" section where you started this thread is not for general support questions.  I have moved it for you, but would ask you to be more careful in future.

And when you post code please use Code tags - see here how to do it.  Then you get a scrolling box and syntax colouring as you can see above now I have added the tags.

M23

 

 

[junkew]

https://www.autoitscript.com/wiki/FAQ number 31 will help you

[RamPalav]

Hi junkew,

 

I refered number 31,

but here my macro is not processing further. So after running macro, it openup macro, but didnot move ahead with send/sendcontrol or tabs.

do i have to do any settings in excel macro?

[orbs]

@RamPalav,

On 5/17/2016 at 7:20 PM, RamPalav said:

@ScriptDir ="D:\\AutoIT\"

 

first, you do not assign a value to an internal AutoIt macro. it is populated automatically. remove that line.

now, what you do is this: read the tutorial "Simple Notepad Automation" (in the help file, AutoIt \ Tutorials). this tutorial explains:

1) how to wait for the form to appear, instead of using Sleep().

2) how to use the AutoIt Windows Info tool to analyze the VBA form and find the controls you need to manipulate.

once you know what the controls are called, you can substitute you Send() calls with ControlSend(), which eliminate the need for tabbing and in general makes your script more robust.

 

now for a different aspect. VBA is used to automate Excel, and you wish to use AutoIt to automate the VBA. are you seeing something odd here? how about a change of approach - make your VBA code, before calling the form, get the text to fill (from wherever AutoIt takes it) and populate the form - and perhaps you can skip the form step altogether.

[junkew]

Or use not autoit and do it fully in vba. 

[junkew]

Or use not autoit and do it fully in vba. 

[RamPalav]

The VBA files (Containing series of multiple forms) which i  get is protected and not able to edit those. So I need to send the data to it along with button click to get the result and end of last form.

The issue was I was able to run macro but it was not able to pass the data to text boxes, combo box, buttons etc.

I found a work way around creating a new exe through C# and calling them through AutoIT. May be it is not the correct way!!

Thanks for your support!

 

 

[junkew]

Even if you have a protected VBA / XLS you can open a 2nd xls with VBA writing to the VBA forms. This is allways easier then messing with external exe's.

[RamPalav]

Finally,

do not call the macro, create a button on excel and assign macro to it and click that button with mouse click

and done.