execution

RE: Stopping macro execution without generating an error message.... This code displays a userform every 5 seconds t = Now() + TimeSerial(0, 0, 5) Application.OnTime t, "RepeatMSG" And the macro which displays the form: Sub RepeatMSG() Userform.Show t = Now() +...

Hello all, I have a very simple problem (i am sure it is), but i just can't resolve it: - I have one excel workbook that opens another workbook with VBA: Application.Workbooks.Open Filename:="C:\Users\xxx\Desktop\yyy.xlsx", UpdateLinks:=True -I need the VBA to update all the links, then copy...

Morning all, Yesterday i added the code supplied below. I also was using the worksheet after for quite some time without any errors etc. This morning when i come to use the same worksheet i see the following error message. Code execution has been interrupted. I removed the code that was...

Hi, I need to understand a logic. I have services that have a lead time that can be from 1 to 30 days. as of the date that this service was issued, I need to add to its date the days of its execution period. I can not add Saturdays, Sundays and holidays. I have a table with all the days that...

Hi! :) I was wondering if there is a code to ESTIMATE run time of a macro (before going through all of the loops and calculations). I already incorporated elapse time and timer but the result comes out after the total execution of the codes and hence shows how long it took place. Any help or...

Greetings, I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that...

I have a UserForm that has 43 text and combo boxes. I want to introduce some code that verifies that certain fields are completed, and in certain formats. An example is "txt_Updated". This field is required to be completed. I added the code below, but want the User to be able to either enter...

Hi Everyone, I have to create 79 tabs in excel using a standard template [see below], but that references sequential values in a separate worksheet. We will call the template worksheet "Template" and the worksheet that contains the reference values "Reference". I need help creating a macro to...

Is there any way to write a public function that will trigger if code execution is ever cancelled by a user. For security reasons, I would like to program it in so that if the user breaks the code or if there is an error I didn't catch the program automatically brings the user to a "safe" place...

Why is this code executing so slow? Sub AIPlacing() Dim x As Integer Dim y As Integer Dim row As Integer Dim row2 As Integer Dim row3 As Integer Dim row4 As Integer Dim column As Integer Dim column2 As Integer Dim column3 As Integer Dim column4 As Integer Dim AIDirection As String Dim checker...

I have a list of workbooks and a related function/sub that formats the workbook and outputs some data. The list is stored in a sheet similar to the following.Book1ABCD1WrkBkFunction2Report1FmtRpt13Report2FmtRpt24Report3FmtRpt15TblMstrFmtTblMstrSheet1 I would like to be able to call/execute the...