Replies

Or you can go straight to the Tools…Macros…Visual Basic Editor (Alt-11) to see where macros are stored now. Do this after you record a simple macro using Tools…Macro…Record and you have something to find when you get there.

The move from old-style keystroke macros to command macros and now…to object-oriented VB macros can be intimidating. I still remember my old File Save macro in Lotus: “/FS~” Simple!

Most people put their VB macros in a module attached to the Workbook, but only visible to you in the VB Editor. It’s not a tab in the Workbook. Experiment with the record macro feature and the VB editor and you’ll start to get the picture. In the VB editor there’s online Help specifically for macros.

Since the only way I know to keep the cells intact is to avoid line breaks, maybe you can replace all “^p” with some special character sequence as placeholders in Word. Then after the import, in Excel replace them back to line breaks with another search/replace.

If you mean listing all the Templates in your User Templates and Workgroup Templates directories, try a button that runs this macro:

Sub ShowMyTemplates()
Dialogs(wdDialogFileNew).Show
End Sub

If you mean something else, then you’ll probably need to create VBA form with a Listbox that can hold a list of “form” names to choose from. You’ll write a macro that adds the names of the available “forms” to this listbox, displays the form, gets your selected row from the Listbox and opens that form.

RE: Automatic startup. Bad experiences in the 1990s with Word Macro Viruses gave me an irrational aversion to automatic startup macros. Tell us more about the forms you have, how you use them, who is going to use them (just you or a workgroup of others, too), etc. and maybe someone will have a great suggestion.

Based on my experience at the office today I can state that the highest levels of complexity (and randomness) are generated by the simplest MINDS, as well. You should see the inventory spreadsheet down in Receiving! Talk about random.

Seriously, thanks for the overview. I just put a hold on Wolfram’s book at my local library. Looks very interesting.

mydlg.Format = “Rich Text Format (*.rtf)”

…worked for me once. And I mean ONCE. At least it shows the right files. Doesn’t always change the text displayed in the File Type field of the dialog however. Frustrating.

You can get a list of the built-in dialog properties (Name, Format, etc…) in the online VBA help.

Seriously?

Why not just put a link on your page to the .XLS file itself? Internet Explorer can load an Excel spreadsheet pretty well. If the user wants to save it to their PC they can pull down File..Save as. Try it and see what you think.

But if you think you’re gonna recreate Excel, all its functions and the VBA macro facility in HTML, well…

I don’t know how to turn off that “feature” to prevent them from appearing. Here’s some VBA code to remove them though:

Sub DeleteAllHyperlinks()
For Each xlink In ActiveSheet.Hyperlinks
    xlink.Delete
Next xlink
End Sub

You could get more precise if you only want to remove email hyperlinks by putting a condition in there like:

If Left(xlink.Address,6)="mailto" then xlink.Delete

I’m a little confused. “Many of the names reappear in EACH ROW” ??? You want a list of unique values in a ROW? With 10,000 records that seems like a big ol’ row.

My gut feeling was that a Pivot Table would solve your problem most easily.

Make a Pivot Table (Data…Pivot Wizard) that uses Vendor Name (Column C) as the Range and as the Row title and you can even use “Count of Vendor Name” as the Data. You really don’t have to select or use any of the other columns in your data table if you don’t want to. Pivot table will give you a column listing all the unique Vendor names. And Pivots update easily.

I vote for Legare’s VLOOKUP suggestion. That’s the elegant way to solve this puzzle.

Hunt it down with the Windows Start button…Find files…search your C: for the file NORMAL.DOT.

However, I’m doubtful this is your problem. It sounds like your dialog boxes don’t like you to list additional files or directories or something. Very weird. You’ll probably have to uninstall and reinstall to exorcise this demon possession. In the mean time, it’s easy to rename your NORMAL.DOT to something like NOTNORMAL.DOT. When you restart Word it’ll create a fresh copy of the NORMAL.DOT.

Virus-checking might turn up something. Any problem when you’re in your browser and you try to File…Save…scroll?

My “memory banks” are suddenly recalling a time when my users where making similar claims about scrolling in a Word doc cause Sudden Application Death Syndrome and the problem was a corrupt file …not in the Open dialog box though. In the actual document.

You could try renaming your NORMAL.DOT file just to see if that has any effect. Also check Tools…Macros to see if any FileOpen macro might have snuck in there to mess you up. That’s how some macro viruses work. They replace your normal commands with a macro that could do anything — usually not something you want.

Yup. It’s a bug (I think!) AND you’re missing something.

“Don’t bother trying to set the Title property directly in VB. If you don’t go through the dialog box it doesn’t always work. V. frustrating.” You can use VB to enter the text in the dialog box using the code I posted above.

I use a little macro in Word to display the number of any character I have selected. It comes in handy when I’m trying to embed an unusual character and need to do it in VB. Here it is:

Sub ShowAsciiCode()
MsgBox Str(Asc(Selection))
end sub

Enter or cut/paste the character in a Word doc, select it, then run this macro. It’ll tell you the number.

Oh, yes! Actually that’s what I was doing there. See, if you have text entered in the Document’s Title properties (File…Properties…Title) then when the user saves the file the FIRST time it will use that text instead of the first few words of the document.

I like to do that so the user can save whenever they want. But the macro to replace the save command works too.

[indent]

---

In Word, you can rotate text in a text box or table cell without having to use WordArt (as you did in previous versions of Word).

On either the Tables and Borders toolbar or the Text Box toolbar, Word provides a Change Text Direction button. The purpose of this button is to rotate the text into one of three predefined directions, and the button reflects the next direction of the text if you were to click the button again.

NOTE: The Change Text Direction button does not indicate the current direction of text, nor can you add a different text direction for use with the Change Text Direction button.

---

[/indent]– from Microsoft Knowledgebase (specific to Word 97)