Excel to Google to Print- screen (using adobe)

  • I have a block of VBA code that takes names from an excel list and searches them into google, within search parameters and print screens the results. However, the code saves the print-screen as a .png file and I need it to be saved as an adobe file as I need to be able to comment/see the entirety of the first page of results.


    I have tried my best to fix it myself but sadly it appears I cannot without the use of Selenium, which I can not use as I am unable to download software to my desktop.


    Please see my code below; any tips/ points of reference are greatly appreciated. Thank you