I posted this today but I don't know if I was clear in what I was
asking.....
I need to put a cell value of an unopened excel sheet in a text box.
When I open outlook a user form automatically comes up with a bunch of
text boxes that I need filled with certain cells (they are formulas).

The cells are in the following excel sheet

\\Mascarolinabdc\puball\Newport Precision\Spreadsheets\NPI PVD Log
Sheet.xls
The sheets are "maintenance 1", "maintenance 2", and "maintenance 3"