Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing references
Hi I wonder if anyone can help with this. I am trying to use the
following code to remove a reference to a project in VBA so that I can then close that workbook from with the active workbook. The code seems to obey all the structures as set out in VBA help but it, and as many variants as I can try, don't work. Does anyone know how to do this Many Thanks in anticipation Steve Code:- Sub remref001() Dim str001 As Reference Set str001 = Application.VBE.ActiveVBProject.References(7) str001.Remove End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing references
UnTested...
try... activeworkbook.VBProject.References.Remove(str001) -----Original Message----- Hi I wonder if anyone can help with this. I am trying to use the following code to remove a reference to a project in VBA so that I can then close that workbook from with the active workbook. The code seems to obey all the structures as set out in VBA help but it, and as many variants as I can try, don't work. Does anyone know how to do this Many Thanks in anticipation Steve Code:- Sub remref001() Dim str001 As Reference Set str001 = Application.VBE.ActiveVBProject.References(7) str001.Remove End Sub . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing references
Sorry that was one of the variants I tried (tried it again though just in case) Basically the syntax seems OK but VBA comes back with "object doesn't support this method" Anyone any more ideas Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing references
using the () is a syntax violation - it evaluates the object and returns the
default value which isn't applicable as an argument. so removed the () activeworkbook.VBProject.References.Remove str001 so if you have a reference to the VBA extensibility Library Sub AABB() Dim str001 As Reference Set str001 = ActiveWorkbook.VBProject.References(7) ActiveWorkbook.VBProject.References.Remove str001 End Sub if not Sub AABB() Dim str001 As Object Set str001 = ActiveWorkbook.VBProject.References(7) ActiveWorkbook.VBProject.References.Remove str001 End Sub -- Regards, Tom Ogilvy "Steve" wrote in message ... Sorry that was one of the variants I tried (tried it again though just in case) Basically the syntax seems OK but VBA comes back with "object doesn't support this method" Anyone any more ideas Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing references
Tom
Brilliant as usual ! Many Thanks. Steve "Tom Ogilvy" wrote in message ... using the () is a syntax violation - it evaluates the object and returns the default value which isn't applicable as an argument. so removed the () activeworkbook.VBProject.References.Remove str001 so if you have a reference to the VBA extensibility Library Sub AABB() Dim str001 As Reference Set str001 = ActiveWorkbook.VBProject.References(7) ActiveWorkbook.VBProject.References.Remove str001 End Sub if not Sub AABB() Dim str001 As Object Set str001 = ActiveWorkbook.VBProject.References(7) ActiveWorkbook.VBProject.References.Remove str001 End Sub -- Regards, Tom Ogilvy "Steve" wrote in message ... Sorry that was one of the variants I tried (tried it again though just in case) Basically the syntax seems OK but VBA comes back with "object doesn't support this method" Anyone any more ideas Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
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) | |||
Removing circular references without the use of macros? | Excel Discussion (Misc queries) |