Macro to save an excel file (that is not the activesheet) to PDF / multiple users

[Mdelgado]

Hello, I need help to create a macro that converts an excel file to PDF, but this macro will be used on other PCs

This file is not active, but I have the File Name in the activesheet in cell C21 and I need the macro to save it as PDF in "C:\Users\"specific number"\Desktop\Escalations"

The specific number is the value in cell C22. Or if there's a way to identify the active user that would be better.

I've been trying some codes i found in internet but with no success. I really appreciate your help!!

Thanks.
Mdelgado.

[davesexcel]

Chances are, you cannot save a workbook as a PDF without opening the workbook first.

[Mdelgado]

Yes, I think so.. I'll have to change it so it opens the files first. Thanks!