Questions tagged as 'vba'

Tagged questions
0
answers

Add cascading data from one column in Access with Status by Line

I need to create a purchasing control per line where it generates a purchase need considering the quantity of each product per customer versus stock availability. As in the example of the table below I have an item XXX that is repeated in dif...
asked by 06.04.2018 / 04:01
0
answers

Import web page table into Excel

I want to get all the data from an internet table and put it in excel. I tried with the code below, but the following error appears in the 'For Each' line:    "Run-time error '438': Object does not accept this property   or method " Sub CCE...
asked by 05.04.2018 / 14:39
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
1
answer

how to make a chart in excel vba in the form of goals?

I need to make a graph where the bars change color depending on their value! example: less than a thousand red, between one thousand and two thousand yellow and above a thousand green follow image     
asked by 12.03.2018 / 00:53
0
answers

VBA References Configuration

Good morning, it may be something stupid, but I'm starting to work with VBA for data search on the web and every time I start a new project I have to add the references "Microsoft HTML Object Library" and "Microsoft Internet Controls ". How do I...
asked by 20.03.2018 / 15:16
0
answers

Duplicate record when saving data from a form in vba / useform

Good afternoon, friends, How do I duplicate a record in a worksheet with data saved from the useform. Being more specific, I will use an example of a health plan where I have a form that I register holder and dependents and need to save each...
asked by 13.03.2018 / 17:08
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 do I set the filters in a PivotChart through a macro in Excel?

I made a VBA form and wanted to click on a button for the filter properties of the PivotChart associated with a table in Excel to change.     
asked by 17.01.2018 / 12:21
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

Save Graph of a spreadsheet in a folder by VB

Hello everyone. I am a beginner in VB programming and I am with a project, where I access a worksheet and I enter data in it and this data is shown in graph. How do I save this chart as an image in a folder and then use that image? It's possible...
asked by 11.01.2018 / 07:40