Questions tagged as 'vba'

Tagged questions
0
answers

Adding records to MSFlexGrid via textbox in VBA

How can I add records to MSFlexGrid via a textbox in VBA? I found a way to do this ( link ) but for vb6, using screen.twipsperpixelx that does not exist in vba ... Anyone with a solution? Many thanks.     
asked by 23.02.2017 / 01:04
0
answers

Tab in excel

Hello I have a spreadsheet with some data on federal revenue imports. About this worksheet I make a tabulation of data, based on one of the columns that comes in this worksheet called "product description", from this column I check the informati...
asked by 19.02.2017 / 17:01
0
answers

Error when selecting second data / ListView information

I'm developing an application and I'm stuck in the following process. The application is called "INFORTGEI" and is for a IT shop . When we run the application we are able to observe a form / window ) with a stripmenu menu) strong> in it,...
asked by 05.01.2017 / 14:40
1
answer

access menu with over effect. Selenium VBA

I'm having trouble accessing an "interactive menu" using the Selenium library in VBA. follow html code of the page: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <tit...
asked by 20.01.2017 / 15:30
1
answer

I can not get into the "main2" frame. VBA and SelleniumWrapper

I'm trying to access a web page and manipulate its controls via VBA and Selennium Wrapper , however, these controls are within a frame with " name = main2 ", follow the VBA: Sub z() Dim objCollection Dim numeroPregao, dataAssinatura,...
asked by 23.12.2016 / 17:58
0
answers

Extracting two information via Selenium and pasting into only one cell in excel

I'm trying to extract some web information Via selenium, the point I'm catching is this: I can direct information from the selenium searched on the internet and save it inside a specific cell, however what I need would be, that in a query two fi...
asked by 19.12.2016 / 20:45
1
answer

How to capture the td of a web page using selenium vba?

The html code looks like this: <table> <tr> <td width="01%" class="tex3b"><img height="14" src="/imagens/tm_bullet.gif" width="6"></td> <td width="20%" class="tex3b">Órgão</td>...
asked by 29.12.2016 / 14:58
1
answer

HTML controls problems on a web page with VBA

I'm trying to fill in the controls on a web page with an interaction between VBA and IE, I'm not able to find and popular the fields referring to the effective date of the minutes. PageURL: link VBA code: Sub x() Dim ie As Internet...
asked by 22.11.2016 / 19:28
1
answer

VBA MS Access - application version

Does anyone know how to change the version of my access application. Type, in C # one I put the version number in the assembly file, and then I can get this to put in a label for example. How do I do this in VBA MS Access?     
asked by 22.11.2016 / 15:28
0
answers

VB Module - How to direct to a site

Hello, So I tried several methods, but I did not get anything I wanted and then I came here to ask for help. It is the following, I need that when I access through the example browser: link , it does the verification that I want and then...
asked by 11.12.2016 / 00:04