Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Word
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Word
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 -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Word
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 :- -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Word
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...ting_word.html -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to Word
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,... -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
excel object linked to word will not add sums in word | Excel Discussion (Misc queries) | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) |