I would like to have a button that when clicked copies "Note Template" to a new workbook, and then saves that workbook at a user specified path. After the workbook is saved, I would like the macro to insert a hyperlink to that file in the highlighted cell. Would be even better if I could pull values from specific cells in the original workbook to use as the file name when saved.
Filename desired is always in column E, same row as the highlighted cell desired for use.
I have a bit of programming background, but I have never used VBA or any language like it, so this is a bit tough for me to figure out.
here's what I have so far:
Private Sub CommandButton1_Click()
OldBook = ActiveWorkbook.Name 'Store Name for later use
projectLead = InputBox("Project Lead:", "Input Initials", "RN") 'Store Initials for later use
projectTitle = InputBox("Project Title:", "Input Title", "Name of Project") 'Store title for later use
Worksheets.Copy ("Note Template") 'Copy correct Worksheet
Workbooks.Add 'Create new book
End Sub
Bookmarks