+ Reply to Thread
Results 1 to 5 of 5

Using Send Keys in PDF

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Using Send Keys in PDF

    I need to print around 100 excel files into pdf. I use a macro to do the same. But everytime the macro prints the pdf it prompts to save the file. I want to use Send Keys which should automatically save the file in the destination which I would provide. Please help.

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Using Send Keys in PDF

    Hi Queryak, welcome to the forum.

    I believe it would be easier to configure your PDF application to automatically save files to a specific location. I think you *can* control other applications through VBA, but it's not simple and I don't believe SendKeys will work on windows outside of Excel.

    In Excel 2007/2010, you would have the option of saving directly as a PDF file rather than using a PDF "printer" to create the files.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Using Send Keys in PDF

    Which PDF program are you using?

    What code have you got?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    07-06-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Using Send Keys in PDF

    I am using Excel 2003 and my code opens each excel file and prints it and then selects adobe pdf writer from print dialog box and creates the pdf file. But everytime it prompts to Save the file.

  5. #5
    Registered User
    Join Date
    07-06-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Using Send Keys in PDF

    Hi Paul,

    I once again came across with similar problem. I have designed a excel tool which tries to open a link, the link is nothing but a file which is stored in a website.

    For e.g.,This is the file stored in abc website: http://www.abc.com/abc.zip. And there are several other links.
    When the tool tries to download the first file it gives user prompt to login. Once the user gives the login details it doesn't asks for user details again. It also gives user to check mark "remember my credentials" so that it doesn't ask for user details again and again.

    But the issue is someone needs to click the OK button everytime. Is it possible through excel we can click the OK button.

    Any help will be highly appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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