sleep

this might be a a tricky one since not eveyrone here is famialr with ADP/Broadridge. Dim ws As Worksheet Dim tmp As Worksheet Dim acct As String Set ws = Sheets("Booking") Set tmp = ThisWorkbook.Worksheets.Add tmp.Activate On Error Resume Next...

I'm using the following macro to unlock my VBA projects when the workbook is opened. However if I already have another vba project unlocked, this macro will sometimes just place the password inside module and do nothing. Is there a way to designate specifically which project should be...

Hi, my Webpage is not active when i run this macro, Sendkeyps UP hapens in excel, is there a way to make the web paga active, like AppActive? I cant get AppActive to work befor the sendkeys command. The funny thing is that the macro works IF i open VBA befor i run it.. Sub automatic_order()...

Suddenly this code fails most of the time at the statement With .chart.Shapes(1) because there are no Shapes in the Chart Object! Does anyone know why pasting the Chart would sometimes not result in a Shape? Public Sub saveOrgChart(title As String) Dim shp As Shape, sht As Worksheet...

Hi members. I try to rotate a shape with this bit of vba thus creating an animation. Code is in Module Public Declare Function Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub rectanim() Dim wb1 As Workbook Dim ws1 As Worksheet Set wb1 = Workbooks("anim.xlsm") Set ws1 =...

I am trying to write VBA code to click a window and move the mouse back and forth for a game. What happens is the mouse selects the window and moves back and forth but does not actually move anything. It as if it wont recognize it is in the program. When I use it in paint/Excel any other...

I have some code I placed in the Sub Workbook_Open in an xlsm file which is placed in XLSTART folder. The code executes properly when Excel is opened. Problem. If any code is in the Sub Workbook_Open, and the user double clicks an Excel Workbook and Excel is CLOSED, the workbook will open, the...

Hello All, For numerous reasons I am unable to prevent my screen from going to sleep during periods of inactivity. It is still being used to watch a live spreadsheet though. Is there a way I can write a macro to move the mouse, or do some action so that the pc thinks it is being used. I am...

Hi All, I am using Excel Mac 2011 and require the code to wait for a certain period of time. Is there an alternative to using the 'sleep' command as results in an error? Thanks, Dave

Hi I believe I know the answer to this but I need to be absolutely sure before testing on bloomberg terminal. Bloomberg method RefreshAllStatic data doesn't suspend execution therefore any code called directly after this method is called is likely to be executed before the refresh is complete...