Recent content by Anna007

Hi to all of you, You are all very nice to help me out so much... I really appreciate it!! :-) I can work to improve this a little more till next week friday.. but not much time left at all! So, I will use WordApp.quit as I have been using it. I wasn't sure if this terminates the process or...

Ok. I already played around with Chdir and it worked well. So, I've got that figured out.. thanx however.. :) Now, I just need to know how to terminate a process (winword.exe from the task manager). Would wordapp.quit do it?? Thanx for all of your help everyone.. Hope I don't run into any big...

Hi, Have another question: I have this code for when the user needs to select the file from where a directory. I need it to default to where the workbook is saved and not just temp to begin with: Now, as soon as the dialogue is displayed, the user needs to go to the appropriate directory to...

Hi PHV and Gerry, I have read your comments.. thank you .. :) The book-marked documents are in .doc format. I don't want these files touched.. what I want is to populate them and then, save them as something else.. however, the problem is if the user clicks on cancel on the SaveAs Explorer...

I don't know how to Terminate the Processes via VBA code... don't know the command for it.. Does wordApp.quit work for this?? I tried that line of code: Set Wordapp.Visible = True but gave me an errror. Now as for the main problem here: Ok. Here it is.. I tried the line of code you gave...

I have another problem.. in the task manager, I have sooo many Winword.exe processes .. as I've been testing.. so, what do I do with them??? Thanx, Anita

Hi Tony, Thank you soooooo much for all your help. Very nice of you!! :) Ok. Here it is.. I tried the line of code you gave me for opening the document after I close it: WordApp.Documents.Open(FileSaveName) The problem is very strange.. If I put a breakpoint on this line, then, it'll open the...

Hi Tony, Thank you for your time. :) Ok. I'll try and answer the questions as much as I can... 1-2. lets just says there is one instance of a word doc (I have a template that I have book-marked and populate via Excel). 3. After populated, I prompt the user (explorer window) for a name for the...

I am doing this now: FileSaveName = Application.GetSaveAsFilename(InitialFileName:="", Filefilter:="Word Files (*.doc), *.doc") If FileSaveName <> False Then With Mydoc .SaveAs Filename:=FileSaveName, FileFormat:=wdFormatDocument, ReadOnlyRecommended:=True...

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...

What is taking about a min (if not longer) is the code for hiding rows of an amortization table. I have about 60 rows and I need to hide all the zero rows of this table. In excel 2002, this would take about a couple of seconds only and now, with Excel 2003, it's taking about a min or...

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...

Hi, Thank you but I have got it working fine now. Thanx anyways, Anna

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... :)...

I have been having trouble with this but I'm having a work-around for now. Thank you, anyways. What I really need to do now is this: My doc is book-marked and I'm trying to do the following from Excel: Mydoc2.Bookmarks("Equip_TotalPrice").Range.Text =...