Thanks Tony,
Sorry I didn't reply earlier. I thought I had tried that when I first saw your message but I must have been imagining it.
OK that seems to have fixed the problem so far so now I just need to recreate the one that I want to keep and (crossed fingers) it will work :-)
Cheers!,
Averil
Hi Gerry,
Quote:
"Are you say you deleted an existing textbox in the .DOT file, made a NEW textbox (in the .DOT file) and you are getting the old one? "
Indeed I am saying that. I deleted the offending text box in the .DOT file and created a new one. When a "new" file is created from this...
Not sure if this helps... use this code to run code on all .xls files in a folder:
Sub RunCodeOnAllXLSFiles()
Dim lCount As Long
Dim wbResults As Workbook
Dim wbCodeBook As Workbook
'Application.ScreenUpdating = False
'Application.DisplayAlerts = False
'Application.EnableEvents = False
On...
Thanks, but the issue is that I have created the text box with the fields in it that I want (i.e. <Legal_Entity_Name> is a member of the Lloyd's Register Group... etc.)
However, when you open from the template a new text box (which I have deleted in the template and is the old one I want gone)...
Hello,
I'm not that good with Word VBA (Excel is more my thing).
I was given the mission to update some templates by adding new offices to the form(s) which had a mass of spaghetti code. I'm not giving them a complete overhaul because we are changing them soon.
However, I'm confused about...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.