Hello Community,
I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba?

Please Help

Recommended Answers

you need to write a program to read excel file using .net and use the same application to write back into another excel.

Jump to Post

you mean you want the complete code? or just an idea?

Jump to Post

All 6 Replies

you need to write a program to read excel file using .net and use the same application to write back into another excel.

I know that. I'm asking how?

you mean you want the complete code? or just an idea?

Maby a bit of the code just to start me off

Hi,

Do you mean manipulate Excel without it being installed on the machine or do you just want a way to do it in .net as opposed to vba?

If you don't mind excel being installed on the machine, then you can use Interop. Here is a sample: DevX.com

As for the other, I'm not 100% sure, I did do a project where I was trying to manipulate newer versions of excel as they are basically compressed XML files but I didn't get very far before we had to pull the plug.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.