VBA Query for Downloading a XLS File

[sathis]

Hi,

Iam using the following code to Download a excel file from web and copy and paste the contents to the worksheet.
My Issue is every time it opens a new worksheet , instead it needs to paste in the existing worksheet.

Thanks in advance
SAthis

Please Login or Register  to view this content.

[alansidman]

Here is your issue:

https://msdn.microsoft.com/en-us/lib.../ff837784.aspx

a worksheet copy will always post to a new sheet.

[sathis]

Hi,
Thanks for your reply,
How to fix it.
Instead worksheet.copy , i tried with copy destination and it failed.

Sathish

Here is your issue:

https://msdn.microsoft.com/en-us/lib.../ff837784.aspx

a worksheet copy will always post to a new sheet.

[alansidman]

Perhaps a range(YourRange).copy instead? You can then use Destination:

[sathis]

Perhaps a range(YourRange).copy instead? You can then use Destination:

Any Way , I fixed it on my own

Thanks
Sathis

[alansidman]

For the benefit of others who may have the same issue, please provide your solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[sathis]

Hi,

The Following code Provided the Solution.

Please Login or Register  to view this content.

FIIDATA - Denotes the Sheet Name to Paste

So Simple it was...


Sathish