Hello Group,

ActiveWorkbook.FollowHyperlink strURL, opens another workbook, does anyone
know how I can change it so that the data is put into the same workbook on a
designated worksheet?

Thanks,
David

Record a macro when you open the file, copy the data, paste to where you want it
and close the workbook you just opened.



David wrote:

Hello Group,

ActiveWorkbook.FollowHyperlink strURL, opens another workbook, does anyone
know how I can change it so that the data is put into the same workbook on a
designated worksheet?

Thanks,
David

--

Dave Peterson

Hi Dave,

A file is opened when the line executes and the data goes there. This is
already happening in code. I am just hoping that I can direct the out put to
the open already existing file(the file that is executing the code) and it
would be nice to be able to direct it to a specific existing worksheet.

Thank you,
David

"Dave Peterson" wrote:

Record a macro when you open the file, copy the data, paste to where you want it
and close the workbook you just opened.



David wrote:

Hello Group,

ActiveWorkbook.FollowHyperlink strURL, opens another workbook, does anyone
know how I can change it so that the data is put into the same workbook on a
designated worksheet?

Thanks,
David

--

Dave Peterson
.

Replace the .followhyperlink code with the recorded code. You'll have more
control over what to do with it after it opens.

David wrote:

Hi Dave,

A file is opened when the line executes and the data goes there. This is
already happening in code. I am just hoping that I can direct the out put to
the open already existing file(the file that is executing the code) and it
would be nice to be able to direct it to a specific existing worksheet.

Thank you,
David

"Dave Peterson" wrote:

Record a macro when you open the file, copy the data, paste to where you want it
and close the workbook you just opened.



David wrote:

Hello Group,

ActiveWorkbook.FollowHyperlink strURL, opens another workbook, does anyone
know how I can change it so that the data is put into the same workbook on a
designated worksheet?

Thanks,
David

--

Dave Peterson
.


--

Dave Peterson

I guess there is not a way to direct it, like I was looking for.

Thanks,
David

"Dave Peterson" wrote:

Replace the .followhyperlink code with the recorded code. You'll have more
control over what to do with it after it opens.

David wrote:

Hi Dave,

A file is opened when the line executes and the data goes there. This is
already happening in code. I am just hoping that I can direct the out put to
the open already existing file(the file that is executing the code) and it
would be nice to be able to direct it to a specific existing worksheet.

Thank you,
David

"Dave Peterson" wrote:

Record a macro when you open the file, copy the data, paste to where you want it
and close the workbook you just opened.



David wrote:

Hello Group,

ActiveWorkbook.FollowHyperlink strURL, opens another workbook, does anyone
know how I can change it so that the data is put into the same workbook on a
designated worksheet?

Thanks,
David

--

Dave Peterson
.


--

Dave Peterson
.