Questions tagged as 'vba'

Tagged questions
0
answers

Transform html data within txt into Excel tables

I'm trying to transform some data that is in html and are within a txt to .xls in table form, that data is pertinent there is an email body that extracts, if there is any other idea I might be pulling that body and playing as xls would help me a...
asked by 13.03.2018 / 19:18
0
answers

Forms in Access

I am trying to assemble a form in Access (2007) to try to manage school hours. Currently everything is done by Excel, but because of the number of tabs, the file gets kind of slow. In addition, the system only works in the 2003 version of Excel....
asked by 14.03.2018 / 18:02
1
answer

Vba + Google Chrome

I have been doubting for some time and even after several searches I did not succeed. I'm creating a function in VBA that can handle a webpage using Google Chrome. Although I set the chrome as an object, I can only send "sendkeys" commands to th...
asked by 02.03.2018 / 21:20
0
answers

Go to cookis vba + selenium

Personal oops, good evening. Does anyone here know how to set cookies using selenium? When I use selenium it does not open a web page with the default profile and in this way does not open the browser cookies. I need to access these cookies t...
asked by 03.03.2018 / 06:06
2
answers

Find element without ID tag and Name

Expensive, I need to find the element that does not contain id or name in HTML. Below is the example HTML <button type="button" class="btn btn-primary ng-scope" data-ng-if="novo2()" data-ng-click="novo()" clickonce="">...
asked by 28.02.2018 / 21:23
0
answers

calendar returns date mm / dd / yyyy instead of dd / mm / yyyy

I am using a calendar that, regardless of the changes you make, always returns the date mm / dd / yyy, when it is supposed to be dd / mm / yyyy. The code below is not mine, it was taken from the net: Option Explicit Dim vDateSelectedVar As...
asked by 05.02.2018 / 14:02
0
answers

Setting Up a Macro

I need to set up information in a single worksheet that has been extracted from the system into several worksheets (plan1, plan2, plan3 ...). I need the information, when updating, to stay one below the other. The problem that per month can vary...
asked by 05.02.2018 / 03:09
0
answers

How to hide a Button with macro in a Powerpoint presentation without disabling it?

I tried to put a CommandButton associated with a macro and set it in the properties as a transparent background, but when the presentation starts the CommandButton is not invisible. Is there any way to make it invisible and enabled?     
asked by 17.01.2018 / 11:39
1
answer

VBA Error Viewing Data from a Worksheet

I'm experimenting with VBA and I've been able to add data to a DB on Sheet 2 . And now I've tried to show the data on sheet 1 where I choose the ID and it shows the data inserted there, but it gives me an error. Sub Busca() Dim valor A...
asked by 20.12.2017 / 15:11
0
answers

Model lp in txt to run in Gurobi

I created an optimization model through a macro, writing an lp template in txt to run on Gurobi. However, when I walk in the Gurobi, the model appears as infeasible. Does anyone know how to help me find the error?     
asked by 10.12.2017 / 22:23