By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

How to manipulate a spreadsheet?

P: n/a
>From inside Acess VB, is it possible to take the content of a range of
cells in an Excel spreadsheet and then stick that range in another
spreadsheet?

So far, I don't think it's possible, but I believe there is a work
around. What I think has to be done is to:

1. Import both the entire source and destination spreadsheet into an
Access table.
2. Copy whatever data from the source table to the destination table.
3. Export the entire destination table to the original destination
spreadsheet.

What do you think?

Thanks,
Tom

Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<to*****@yahoo.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
From inside Acess VB, is it possible to take the content of a range of
cells in an Excel spreadsheet and then stick that range in another
spreadsheet?

So far, I don't think it's possible, but I believe there is a work
around. What I think has to be done is to:

1. Import both the entire source and destination spreadsheet into an
Access table.
2. Copy whatever data from the source table to the destination table.
3. Export the entire destination table to the original destination
spreadsheet.

What do you think?

Thanks,
Tom
I think you could use Office Automation to do that using a linked table for
reading the data and Automation to spit it out to another (or the same)
Excel file.

Keith.
www.keithwilby.com

Jun 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.