Forum Discussion

tim_p70f9's avatar
tim_p70f9
Copper Contributor
Mar 17, 2020

pass a value to cell on open

Hi all I wish to pass the value from a userform to a new file that i'm opening from a template. so far ive got the code to open the template i need to pass the info to the required cells

 

Workbooks.Open ("C:\Users\timpe\Desktop\tr800.xltm")
Dim tempWB As Workbook
Set tempWB = Workbooks(ActiveWorkbook.name)
With tempWB
.SaveCopyAs "C:\Users\timpe\Desktop\testing\Template1.xlsm"
End With

 

kind regards tim

 

No RepliesBe the first to reply

Resources