LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Grabbing data from diff window w/o activating it


I would like to grab data from one window's sheet and put it in another
window. Problem is that I do I do several thousand times. Is there a
way to do it with having to activate the window #1 copy, activate
window #2 paste, but rather go into window 1 and move data to window 2?
It would save a ton of time to visually show each window popping up...

I tried something like this:


Code:
--------------------
dim x as string
x = x & windows("blah").sheets("sheet").Range("A1").value
--------------------


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=396938

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grabbing data from MS Word nims Excel Programming 3 August 19th 05 01:10 PM
Error on activating a window a open workbook Hari[_3_] Excel Programming 1 June 11th 04 12:58 AM
De-Activating the menu option, Window - Unfreeze Mario[_6_] Excel Programming 0 January 12th 04 06:57 PM
How to hide Excel window when activating a Shape object Yi[_2_] Excel Programming 4 October 8th 03 02:36 PM
How to hide Excel window when activating a Shape object Bob Kilmer Excel Programming 0 September 27th 03 03:51 PM


All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"