+ Reply to Thread
Results 1 to 2 of 2

timing issue with macro

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2010
    Posts
    25

    timing issue with macro

    Hey everyone,

    Im having what I believe to be a timing error with my macro.

    Please Login or Register  to view this content.
    The Macro works fine until I get to "Sendkeys "^v"" the macro takes too long to paste the information and before its done pasting it jumps to the next line.

    Ive tried having the macro wait, but it doesn't finish pasting in time, regardless of the wait time.

    Does anyone know how I can get the macro to run the next lines of code After the paste has been completed?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: timing issue with macro

    In this line it takes some time to open the file but macro run faster before checking whether it is opened or not. What is the file type you are trying to open?

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Timing Issue - Password protected workbook
    By dhd2005 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2010, 08:48 PM
  2. Pong Excel Game - Timing issue
    By Whizbang in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2010, 04:15 AM
  3. 24hr Timing issue
    By heramiah in forum Excel General
    Replies: 7
    Last Post: 07-10-2009, 09:32 AM
  4. Timing a macro
    By ducttape in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 06:25 PM
  5. Timing Issue??
    By Geoff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1