Yongle,

The 32 to 64 bits problem is solved, I grab a 32 bits machine.

My code needs to:

1. Open an specific webpage in IE (check!)
2. Print the content to PDFCreator, save it with an specific name in an specific folder, without asking the user (Need help here!)
3. Loop above for a while (piece of cake!)

What's driving me nuts is how to control the PDF printer (set by default to make life a little less complicated).

This is the code I have so far..

Sub OpenPrintWebPage()
Dim ie As Object
Dim oApp As Object
Dim FileName As String
Dim FolderLoc As String
Dim URL As String
Dim i As Integer
Dim Max As Integer
 
Set ie = CreateObject("InternetExplorer.Application")


Sheets("URLs").Activate 'The one that contains the URLs in column 1, Folder in 2 and Name to save the .pdf in 3


Max = Cells(1, 4) 'Number of URLs to work 


For i = 1 To Max


    URL = Cells(i + 1, 1)
    FolderLoc = Cells(i + 1, 2)
    FileName = Cells(i + 1, 3)


    ie.Visible = True
    ie.Navigate URL
    
    Do Until ie.ReadyState = 4
        DoEvents
    Loop
    
    'Printing this is the part that doesn't work
       
    ie.ExecWB 17, 2
    ie.ExecWB 12, 2


Next i


End Sub
The code runs, but the printed file location is unknown, actually if I use a physical printer it doesn't work either.

I had been searching this topic the whole morning, and trying different options mentioned in other posts but nothing seems to work.

As always your help (and the help of anyone who knows how to take me out of my misery), is highly appreciated!

Pegaso