|
 |
access thread: Splitting Data Excel Files using VBA
Message #1 by <elmerespinosa@y...> on Sat, 21 Jul 2001 00:37:08 +0800
|
|
Splitting Data in Excel Files using VBA
i.e.
Division
Invoice Group
Yellows to Div
Released
Insert
Special Instructions
2/28/01
Transmission of
3/1/01
1
753
B,G
3/1/01
3
Mail orig to customers AND send yellow copies to Division-(no
envelopes)
5
2/28/01
Transmission of
3/1/01
Manila
7
I want the division, Invoice Group, Yellow to Div and Released cells
split in from the original excel file to a new excel file and the rest
of the cell to the other new xls file.
How you can help me
Thanks
Elmer
Message #2 by "Vince Kavanagh" <vince@6...> on Fri, 20 Jul 2001 21:17:02 +0100
|
|
You just need to call TransferSpreadsheet and use the add method on the new
workbooks.
If you intend to do this from Excel you should look at Knowledgebase Article
Q213651, "How to Select Cells/Ranges Using Visual Basic Procedures"
Best Regards,
Vince.
-----Original Message-----
From: Espinosa, Elmer L. [mailto:elmerespinosa@y...]
Sent: 20 July 2001 17:37
To: Access
Subject: [access] Splitting Data Excel Files using VBA
Splitting Data in Excel Files using VBA
i.e.
Division
Invoice Group
Yellows to Div
Released
Insert
Special Instructions
2/28/01
Transmission of
3/1/01
1
753
B,G
3/1/01
3
Mail orig to customers AND send yellow copies to Division-(no
envelopes)
5
2/28/01
Transmission of
3/1/01
Manila
7
I want the division, Invoice Group, Yellow to Div and Released cells split
in from the original excel file to a new excel file and the rest of the
cell to the other new xls file.
How you can help me
Thanks
Elmer
|
|
|
View Cart
