Questions tagged as 'excel-vba'

Tagged questions
1
answer

Skip digits when running

I have a problem, I got a script here to insert the ninth digit if the phone starts with 6,7,8,9 .. Function ValidarCelular(Myrange As Range) As String On Error GoTo ErrHandler: Dim regEx As New RegExp Dim strPattern As String...
asked by 04.05.2018 / 16:29
0
answers

Doubt with the Sender command of Excel objects in VBA excel

I have a excel VBA code which sends some specific email recipients some email's but at first these emails are being sent out because my outlook is coming out with my name but in Outlook we have the option to type from which name you want to send...
asked by 29.03.2018 / 20:12
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
1
answer

Find last cell filled in a range

Is it possible to find the last filled cell in a range and paste a value in the next empty line below? I need a code that searches the range ("B5:B35") I used the following code but after cell 35 I have other information so the data is...
asked by 16.03.2018 / 02:55
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
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

VBA Button Code

Good, I created a file (query database) where each number corresponds to a PDF (hyperlink). I tried to create a USERFORM to search the PDF through No. and it is up to date. I would like to press the View button and open the PDF but I can not....
asked by 30.01.2018 / 15:03
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
1
answer

Goto Error Handling Does not work in loop

I have an application running in VBA, in it I have an error handling that works perfectly the first time the action goes through it, but it is inside a For Each loop and the second time it simply ignores the treatment, I do not know if I'm forge...
asked by 23.11.2017 / 14:05