Excel to Word

[Curare]

I am trying to build code that would create reports from excel base
calculations. I have a standard format of the report whereby onl
numbers have to be posted to it.

Sub RunXL()
Dim myWB As Excel.Workbook
Set myWB = GetObject("C:\Temp\XLtoWrd.xls")
Selection.GoTo _
what:=wdGoToBookmark, _
Name:="Amt"
Selection.TypeText (myWB.Sheets("Sheet1").Range("Amt"))
Selection.GoTo _
what:=wdGoToBookmark, _
Name:="Dys"
Selection.TypeText (myWB.Sheets("Sheet1").Range("Over"))
Set myWB = Nothing
End Sub

My question is how can I allow for file browsing in the code? I don'
want to keep sending my final excel files to the temp directory. I'v
tried using GetOpenFilename, but I get a "Method or data member no
found" error.

A follow up to this question is about the bookmarks. I want a specifi
bookmark shown in several areas, but Word just moves it. For instance
in the example above, I want "Amt" shown on three separate pages, bu
Word only allows for the most recent bookmark assignment I gave it. I
there a way to go about this?

Thanks

 

[Curare]

Never mind about the first part. I inserted the follwoing code and i
worked:

Dim FName As Variant
FName = Excel.Application.GetOpenFilename("Excel File (*.xls),*.xls")
Set myWB = GetObject(FName)

I'm still lost with the bookmark stuff, so any help will be greatl
appreciated.

Thanks

 

[Curare]

Also I just wanted to mention that I have thought about mail merge. Th
report I want merged utilizes all the columns in excel, and I'll need a
least 50 more :-

 

[Dick Kusleika]

Curare

A follow up to this question is about the bookmarks. I want a specific
bookmark shown in several areas, but Word just moves it. For instance,
in the example above, I want "Amt" shown on three separate pages, but
Word only allows for the most recent bookmark assignment I gave it. Is
there a way to go about this?

That question may be better asked in a Word newsgroup. I'll bet they tell
you that you can't have two bookmarks with the same name, but I'm just
guessing.

If you're interested, here's a post about going the other way, that is, from
Excel to Word.

http://www.dicks-blog.com/excel/2004/08/automating_word.html

 

[Curare]

Thanks. I think you're right, there's no way to have multipl
bookmarks. I guess I could differentiate using nomenclature e.g. Amt
Amt1, Amt2,...