Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ActiveX Script to append one Excel file to another Excel file

Status
Not open for further replies.
Jabez3rd

Jabez3rd

Programmer
Feb 6, 2003
9
US
Good day all!

I am creating a DTS service containing an ActiveX script that manipulates .XLS files. To complete this process, I need some code that appends one Excel spreadsheet to an existing Excel spreadsheet.

In one part of this process, I'm using the FileSystemObject to move the files from one directory to another. Is there a method associated with the FileSystemObject that would solve this problem?

Any assistance will be greatly appreciated.

Thanks.

 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
189
grnzbra
grnzbra
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
248
gk53
gk53
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
171
drlex
drlex
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
282
markjoseph1232
markjoseph1232
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
181
kat50
kat50

Part and Inventory Search

Sponsor

Back
Top