Using Send Keys in PDF

**queryak** · 07-06-2010, 01:08 PM

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.

**Paul** · 07-06-2010, 02:15 PM

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.

**royUK** · 07-06-2010, 02:34 PM

Which PDF program are you using?

What code have you got?

**queryak** · 07-24-2010, 02:15 PM

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.

**queryak** · 10-09-2013, 11:37 AM

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.