L
Lawrence
Hi,
i want the cell A1 equal to File name + Worksheet name.. is it possible?
Lawrence
i want the cell A1 equal to File name + Worksheet name.. is it possible?
Lawrence
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
If you are looking for a macro try this. Launch VBE using Alt + F11. From the
left tree view double click 'This Workbook' and paste the below code. Get
back to workbook. The below code will write the bookname and sheet name to
cell A1 on Save....
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1") = "[" & ThisWorkbook.Name & "]" & ThisWorkbook.ActiveSheet.Name
End Sub
left tree view double click 'This Workbook' and paste the below code. Get
back to workbook. The below code will write the bookname and sheet name to
cell A1 on Save....
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1") = "[" & ThisWorkbook.Name & "]" & ThisWorkbook.ActiveSheet.Name
End Sub
J
Jacob Skaria
If you are looking for a macro try this. Launch VBE using Alt + F11. From the
left tree view double click 'This Workbook' and paste the below code. Get
back to workbook. The below code will write the bookname and sheet name to
cell A1 on Save....
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1") = "[" & ThisWorkbook.Name & "]" & ThisWorkbook.ActiveSheet.Name
End Sub
left tree view double click 'This Workbook' and paste the below code. Get
back to workbook. The below code will write the bookname and sheet name to
cell A1 on Save....
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1") = "[" & ThisWorkbook.Name & "]" & ThisWorkbook.ActiveSheet.Name
End Sub
J
Jarek Kujawa
=CELL("filename",A1)
J
Jarek Kujawa
=CELL("filename",A1)
J
Jacob Skaria
Using a formula, you can try this provided the workbook is already saved.
=SUBSTITUTE(CELL("filename"),INFO("directory"),)
If this post helps click Yes
=SUBSTITUTE(CELL("filename"),INFO("directory"),)
If this post helps click Yes
J
Jacob Skaria
Using a formula, you can try this provided the workbook is already saved.
=SUBSTITUTE(CELL("filename"),INFO("directory"),)
If this post helps click Yes
=SUBSTITUTE(CELL("filename"),INFO("directory"),)
If this post helps click Yes
S
Stefi
Try this formula in A1:
=CELL("filename",A1)
Regards,
Stefi
„Lawrence†ezt Ãrta:
=CELL("filename",A1)
Regards,
Stefi
„Lawrence†ezt Ãrta:
S
Stefi
Try this formula in A1:
=CELL("filename",A1)
Regards,
Stefi
„Lawrence†ezt Ãrta:
=CELL("filename",A1)
Regards,
Stefi
„Lawrence†ezt Ãrta:
L
Lawrence
Thanks .. it works perfectly..
but just need to do some text function to make it nicer.
but just need to do some text function to make it nicer.
L
Lawrence
Thanks .. it works perfectly..
but just need to do some text function to make it nicer.
but just need to do some text function to make it nicer.
S
Stefi
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Post if you can tell us what form would be nicer for xou!
Stefi
„Lawrence†ezt Ãrta:
Clicking the YES button will be appreciated.
Post if you can tell us what form would be nicer for xou!
Stefi
„Lawrence†ezt Ãrta:
S
Stefi
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Post if you can tell us what form would be nicer for xou!
Stefi
„Lawrence†ezt Ãrta:
Clicking the YES button will be appreciated.
Post if you can tell us what form would be nicer for xou!
Stefi
„Lawrence†ezt Ãrta:
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.