Open a closed workbook with VBA and Write Insert or Save Data

[@The-lz6kx]

I appreciate this was a long time ago but how could you mod this to find next blank row and then paste? as I have several users submitting data to a mastersheet

[@ShayBerry]

How do you do this by simply referring to another worksheet within the workbook?

[@LearnerCB246]

Sir how can modify your instructions to open a file (xls) insert text in range (H7) and in range H36 ( "PA I D" & "_" & (date()+45). and save the file as xls and pdf.Thank you

[@wilgo58]

Is it possible to write to this workbook without opening the workbook, saving and then closing every time?

[@josuemoraes1333]

what about a opened book. How to refresh it without close and open it again?