Questions tagged as 'excel-vba'

Tagged questions
1
answer

A Macro to run all Modules?

I have several modules and within these modules I have several subroutines with some functions on separate sheets. I want to run the macros separately! That is, start the next sub routine after finishing the previous subroutine. EXAMPLE OF ON...
asked by 07.06.2017 / 12:51
1
answer

Copy and paste cell when changed

I'm starting to use VBA with the office package, as I still know little I'm having trouble getting this functionality. I was trying to do something simple and needed help to understand how it works: I need if one cell changes, its contents...
asked by 06.11.2017 / 14:57
1
answer

Automatic Logon in SAP BExAnalyzer by VBAProject

(UPDATED) In Excel I have an add-in that gives access to the BI system to access / layer data in a specified / structured query. In my VBAProject I'm referencing the Add-in to call some specific functions of this Add-in in an Auto_Open, that...
asked by 15.05.2017 / 15:50
1
answer

Macro email range + signature

Good morning. I need help with a macro for sending emails in Outlook 2007. I have a macro that selects a certain range of cells (everything to the right and everything down from a referenced cell) and pastes into an email, along with the i...
asked by 19.04.2018 / 16:07
1
answer

How to "concatenate" multiple values entered by a user into the table in a Msg box?

I'll try to summarize what I'm trying to do: I made a userform so that my user inserts data that will feed a table, it can put "n" information and the table will be formed according to the volume of data that it populates. After that, when...
asked by 03.05.2018 / 21:37
2
answers

AutoFill - How to select the second line

Dear, I have the following problem: I'm filling a cell with one formula and need to be duplicated for the other cells. So I'm using the code Selection.AutoFill Destination:=Range("C2:C329") Problem: Whenever I run this function, I mak...
asked by 09.10.2017 / 16:36
2
answers

Copying rows from one table that match one criteria and pasting into another Excel sheet

Hello! I am something new in VBA and I have gotten what I want through the macro recorder. However, I think that in this case I will not get what I want through this feature. I'll try to be clear on my goal. My Excel sheet is called "A3"...
asked by 28.02.2018 / 14:54
1
answer

Print alternate columns vba excel

with the code below: Range("C1:S" & Linha).Select ActiveSheet.PageSetup.PrintArea = "$C$1:$S$" & Linha Application.ScreenUpdating = True Range("C2").Select I can print all the columns in the col range. "c" to col. "S...
asked by 31.01.2018 / 11:30
1
answer

How to remove spaces in a text without turning it into number?

I have some code that at the time of conversion to excel, several spaces appear and I need to remove them via vba, but when I use the trim function it converts them to number instead of keeping it as text. Example: 1.1 Sub retirar_espaço...
asked by 02.04.2018 / 20:40
1
answer

Image with time interval - Excel

I need to assign an image that appears every 1 hour in EXCEL, how ?! You will probably need to use VBA. But I'm not very familiar. And you close by yourself after 1 minute.     
asked by 27.10.2017 / 15:15