VBA to print file in directory

[bradyboyy88]

Hi,

I need to print a file in a directory using vba. I know the file path which we can call FilePath. The difficult part is selecting the printer as the save to pdf option and selecting the destination via USB or even better skipping that dialog box all together and keeping it contained in the VBA. Is this possible?

 

[Trevor_S]

Instead of using print, try ExportAsFixedFormat(xlTypePDF)

It can be used with at workbook, worksheet or specific range level - there's also a number of optional arguments detailed on Microsoft's website at https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.exportasfixedformat

 

[bradyboyy88]

Instead of using print, try ExportAsFixedFormat(xlTypePDF)

It can be used with at workbook, worksheet or specific range level - there's also a number of optional arguments detailed on Microsoft's website at https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.exportasfixedformat

This is to export excel objects though right? I want to export a pdf as a pdf. I know it sounds strange but its what I need to do lol

 

[Trevor_S]

So you're trying to save a PDF as a PDF? Couldn't you just copy the file - or are you trying to split it by only printing selected pages?
Are you using something like SendKeys to try to control your PDF reader?

 

[bradyboyy88]

Yea what I want to do is avoid copying because that just pastes all the contents and pdf settings. Instead imagine if you have a pdf in a file directory. If you were to go to google chrome or internet explorer and paste that file directory in the browser link it would let you see that directory. Then if you select the pdf typically it will open in the browser (alternatively you could just open pdf with chrome directly by right clicking the file). If you hit print then hit save as pdf, you get a raw editable pdf . So this is what I want to automate.

 

[Trevor_S]

I'd advise against trying to send keystrokes - it can go wrong too easily. I suspect that you may be better using IE than Chrome, as being another MS product it should be easier to control using VBA? But you're going beyond my experience. If you don't get any other replies here, may be worth trying a forum that isn't Excel-specific, as the tricky bit of what you're trying to achieve is related to the browser application, rather than Excel.

But when you do find the answer, please post it here - I'm sure it would be useful for others searching the forums!