VBA: Excel workbook to workbook transfer 
Author Message
 VBA: Excel workbook to workbook transfer

I am trying to a messy report that I run at work into a beautiful and
useful Excel Spreadsheet.  It is run on a Unix system, so when I transfer
it to a PC and pull it up in Excel there is a pattern but this pattern is
useful in Excel.

I am new to programing in VB or VBA and that's why I am having a hard to
time getting this to work.  This is all the program/macro consists of:

    Windows("giver.xls").Activate
    Range("D2").Select
    Selection.Copy
    Windows("receiver.xls").Activate
    Range("A2").Select
    ActiveSheet.Paste

This little segment is going to need to repeat itself more time than I
care to write it and probable more that VBA can handle, so I want to make
it into a loop.  I have that already set up and it works fine.  This is
the problem:  How do I get VBA to recogniz a variable instead of "D2" or
"A2".  The letters (D,A) can stay, but the numbers need to change.

Any help would be greatly appreciated.

Thank you,



Tue, 04 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Excel HRESULT: 0x800A03EC when using Workbooks.open or Workbooks._opentext in C#

2. Excel 97/2000: making custom functions (in a hidden workbook) available to all open workbooks

3. combine multiple excel workbooks into one workbook

4. Unable to delete and Excel Workbook from VBA

5. Excel vba code not finding workbook, adds .xls extension

6. Extracting VBA modules from excel workbook

7. Populating a ListBox via a VBA macro when opening an Excel Workbook

8. Pasting Range from Excel 2002 via VBA to Word causes a New Workbook to open

9. Excel VBA workbook app hangs on open/close

10. Using VBA to Import a Range from an Excel Workbook

11. VB or Excel VBA, accessing list of all the sheets in a workbook

12. Excel VBA: search multiple-sheets in a workbook

 

 
Powered by phpBB® Forum Software