Sunday, January 29, 2012

My Menu ver 1.0 - Insert Formula

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
at
Labels:

No comments:

Post a Comment

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...

  • Copy Data from PDF to Excel Using Send-keys
    If you want to copy the data from pdf file to Excel. Sub method1_using_sendkey() Dim task ' open the file ' change the path of ...
  • Import data from SQL
    Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...