Macro to Upload data to a different workbook is broken

[Carling73]

I'm trying to write a Macro to upload data from one workbook called "OutcomeUpload" to the next empty row in "sheet1" on another workbook called "Postings". The code i'm using (below) finds and opens the "Postings" workbook but doesn't upload the data. I've tested the vba by posting to another sheet in the "OutcomeUpload" workbook instead of the "Posting" workbook and that works fine. However when I try to upload to the "postings" workbook I get an error message saying "Run Time Error" "Object doesn't support this property or method".

Please Login or Register  to view this content.

the following rows seem to be the problem I think

Please Login or Register  to view this content.

Hope you can help

[extremis]

where the data start in your file?

according to this code, it start at row 65536 and column A...

Set rNextCl = wsData.Cells(65536, 1).End(xlUp).Offset(1, 0)

[extremis]

can you upload your file? and tell me which and where the data start you want to copy.

[Carling73]

Hi Extremis

File attached below

The Data starts in D20

Sample 1.xlsm

Cheers Mate

[extremis]

try this..and in your sample..the data doesnt start in D20 ;/

Set rNextCl = wsData.Cells(20, 4).End(xlUp).Offset(1, 0)

[Carling73]

Cheers Extremis

One more question if I may, how can I get the "Posting" workbook to automatically save and then close once the data has been uploaded. I was going to use the following code after "End With" but before the msg box:-

Please Login or Register  to view this content.

But now can't get this to work. Any ideas ???

[extremis]

if it,s the active workbook you are working on it would be

Please Login or Register  to view this content.

if it's Posting

Please Login or Register  to view this content.

i you beleived i help you. Add to my reputation and put a solve on this post

[extremis]

*if you believed i Helped you

[Carling73]

Will do Extremis, I have another question but i'll post on a separate thread so this can be "SOLVED" cheers mate