Replies

The Payne Consulting Group advertises a solution to automate the removal of metadata: a product called Metadata Assistant. I haven’t personally used it. To get more information, contact Metadata@PayneConsulting.com or call Shirley Gorman at (888) GO-PAYNE (reported in Microsoft Office Solutions magazine).

To disable this feature, use this VBA command:

CommandBars.AdaptiveMenus = False

It applies to all of the CommandBars in the application, so you only need the single command.

Microsoft provides a utility macro to move AutoCorrect entries from one computer to another. To do this, a utility macro prepares a Word document that contains all of the AutoCorrect entries, which should be just what you need. Look here: http://support.microsoft.com/default.aspx?…b;EN-US;q207748

URL tags added – Mod

All of the Office 2000 applications can use VBA to read XML files, parse them, and use the information contained in them. In Excel, for example, I start like this (assumes that MSXML 3.0 or up is installed):

Set objDoc = CreateObject(“Msxml2.DOMDocument”)
objDoc.Load “C:myXML.xml”

I’ve now created an XML document and loaded an XML file into it. I can use all of the DOM methods to read the file.

For IE, if you simple load the XML file, it applies its default XSL file against it, or applied the XSL reference contained in the file itself, to return a display. For more complex processing, you can use VBScript, JScript, or JavaScript to read an XML file and apply DOM methods. Using the same example as above, you would begin:

var objDoc = new ActiveXObject(“Msxml2.DOMDocument”);
objDoc.load(“C:myXML.xml”);

If you can be more precise about what you’re trying to do, we can try to answer more questions. I would definitely go to http://www.vbxml.com for some good XML tutorials, and to http://www.devguru.com for guidance on XML DOM.

Hope this helps,

Yes. Let’s say you have two frames set up like this:

Then, you can set a button on page1.htm with its onclick property set to:

parent.otherFrameName.functionName()

Then, in page2.htm, which contains the form, you place the function that actually submits the form:

function functionName() {
document.all.formname.submit();
}

This function should be adjusted if you’re working with Netscape, but you get the idea.

Wherever possible, Amy, you should keep linked files in the same folder. That way, you can move them wherever you like, without fear of disrupting the links.

This is the correct answer for links, but the question was what to do with table cells. Am i wrong, or can HOVER only be used with links, and not with other tags?

I don’t believe you can set this in a style sheet, because onmouseover and onmouseout are EVENTS. Instead, you set each TD individually. The following table contains cells that have red text when the mouse is over them, black when the mouse is not:

Cell 1	Cell 2	Cell 3
Cell 4	Cell 5	Cell 6

Hope this helps,

The Slipstick site has a page of resources for connecting Access with Outlook here: http://www.slipstick.com/dev/database.htm.

Hope this helps,

It depends on how you open the window. If you use a tag like this:

the window.close() method will NOT prompt you, because you created an entirely new window.

Similarly, you can use a tag like this to open a new window:

Again, you will not be prompted when you have a “java script:window.close()” link on the new page.

There’s a good Web reference page (these examples are included) at http://www.michael-thomas.com.

Hope this helps,

The second question is easy. As a developer, I work in 1024*860, but resize my current window periodically to see how an 800*600 user would see it. I have this as a shortcut on my IE links bar:

java script:resizeTo(800,580)

I’ll think about the first question.

Hope this helps,

Since you’re on O2K Pro, have you considered importing the worksheet file into Access? This will be much faster.

I think this example from the MSDN site will give you what you need:

[url url=”Object Map. This page offers you a sample HTML page, with buttons that allow the user to open a folder, or run a program from the Run dialog, for example.

For security reasons, though, the user has to have the switch to “Run ActiveXObjects Not Marked as Safe” on, which generally isn’t a good idea. In your situation, though, it should be okay.

Stan Scott
New York City

Without knowing more about your script, I suspect that the security features of HTML are overriding your wscript. It would be very dangerous, wouldn’t it, if you could bring up an HTML page and have it muck around in DOS? I could be wrong, but I don’t think this is possible. If you let us know what you’re up to, though, there may be other alternatives.

Stan Scott
New York City