Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I've had a macro in place for over a year and a half. It works fine weekly. Suddenly, I get an error. I've made no changes to the environment (Vista 32 Home Premium, Excel 2007) Under Tools / References I have checked: - Visual Basic For Applications - Microsoft Excel 12.0 Object Library - OLE Automation - Microsoft Office 12.0 Object Library These haven't changed. Here's some of the pertanent lines from the code: Sub CreateEditedSongListing() 'DECLARE VARIABLES Dim objFSO As Object Dim objFolder As Object 'Use Microsoft Scripting runtime. Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder(strSongs_EditedPath) End Sub I get an error on the first SET statement. "Run-time error: '429' ActiveX component can't create object." Any idea what's going on? Thanks for your help. -- Programmer on Budget |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Excel Stopped Working" Message | New Users to Excel | |||
Excel "has stopped working" (ie. crashes) on closing programme | Excel Discussion (Misc queries) | |||
Error 429 VBA.Interaccion.Createobject("Scripting.FileSystemObject | Excel Programming | |||
How can I get the author of a file using CreateObject("Scripting.FileSystemObject")? | Excel Programming |