Showing posts with label My Menu ver 1.0 - File Names. Show all posts
Showing posts with label My Menu ver 1.0 - File Names. Show all posts

Friday, February 24, 2012

My Menu ver 1.0 - File Names

File Names

a) File Name Excluding Sub folder

If you click on it . IT will ask you to select the folder and will print all the file names in that folder ( will ignore sub folders files) in a new excel sheet.


b) File Name including Sub folder

If you click on it . IT will ask you to select the folder and will print all the file names in that folder (including sub folder files) in a new excel sheet.
at 1 comment:
Labels:
Subscribe to: Posts (Atom)

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...

  • Export Range in Json Format
    Macro to Export Range in Json Format Option Explicit Sub export_in_json_format()     Dim fs As Object     Dim jsonfile     Dim rangetoex...
  • Running SQL Queries within Excel Environment
    If you want to run SQL queries within Excel environment without  connecting to any database, you can do it with creating the ADODB   conn...