I'm hoping you all can help me (again).
I have a directory that is a repository for forms created in excel. All the forms have the same format. Re repository may contain hundreds of forms in various stages of completion. A form is "complete" when all the required reviewers...
Hello, I need code to loop thru all subdirectories open each workbook in the subdirectory that contains as part of the file name "_Sales Order.xls" and open each "_Sales Order.xls" and update worksheet "Sales Order Form" the following values:
C44 new value = "00-440"
D44 new value = " a few...
I have been trying to process Excel files in a directory with the following code:
Dim foldername As String
Dim FSO As Object
Dim fldr As Object
Dim file As Object
Dim cnt As Long
foldername = "c:\users\bseagreen\desktop\TuesdayFeb102009\week ending feb 7...
I'm new to VBA and am reading "VBA and Macros for MS Office Excel 2007" and "Excel with VBA & .Net" but do not as yet know how to tackle the following:
I have numerous workbooks in a directory that I want to combine into a master workbook but why I am posting is because I haven't read a...