Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 23rd, 2007, 04:33 AM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pasting into spreadsheets

I am looking to open a selection of spreadsheets, select the same cells from each worksheet and paste them into a table in a new spreadsheet.

So filename iain range("B3") is pasted into filename iaintable range("A1"), followed by filename iain123 range("B3") pasted into filename iaintablerange("A2").

I'm looking to do this as part of a loop, can I set dim range "A1" as, say abc, and then past into range("abc") followed by range("abc + 1") etc, or is there a better way to do this!?

Iain



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting data from excel spreadsheets Neil1234567 Access VBA 2 October 16th, 2007 07:28 AM
Import spreadsheets for Sarbanes-Oxley reporting makkerc Excel VBA 6 August 29th, 2007 08:03 AM
Extracting data from Spreadsheets in a folder IainAL VB How-To 2 April 20th, 2007 02:57 AM
Insert filename in several spreadsheets nori233 Excel VBA 1 January 19th, 2007 09:33 AM
Import Multiple Unknown Excel Spreadsheets in .Net bcarmen Excel VBA 1 January 31st, 2005 04:46 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.