i,
I am trying to write a code to do the following
Retrieve last modified .xls file each folder is in a directory.
example: "Project" folder has many project folders like P1,P2,P3etc
Each Project folder has Budget folder in it. ie P1 has
Budget folder
Budget folder has many Budget Sheet, like B1, B" extra
Each Budget Sheet has a "tracking" and "Title&Notes"
Sheet
Now i want to write a code that will fetch me the following
information
Sheet 1:
1. Name of the Budget Sheet.
2. Last saved date
3. Location
Sheet 2:
1. PM from "Title&Notes"
2. Project Name from "Title&Notes"
3. Monthly Budgeted Hours from "tracking"
4. Monthly Actual Hours from "tracking"
5. Monthly Variance from "tracking"
6. Cumulative Budgeted Hours from "tracking"
7. Cumulative actual Hours from "tracking"
8. Cumulative Variance from "tracking"
I am newbie to coding
Hope some one can help me
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
