Vba copy paste

[deadlock2004]

HI,

I need to copy a value on an activesheet cell A1, to another workbook located at d:\location\aaa.xls cell C3.



TIA.

[xladept]

Hey Deadlock,

You also need the destination sheet name.

[sktneer]

I haven't done this before, but you may try this code.......

Please Login or Register  to view this content.

[deadlock2004]

Hey Deadlock,

You also need the destination sheet name.

It is Sheet1

[deadlock2004]

I haven't done this before, but you may try this code.......

Please Login or Register  to view this content.

Thanks sktneer for the quick reply! I have been doing some reading, and I find it safer to use the paste special values instead. How do we incorporate it to your code?

[sktneer]

Try this........

Please Login or Register  to view this content.

[deadlock2004]

Thanks sktneer, I just found the time to get back to this project. It seems to be working very well, thank you very much!

[sktneer]

You're welcome. Glad it helped.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post)--> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.