L
Legacy 205744
Guest
Can someone post code for the following?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Seeking program (script) that would:
· Open each Excel file (.xlsb) in a designated folder
· Save each
· Close each
Note: Needs to work even as folder content change (files added/removed/renamed)
Note: Best if program initiated by double-clicking icon in Windows
<o></o>
Specs: Excel 2007, Windows 7
Possible approach: VBScript using FSO
Thanks in advance.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Seeking program (script) that would:
· Open each Excel file (.xlsb) in a designated folder
· Save each
· Close each
Note: Needs to work even as folder content change (files added/removed/renamed)
Note: Best if program initiated by double-clicking icon in Windows
<o></o>
Specs: Excel 2007, Windows 7
Possible approach: VBScript using FSO
Thanks in advance.