Questions tagged as 'vba'

Tagged questions
1
answer

Generate a file and attach in email with vba

I made a macro where it opens the Outlook, up to that beauty. now I need to supplement it with the following items. I need to get 4 tabs from my spreadsheet, generate a new file and then attach it to the email and send it. Can anyone help...
asked by 21.05.2018 / 15:03
1
answer

Run-time error '13'

I am creating a macro to delete the cell values that contains # N / A, but it gives me the presents (Runtime error '13') When I put # N / A the code works. Can anyone help me solve the problem? Private Sub CommandButton1_Click() 'percor...
asked by 14.05.2018 / 19:22
2
answers

How to identify dimension launched in the sales editor by an article with dimensions?

Environment%% of ERP Spring I am trying to identify the dimension released in the sales editor when launching an article that deals with unsuccessful dimensions. I used the available events vba and EditorVendas_ArtigoIdentificado b...
asked by 15.05.2018 / 17:39
1
answer

How to update the page of a site after changing the value of a field by VBA

Good evening. I would like to know how I can update the page with the date that I reported by VBA. I put the date but the page does not change. Since you do not have a button, I do not know what to do. Sub Links() Dim ie A...
asked by 11.05.2018 / 05:20
2
answers

Excel VBA - Run-time error '13': Incompatible Types

I'm getting the error '13' Incompatible types, in the line of the first If: Count = 0 For x = 1 To LastRow Step 1 If Cells(x, 8).Value = "Materiais" Or Cells(x, 8).Value = "Imobilizado" Then If Cells(x, 11).Value = "NÃO CATALOGO" T...
asked by 11.05.2018 / 19:49
1
answer

VBA - Form that feeds a worksheet with values

Dear, I am new to VBA and for my project I am trying to make a userform that feeds a spreadsheet according to the information that the user input. I am having an error that I do not understand how to solve .. The error is shown in the line: L...
asked by 02.05.2018 / 22:11
1
answer

Auto Filter VBA - excel

I need to make a filter with a certain value in a tab of a worksheet, after the filter is done, I need to copy, open a new document, and paste this information. I have developed the code below but it is not working. follow the code Sub f...
asked by 22.05.2018 / 18:33
1
answer

Erase an executable file (.exe) after finishing without knowing its location?

The bat file has been converted into an executable. The del "%~f0" command does not work! Will it be necessary to finish running the executable first taskkill /f "nome_do_executável.exe" and then delete it? Question: - How to l...
asked by 03.04.2018 / 15:30
1
answer

Error '70': Permission Denied

When I run the code below, the title error appears in the 'For Each' line. Is this a block from the site itself or does it have some error in the code? Declara função Sleep If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVa...
asked by 29.03.2018 / 14:41
1
answer

How to put a warning message when closing the article listing window in SPRING

Spring Spring environment, I need to trigger a warning message every time a user closes the article listing, at this time existing events do not foresee this action. Is there another way to control the closure of the chip and trigger the...
asked by 19.04.2018 / 12:35