Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Add References
One of my macros is "bombing" at the line below
and I know it is because since, I had it going, I had my PC Upgraded to Windows-Xp and probably lost all previous reference settings.. What library (name) should I add/select under Tools, References in order to proceed (with my macro)...? Set fsoFiles = fso.GetFolder(sFolder).Files |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Add References
Hi Jim,
Add a reference to the Microsoft Scripting Runtime library. --- Regards, Norman "Jim May" wrote in message news:GjD3f.6158$jw6.6156@lakeread02... One of my macros is "bombing" at the line below and I know it is because since, I had it going, I had my PC Upgraded to Windows-Xp and probably lost all previous reference settings.. What library (name) should I add/select under Tools, References in order to proceed (with my macro)...? Set fsoFiles = fso.GetFolder(sFolder).Files |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Add References
Norman,
Thanks.. Got it going!! Jim "Norman Jones" wrote in message ... Hi Jim, Add a reference to the Microsoft Scripting Runtime library. --- Regards, Norman "Jim May" wrote in message news:GjD3f.6158$jw6.6156@lakeread02... One of my macros is "bombing" at the line below and I know it is because since, I had it going, I had my PC Upgraded to Windows-Xp and probably lost all previous reference settings.. What library (name) should I add/select under Tools, References in order to proceed (with my macro)...? Set fsoFiles = fso.GetFolder(sFolder).Files |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
How to convert all 3d references to normal references in a workboo | Excel Worksheet Functions | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Tools | References - information about references | Excel Programming |