Macro to search the desired worksheet and load data to another worksheet
Renaming Files (Using Excel Spreadsheet)

Dear Experts,

I am very new to Macros. As such I wished to automate a Quality Check (QC) Report. There is a folder on our server where all the monthly QC files are saved. I want to run a macro to create a report of daily total volumes cleared vs internal errors identified vs external errors identified. The moment the run button is clicked it should ask "For which month" And whichever month I type, it should open the folder containing the QC files and search for the title of the QC files and open the required file. The first report in this report file is a daily report. The same report I want staffwise. The staff names are stored in the QC file in validation. So if there is a new staff getting added this new staff details should appear in the report through this macro only where in the macro searches the validation for the last staff name and if it matches with the existing staff list then ignores else creates the same report format as for the other staff.

I hope I will get good help from this site.
Please help as this is a part of a six sigma control phase where we want to create a robust accuracy reporting system with no person dependancy.

Thanks and Regards for all your valuable time and advice.

-question by Learner

Rename a Macro to a the value of a cell
Renaming Files (Using Excel Spreadsheet)

I have a very VSB question

Here it I I have a monthly workflow that needs to be renamed to the value of cell AG65

Here is the expresion I have so far it renames it and saves it into
ChDir "Q:\AR - PS Comment_RTP Queue\Templates"
Workbooks.Open Filename:= _
"Q:\AR - PS Comment_RTP Queue\Templates\Linked CMT_RTP WorklfowTemplate New.Xls" _
, UpdateLinks:=3

Windows("Linked Workflow Template1.Xls").Activate
Windows("Linked CMT_RTP WorklfowTemplate New.Xls").Activate
Windows("Linked Workflow Template1.Xls").Activate
ChDir "Q:\AR Supervisor\WorkFlow\Workflow 2008"
Range("BC49").Select
ActiveWindow.SmallScroll Down:=-12
ActiveWorkbook.SaveAs Filename:= _
"Q:\AR Supervisor\WorkFlow\Workflow 2008\New AR Workflow.Xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Windows("Linked CMT_RTP WorklfowTemplate New.Xls").Activate

ChDir "Q:\AR - PS Comment_RTP Queue"
ActiveWorkbook.SaveAs Filename:= _
"Q:\AR - PS Comment_RTP Queue\New CMT_RTP Workflow.Xls", FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=Falsedifernte locations but I need it ot rename it as the weeks go on
Instead of "New AR Workflow" I need it to be the value of cell AG65 which would be the begining weekday

-reply by robert

renaming jpgs with excel
Renaming Files (Using Excel Spreadsheet)

Replying to WeaponX
I'm trying to do the same thing...But my script will not run
The following is highlighted: FSO As FileSystemObject
And it says: user defined type not defined.

Any solutions???
Thanks, andrea

-question by Andrea