+ Reply to Thread
Results 1 to 1 of 1

macro that opens webpage and automatically prints it

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    macro that opens webpage and automatically prints it

    The attached macro will loop through a series of websites that are dictated on "Sheet1" and then send that page to the printer automatically.
    What I am trying to do is to print to pdf using adobe pdf. To do this I just changed my printer default to the "adobe pdf" so the save as box pops up for every website that is opened.
    This is what I need help with: I am trying to automate the saving function so I don't have to pick a folder location and click save.
    I have dedicated column C for the folder locations and I would like to name the pdf documents by the names listed in column A.
    Can anyone please help me with this?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to run a clock in excel automatically when the workbook opens
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2014, 12:48 PM
  2. Replies: 1
    Last Post: 10-26-2012, 04:17 AM
  3. Macro to Open webpage, then save webpage as txt file.
    By jasocke2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2012, 04:25 AM
  4. Clicking a submit button after macro opens webpage.
    By CJPHX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2010, 08:55 AM
  5. Document opens, automatically starts recording new macro.
    By Vapor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2009, 12:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1