Questions tagged as 'macro'

Tagged questions
1
answer

Problem importing text file via VBA

I'm trying to import a text file into excel through the following macro: Sub Teste() Dim intervalo As String intervalo = "intervalo" Workbooks.Add ActiveWorkbook.Sheets("Plan1").Select With ActiveSheet.QueryTables.Add(Co...
asked by 10.07.2015 / 21:31
1
answer

Specify last line for form filling - VBA

I am making a form and I want the person to only register 6x (only 6 lines) the content. How to limit this amount? Asaboveexample,IputtherowsandcolumnsandwhenIfilltheform,newnumbersaregoingdownPrivateSubCmdSalvar_Click()DimLinhaAsInteger'Val...
asked by 23.11.2018 / 19:09
0
answers

How do I automatically convert a formula into a number in Sheets?

What script for Google Sheets is able to transform a formula into a number (as if it were to copy the formula and paste "values only").     
asked by 18.05.2018 / 02:58
2
answers

Chronologically order date and time VBA

Good afternoon, I would like to know how I do to sort by date and time for excel. It would be 1 hour column and one date column. My question is how do I sort the schedules chronologically without affecting the dates ?? Here's the example of h...
asked by 15.03.2018 / 20:50
0
answers

Popup Preventing Macro from Moving Forward

I have a macro that enters a particular site, populates a form, and sends save to the system, generates a request. After that, a popup is issued with an "OK" button. This ok has eventClick that ends the process and restarts the cyc...
asked by 15.03.2018 / 15:15
1
answer

How to close an alert in IE in with VBA

I have an Excel macro that connects to a local tool and extracts the information. Basically I take a report according to the user. I have a column with the users, however if the user does not present results in one day the tool triggers an alert...
asked by 26.02.2018 / 19:34
1
answer

Copy columns of corresponding rows

I have a spreadsheet that contains 100 lines with country names and 12 columns (months of the year) containing values. My need is to compose a macro that: sweeps the columns and copies them to another worksheet so that the country stays in colum...
asked by 22.11.2017 / 17:00
1
answer

Write dates (month / year) between two dates

Hello, I have two dates: Initial Before Jan-11 Oct-10 Feb-11 Sep-10 I'd like to know how I can have a macro that writes the date between them by adding these dates to two new rows and look in the price table for the price f...
asked by 30.10.2017 / 18:34
0
answers

VBA - Copy and paste data without column sequence to rows

Hello! I have a spreadsheet with two tabs: In PLAN1 I have a single column with several data, but they do not follow a sequence. The values that can be found in this column are: Product code (Ex: AAA7X), A xxxx, B xxxx, C xxxx, D xxxx, E xxxx, F...
asked by 11.09.2017 / 21:13
1
answer

Macro Vba - IE ... Click, Not working button

I am not able to click on a button that generates a report in Excel (after it opens that "File Download" tab "Do you want to save? Open? Cancel ?, but this part is quiet, I think, if not me and if they already have the solution ...). Problem...
asked by 13.09.2017 / 15:31