application.wait

I am trying to read cell A1:A1500 on closed workbook C:\TimeCards\CivlianAlphaRoster.xls for loop info on open workbook to save as filename. I have tried for 3 days with no results. Can someone help to see what I may be doing wrong? Mega thanks for any help. Short VBA is below. Sub...

I am new to macros and I want to do something I am sure someone else would like to do. I have two spreadsheets. Spreadsheet 1 is closed and perfected to the way I need it. Second Spreadsheet 2 is a spreadsheet of 60 names that I want to rename with Spreadsheet 1 Names. Below is the vba I am...

Here is a Website Link http://www.rcn.montana.edu/resources/converter.aspx Option Explicit Sub UTM_Converter() ' Place all your declarations here Dim i As Long Dim browobject As Object Dim obj1 As Object Dim obj2 As Object Set browobject =...

Good Morning All, I have a sendkeys project I am nearing completion, the only issue I have currently is I get stuck on a section of the application that requires you to hit the select button. I searched google but for the most part found no solid solution. Is it possible to include a Left Click...

Hi everyone, I'm new at this. I copied the below code from one of the thread. It works perfectly but I want to make it loop until I decide to cancel it. Thanks in advance. Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim sh1 As Worksheet, sh2 As Worksheet Set sh1 =...

I'm thinking this should be possible using the Application.Wait function, but I'm wondering how you get the input to close after resuming if there is no entry?

I have a macro that calculates a sheet, waits 1 second, then does it again. After 12 seconds, it switches to the next sheet and does the same thing. I'd like the macro to run certain number of times, based on the value of a cell that the end user inputs into a box. I've minimal experience with...

I posted up a couple of months ago asking for help with a workbook: https://www.mrexcel.com/forum/excel-questions/1019628-workbook-has-repair-about-25-time-i-open.html I remade the workbook from scratch as suggested in the thread and deliberately didn't include the macro from the previous book...

Dear Excel Ninjas, I am facing a challenge at work. I am getting the error in the subject line. Kindly see my code below and please help. :) Sub Loop_Macro() Application.EnableEvents = False Application.Calculation = xlCalculationManual Application.EnableEvents = False...

I have this userform that shows when opening the work book, it displays my contact info along with some information of the macro file (version, date modified, etc.) I want to add a fake loading bar to this userform to make it look less annoying for the user. The main point of this userform is...

Hello, Sub Macro2() ' ' Macro2 Macro Range("AR10") = "ENSURE THERE IS ENOUGH PAPER." 'Application.Wait (Now + #12:02:00 AM#) Dim x As Long For x = 1 To Range("EG1:EG131").Rows.Count If Range("EG1:EG131").Cells(x, 1) <> "" Then If Range("EG1:EG131").Cells(x, 1) = "N" Then Range("D7") =...

Hi I have workbooks saved for each of our distribution centres, each workbook contains multiple tabs detailing different things. I want to extract one particular tab out of each of these worksheets, there are 80+ so don't want to do it manually! Using existing VBA that I have tweaked, I've come...

I am working on a Project where the task is to populate a list of pdf-files (in sheet "Get files") and then open each pdf-file, copy all text and paste this text into a column of another Excel sheet ("ExtractedText") Everything Works fine except for the final step of pasting it from clipboard...

Hello all, I've tried a few varieties of this and each time VBA seems to be running much longer than necessary for a "1 second" pause. Can anybody help me out with what's wrong? Private Sub KeepOpenWB_Click() Sheets("HOME").Range("AM1").Value = 1 Me.Hide MultiFileOK.Show If...

Hi all, I've been looking for a solution to this problem for a long time without finding anything that works. Hopefully someone out there can help me in the right direction :) I have an excel-file that contains alot of pivot charts and tables that i need to export to a powerpoint presentation...

Hello guys, I have this piece of code that is used to access a Link. Once this link is open, an excel file is automatically downloaded. This file is big and takes about 2 mins to open. The problem is that vba does not wait for the file and continues to the next line of code, which creates a...

Hi, I have a workbook which copys data from a web data connection. The problem I'm having is the website updates each minute, with various amount of data, until an upload is complete (this can take a while sometimes), and I don't want the macro to continue until all data is uploaded. So I...

Hi everyone I've been working on a user form which some staff at work have asked for. I looking to create an event form so that staff members may type in text box, the name of the event, then enter a time in a DTPicker for the time the event is due and then set a time for how far in advance...

Is there a way to force excel to make sure it is updating a screen before it runs the next line of code? I'm playing with VBA, trying to expand my comfort with it. I've created a version of the popular SIMON game. HOWEVER, once every three code runs or so, the computer locks up, and rather than...