Is it possible to enable automatic macro execution (run macro) every time a new email arrives? Can something like: Private Sub Application_Startup / Triggered() be added to the code?
Or at least add a command for the macro to click the blue button = (run macro) every time a new email arrives or to automatically click it every 3”?
(To automatically repeat the action ‘- run macro – every 3” (3 seconds)?
I thought the whole code should remain only in excel so that it doesn’t have to be entered into outlook?

I want to to automate the data collection of some cells of the sheet NomeSheet to fil some cells of sheet DATA, starting at row 45, collecting data for cells E45, I45, M45 and Q45 up to row 64, so I tried using for as show below, but it’s not working. Data to be collected are in the cells D47 to D50 of the NomeSheet sheet. Basically I need to include the variable m in the name of the cells. Can anyone help?

I want to to automate the data collection of some cells of the sheet NomeSheet to fil some cells of sheet DATA, starting at row 45, collecting data for cells E45, I45, M45 and Q45 up to row 64, so I tried using for as show below, but it’s not working. Data to be collected are in the cells D47 to D50 of the NomeSheet sheet. Basically I need to include the variable m in the name of the cells. Can anyone help?

Closed 3 days ago.

I have looked through some examples on here but nothing seems to quite fit what I need.
I need to take the variable DeptVar = "E22E27E33" (this is the result from the userform)
and turn it into this [Department] = "E22" and so on.

So, I’m using a macro to automate a tedious data manipulation process on a large data set. As part of this I take a pre-existing calculated sheet, let’s say “Output”, and create a new sheet called “Output_Final” which will contain the updated data.

I’ve got a simple class thats executes SQL query, then fill array with query results, next convert it into Range, a finally there is a list object created:

I am trying to run this code in VBA:

Closed 6 days ago.

These are the codes I am using right now. It works for the most part on my home computer with only 3 files to create the codes. Once I put it on my work computer which the code then goes through about 130 folders and pulls data from them. It seems to take a while to do and not sure if there is a better way to code it. The second problem is it only getting data up to 54 files and then seemed to stop getting the data, almost like it is looping back over the same folders. Third problem is it seems to open all the .xlsm files and not close them after getting the data and moving to the next file. I would like to have this run in a Workbook open event so it will update the files when the workbook opens or at button to run the update.