ActiveWorkbook.FollowHyperlink strURL

  • Thread starter Thread starter David
  • Start date Start date
D

David

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.
 
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
 
Replace the .followhyperlink code with the recorded code. You'll have more
control over what to do with it after it opens.
 
Back
Top