Insert Formula
1 Sheet Name - It will insert the formula to show sheet name in active cell. ( Note Will work in saved workbook only)
2 FULL Path -It will insert the formula to show the path of active workbook. ( Note Will work in saved workbook only)
3 Workbook Name - It will insert the formula to show the active workbook name . ( Note Will work in saved workbook only)
4 Workbook Path -It will insert the formula to show full path of workbook . ( Note Will work in saved workbook only)
5 Todays date - will add formula to show today's date
6 Current Time - will add formula to show current time
7 Todays Day - will add formula to show today's day like sunday ,monday etc
Subscribe to:
Post Comments (Atom)
Import data from SQL
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
-
If you want to add a new menu on mouse right click "Workbook Navigation showing you the list of all open workbooks and worksheets in ea...
-
Please make sure that you have the latest Version Tool Last Updated on 17 Feb, 2012 Version 1.6 English Version For Excel 2007 &...
No comments:
Post a Comment