Hello All, I am trying to open 3 different workbooks with macro scheduler, and two of them feed into the other one. In order for Excel to update the links, they all have to be in the same instance. Is there a way to open all 3 workbooks in the same instance? Let>filename=Z:\Daily Sales by Rep Report...

Hello All, I am trying to open 3 different workbooks with macro scheduler, and two of them feed into the other one. In order for Excel to update the links, they all have to be in the same instance. Is there a way to open all 3 workbooks in the same instance? Let>filename=Z:\Daily Sales by Rep Report...

JRL,

Do you mean the drop down save as tab? In that case yes.

Hello, I am new to Macro Scheduler and am looking for a way to convert an excel document to a pdf every morning, without having to be logged onto my computer. Is there any way that this can be done? If so I would love help on the code! Another issue that I am running into is that the excel file has ...