Vba code to copy data to closed workbook

[satputenandkumar0]

Dear Members,

I am looking for VBA which will complete my below task.

• copy data from active worksheet to closed workbook.
• Active sheet data should copy below old data of closed workbook.
• data contain in A to K column of active worksheet.
• clear copied data
• If I moved both file any folder or drive, path should change automatically. ( something like fpath = current workbook path clworkbook= fpath & closedwbk.xls)

Any Help may appreciated

Thanks

[satputenandkumar0]

bump post .

[HaHoBe]

Hi, satputenandkumar0,

AFAIK you would need to open the closed workbook when relying on Excel VBA (you could either try using ADO or DAO to write to the closed workbook). Let´s see what steps you have so far to solve the problem.

Ciao,
Holger

[HaHoBe]

Hi, Hi, satputenandkumar0,,

maybe give this code a try:

Please Login or Register  to view this content.

Ciao,
Holger

[satputenandkumar0]

Dear sir,

Thanks for giving me your valuable time.

Method or data member not found, compile error is showing on below line

Please Login or Register  to view this content.

[HaHoBe]

Hi, satputenandkumar0,

please adjust the name of the sheet for the constant to suit and correct the code-line to read

Please Login or Register  to view this content.

Sorry about that - nobody´s fault but mine.

Ciao,
Holger

[satputenandkumar0]

Sir,

Thanks, I made below changes also.

Please Login or Register  to view this content.

&

.ClearContents to .Clear ' to remove borders also


Sorry for late reply

You gave me perfect code. Thanks again