-
WSstephan
AskWoody LoungerChris,
ADO by itself is not going to do it for you. You’re still going to have to learn ASP. Visual InterDev, which comes with the Visual Studio package (as Charlotte mentioned in her post), is simply a development tool for creating and deploying ASP. I, and not my former boss, was the one who made the decision to use it instead of competing technologies like Cold Fusion. And, like I said in my earlier post, coming from a VBA/VB background, I found Visual InterDev/ASP *really* easy to learn because the main server side language is VBScript. Now, as you get into web programming more, you’re also going to have to learn some JavaScript for client side stuff, and there’s no way around that. But the meat of the programming is server side.
The way I taught myself Visual InterDev was with essential 2 books. I started out with the easiest book on the market, believe it or not, “Visual InterDev 6 For Dummies”, which I zipped through within a week. With that, I already had enough knowledge to develop basic database-driven web apps. Then, I immediately graduated to one of the hardest books on the market, “Visual InterDev6 Unleashed” from SAMS, from which I got more intricate knowledge.
Anyway, with your experience in VBA/VB, I’m sure you too will pick up the web programming very fast.
Stephan
-
WSstephan
AskWoody LoungerThe answer for you is Visual InterDev, ASP and ADO.
Basically, I was in a similiar position about 2 years ago. I was strictly a VBA guy, but I needed to create database-driven web apps, which I had absolutely zero experience doing. I taught myself the basics of Visual InterDev and ASP within one week. (I already knew ADO.) Coming from VBA, this wasn’t too difficult because the main server side ASP language is VBScript, just another flavor of VB!
Anyway, a better forum for this type of question may be the “HTML/JavaScript/VBScript/etc…”. Also, you might want to check out a Visual InterDev forum I also belong to: http://VI6Talk.listbot.com
-
WSstephan
AskWoody LoungerNo actually, what I meant was Tahoma 8 pts. would appear to be different sizes within the very same form.
I’ve come to the conclusion that the problem is caused by the ridiculous Large Fonts option some of my users insist on using (rather than the resolution).
I will simply take the advice of Kevin or Gary and hopefully, that’ll take care of the problem.
-
WSstephan
AskWoody LoungerHere’s some code appropriated from QUE’s Special Edition Using VBA 5:
Sub Fly_From_Left()
ActiveWindow.Selection.SlideRange.Shapes(“Rectangle 5”).Select
With ActiveWindow.Selection.ShapeRange.AnimationSettings
.Animate = msoTrue
.EntryEffect = ppEffectFlyFromLeft
.TextLevelEffect = ppAnimateByAllLevels
.AnimateBackground = msoTrue
End With
End Sub -
WSstephan
AskWoody LoungerYes, in the File Open dialog box, click the Advanced button. Then in the ensuing dialog box, set as your criteria: Contents include words [name you’re trying to find]. Also, at the bottom of the dialog, pick the folder to search in.
-
WSstephan
AskWoody LoungerYou’re going to have to use a little trick here. Since you can’t find paragraph marks (^p) when using wildcards, you have to find something else that represents the paragraph marks.
Step 1:
With wildcards turned off, Find all ^p and replace with ~^p
(Note: this example assumes that there were no occurences of ~ to begin with. If there are, you need to pick another character.)Step 2:
Now, with wildcards turned on, to find the paragraph marks, enter ~? (i.e., ~ followed by any char.). This works because we know that the only character following ~’s are paragraph marks.Step 3:
After everything is finished, clean up your document by replacing all the ~’s with nothing. -
WSstephan
AskWoody LoungerIn other MS Office apps, you would put a command line switch to start the app and also run the macro, but I don’t think you can do that in Excel. I think your strategy would go something like this:
(In this example, let’s assume you schedule the task to run in task scheduler at 8:00 AM.)
1. Put the command line that starts Excel (“C:Program FilesMicrosoft OfficeOfficeExcel.exe”) in task scheduler.
2. Put the file that contains the macro you want to run in your XLStart directory.
3. Put the following code in the file’s Workbook_Open event procedure:
Private Sub Workbook_Open()
Application.OnTime EarliestTime:=TimeValue(“8:01 AM”), Procedure:=”YourMacroHere”
End SubNotice that the time I put in Excel’s OnTime method is 1 minute later than the time you schedule in task scheduler. The reason the OnTime method is necessary here is because otherwise your macro would run *every* time you launched Excel, which I’m sure you don’t want.
Stephan Ip
-
WSstephan
AskWoody LoungerAbsolutely brilliant. Thank you.
Stephan Ip
-
WSstephan
AskWoody LoungerBasically, what’s happening here is when you hit tab in an existing paragraph, Word auto-formats the paragraph with a first-line indent instead of putting in a tab mark.
If you find this behavior annoying, you can turn it off by going to Tools | Options | Edit and unchecking the “Tabs and backspace set left indent” option.
Stephan Ip
-
WSstephan
AskWoody LoungerNo, it isn’t protected. Originally, I thought I wanted the form fields to be protected, but later I realized I couldn’t do that, because the end-user has to be able to edit the document itself.
Again, what I’m really trying to do here is have the contents of fields throughout a document (like a COMMENTS field containing an invoice number) change throughout a document when the user changes a form field entry (hence, using the form field’s ExitMacro).
Stephan
-
WSstephan
AskWoody LoungerGary,
Thanks for your reply. Actually, possibility #1 is what’s happening here. I did test this using just one line of code showing a MsgBox. The MsgBox never shows up using either the EntryMacro or ExitMacro *unless* the form fields are protected. Only problem is I don’t want the form fields protected.
So, it looks like I am the victim of yet another Word/Word VBA bug — the FormField’s EntryMacro and ExitMacro won’t run unless the form fields are protected. Now, I am racking my brains out trying to get the original functionality I wanted some other way — updating the contents of fields throughout a document when the user edits one field.
Any ideas on how to do this?
(BTW, I almost forgot how much fun Word VBA is after having been away from it for a while.)
Thanks.
Stephan
-
WSstephan
AskWoody LoungerTry this:
Sub ReplaceEmptyCellsWithText()
Dim aTable As Table
Dim aCell As CellFor Each aTable In ActiveDocument.Tables
For Each aCell In aTable.Range.Cells
‘Len of end-of-cell “character” is 2,
‘so if Len of cell is 2, it contains no text
If Len(aCell.Range.Text) = 2 Then aCell.Range.Text = “New Text”
Next aCell
Next aTable
End SubStephan
-
WSstephan
AskWoody LoungerThe way I’ve always tested for the existence of optional arguments (parameters) is to use the IsMissing function.
If IsMissing(NameofArg) = True Then …
The only drawback to using IsMissing is that you must make all the optional arguments Variants because it *only* works with the Variant data type.
Stephan
-
WSstephan
AskWoody LoungerThanks Gary for the tip.
There’s nothing more frustrating in this programming business than when you know you have all the logic right and the results still come out wrong.
Stephan
-
WSstephan
AskWoody LoungerYou’re going to have to do this with code:
Sub RemoveAllHyperlinks()
Dim aHyperlink As Hyperlink
For Each aHyperlink In ActiveDocument.Hyperlinks
aHyperlink.Delete
Next aHyperlinkEnd Sub
However, you might have to run this sub multiple times to do the trick. Due to yet another apparent Word VBA bug, this sub is only deleting half the hyperlinks each time around. Go figure.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
3 hours, 55 minutes ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
3 hours, 56 minutes ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
7 hours, 51 minutes ago -
New PC transfer program recommendations?
by
DaveBoston
2 hours, 12 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
11 hours, 56 minutes ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
11 hours, 57 minutes ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
16 minutes ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
6 hours, 13 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
10 hours, 6 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
1 day, 6 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
4 hours, 50 minutes ago -
System Restore and Updates Paused
by
veteran
1 day, 9 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
20 hours, 33 minutes ago -
Turn off right-click draw
by
Charles Billow
1 day, 12 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
1 day, 16 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
10 hours, 5 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
1 day, 17 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
20 hours, 41 minutes ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
1 day, 23 hours ago -
KB5060842 Issue (Minor)
by
AC641
11 hours, 55 minutes ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
2 days, 6 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
23 hours, 32 minutes ago -
Acronis : Tracking Chaos RAT’s evolution (Windows, Linux)
by
Alex5723
2 days, 19 hours ago -
June 2025 updates are out
by
Susan Bradley
56 minutes ago -
Mozilla shutting Deep Fake Detector
by
Alex5723
3 days, 10 hours ago -
Windows-Maintenance-Tool (.bat)
by
Alex5723
2 days, 19 hours ago -
Windows 11 Insider Preview build 26200.5641 released to DEV
by
joep517
3 days, 12 hours ago -
Windows 11 Insider Preview build 26120.4250 (24H2) released to BETA
by
joep517
3 days, 12 hours ago -
Install Office 365 Outlook classic on new Win11 machine
by
WSrcull999
3 days, 12 hours ago -
win 10 to win 11 with cpu/mb replacement
by
aquatarkus
3 days, 4 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.