Search results for query: *

Hi, I am openings mydoc and mydoc2 (which are templates) and populating them via Excel automatically (via vba code). Now, I display the explorer window for the user to provide a SaveAs name at the end. If I hit cancel, it just continues. I don't want this. I want it to stop and set the docs to...

Hi, I have upgraded from Excel 2002 to 2003 and I have been developing. For some reason, my code is very slow and it was working very fine before in Excel 2002 and very quick!!! I don't know why?!!!! It then froze after the code ran. I don't understand why!!!! Please help asap.. anyone...

I have the following and I get an error: Mydoc2.Bookmarks("Equip_TotalPrice").Range.Text = Worksheets("Price").Range("ProposedEqptSellingPrice").Value My doc is book-marked and I need to grab the appropriate value from Excel and put it into the Book-Marked Field. Need help asap please... :)...

Hi, I have 2 documents in word that I populate via vba (bookmarking) from Excel. But I need to append/merge them together at the end, when completed. This way, it's easier for the user to look for 1 final file instead of 2. How do I do this?? Thanx, Anna

Hi, I am populating book-marked documents via VBA. Have a problem however: I have the following: Set Mydoc2 = WordApp.Documents.Open(Attach_2) Worksheets("CEM_Contract").Visible = True Range("x").Copy Mydoc2.Bookmarks("y").Range.PasteSpecial Call Mydoc2.SaveAs(ThisWorkbook.Path & "\xxx.doc", ...

I have a bookmark in my word document and then I have this range in Excel (Amortization Table) I am doing the following to copy and paste it into the word doc where the book-mark is: range("AmortizationTable").copy mydoc.Bookmarks("MyBookMark").range.pastespecial Now, it's pasted as a table...

I'm populating some word docs via Excel (tables and etc) but need to also protect it so no one changes this word doc afterwards. How do I do this? Can I password protect it?? I'm making them read-only but someone can copy and then change the copied version. I guess this is just normal anyways...

I am populating book-marks with tables from excel. The tables in Excel are big and dynamic in size; so, creates problems for me in word. I need to autoformat it in such is a way that it won't take much room in the word doc. How do I do this via VBA code? Hope this is descriptive enough. :) Anna

I have a bookmarked document and I insert fields into the word doc from Excel. I have changed the formatting to % from Decimal in Excel but when it's inserted into word, it's still in Decimal. I need to change it to %. Thanx soooo much! :)

I have this Amortization Table (a range with 5 columns and about 40 rows) that I need to insert into a word document, if some conditions are met. I don't know how to do this. Please help me with this. I'm desaparately in need of help asap. Thanx.... :)