How to use VB to use info from one wkbk - open another and paste info on second workbook.

[UMAKEMESIK]

Hello to all,

I have a workbook log that with each line detailing
info that was input from a seperate workbook.

on the log cell a1 has a hyperlink back to the original sheet.

When the original sheet was filled out and the user clicked a submit button
the sheet pulled certain infomation and opened a seperate workbook ( the log ) and
place all of that information on the next open line.

When i am on the log - the last cell in each line column 28 is called date Closed.

when the process manager opens the log and puts a date on column 28 stating
the process is complete I would like to
change directories open up the hyperlinked form ( the original sheet/wrkbook) - place today's date on cell c43
save the original sheet and close with the locked date

then save the log and close it all.

i also have a complete path......

i tried to hack something to wrap my brain around this one but could not finish

ChDir _
         "R:\General\SLZ\SloDesign\NPR FORMS\" & Range("B2") & "\"
'this is the folder path
    Workbooks.Open Filename:= _
        "R:\General\SLZ\SloDesign\NPR FORMS\" & Range("B2") & "\" & Range("E4") & " - " & Range("C4") & " - " & Range("A4") & ".xls"
'this is the complete path to the file name on the server - the ranges are pulled from the log
    Range("C43").Select
    ActiveSheet.PasteSpecial Format:="=TODAY()", Link:=False, _
    ActiveWorkbook.Close
    
        Application.ScreenUpdating = True

i can explain more or elaborate if needed.

thanks in advance for any help or suggestions.