Cant get VBA to copy one sheet data to another!

[BeginnerAtWork]

Hi forum members,

I have been at this macro for hours and unable to find out why it wont work, and from testing various available scripts on the internet this seems to be the fastest.

Objective - To download and open a file from a website i.e. http://www.asx.com.au/asx/research/A...dCompanies.csv
and on my current workbook "lets say Analysis.xlsx" worksheet "Summary" I am trying to open the downloaded file and copy information from ASXListedCompanies.csv into Summary then close ASXListedCompanies.csv and return back to the Summary worksheet. This is what I have, but it always opens the downloaded file and nothing is copied onto the Summary worksheet in the analysis workbook, please help!

Please Login or Register  to view this content.

[lotuxel]

Hi,
I think you change this
Set wnd = ActiveWindow
to
Set wnd = ActiveWorkbook

[BeginnerAtWork]

Thanks for that, didn't work.

Also now getting an error "Run-time error '9':
Subscript out of range
for this script
Sheets(ssheet).Cells.ClearContents

Was working fine awhile ago even after changing activeworkbook back to activewindow!

Regards

[AB33]

Subscript out of range means the object does not exist in the collection
for this script

Please Login or Register  to view this content.

Do you have a sheet named "Summary"?

[BeginnerAtWork]

Yes I do have a sheet called summary. Figure out why I was getting that error as abovementioned, but still unable to copy from workbook to workbook even using the manual recording macro.

If anyone can help please do. Thanks.

[BeginnerAtWork]

bump, can anyone tell me why the copy sheets is not working? tried manually recording the macro for the copy and paste from one sheet to another and still does not want to work.