I'm using the following code to take calculated data in VBA and send it to specific cells on an excel sheet. The code I have used causes the data to show up on the first worksheet in the excel book in the specified cells. Does anyone know if it is possibly to put the data into a specific workbook and how I would modify the code?

Cells(3, 4) = DiameterFt
Cells(4, 4) = FloorThickness
Cells(5, 4) = FootingThi