i m trying to scan thru the namemanager via vba macros and delete all tables with prefix "import" but i keep getting error sub or function not defined on dlookup
sub DeleteTables() If Not IsNull(DLookup("Name", "MSysObjects", "Name='import' AND Type = 1")) Then DoCmd.DeleteObject acTable, "import" End If End Function
Last edited by littleangel; 09-05-2023 at 12:58 AM.
If you are talking about Structured Tables, you can't delete the references in Name Manager. Those references are created when you insert a Table, and subsequently managed by Excel.
Not really a case of what the names start with.
You'd have to delete the table or convert the table back to a normal range.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Obviously the initial post code was not made under Excel ‼ Or wrong forum section ?
The reason why copying / pasting can't be obviously coding …
the code was for a function i changed it for macros ,instead of sub if its function it gives no error but when its changed to sub it gives error....plz note..i m still a noob in vba and leaning from google
Re: unable to delete table with certain prefix via vba
Originally Posted by littleangel
Again : here it's an Excel VBA forum but your code is obviously very not an Excel VBA code ‼
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
What are you trying to delete? The Reference to a Structure Table in Name Manager? The actual Structured Table? Or something else? Maybe something in Access?
this code worked to delete name containing "import" from name manager
Dim FName As Name For Each FName In Application.ActiveWorkbook.Names If InStr(1, FName.Name, "import", vbTextCompare) > 0 Then FName.Delete Next
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
littleangel 
Register To Reply
Bookmarks