Search results for query: *

It certainly did! Thank you so very much! So why will it take a number and not the code text, do you think? Thanks again.

After Golom corrected my syntax in an earlier post, I'm having a different problem. The code below is supposed to open Word, opens a .txt document into Word, search for "+++" and replace with a hard page break, print the file to a selected printer, then close Word without saving the document...

No joy. When that file opens, it's the only instance of Word running.

Hm. Now, I have an open Word window with the first "+++" highlighted but not replaced. Any idea there?

*sighs* You know, I tried that and it didn't work. Then I rebooted and it did. Thank you!

From Access 2003, I need to open a .txt file, search for a text string, replace it with another text string, then save the .txt file to a different folder. The file opens in Word then I get the "Runtime error 424: Object required" error. The debug stops at the line...

Thanks again! Marji

Thanks for your reply, Leslie. Unfortunately not. If that's the solution, however, another make-table query will create one. MarjiS

I am counting closed help tickets and grouping them by the assigned technician from an issue tracking table using a make-table query. If a tech has no closed tickets, the table doesn't list him and I need the table to list all techs even if the total is zero. I tried using an IIF suggestion from...

*looks embarrassed* Well, duh. I've gotten so used to getting syntax errors that I didn't think to look for error in my code. Thanks, Bob.

I am copy/pasting info from multiple sheets into one master sheet. The format is the same on all sheets. Here is the code I'm using (simplified): Private Sub btnCreate_Click() Dim i, P1i, P2i i = 2 For P1i = 2 To 10 If Sheet2.Cells(P1i, 1) <> "" Then Sheet2.Rows(P1i).Copy...

Thanks, Skip. I'll start there. Marji

Skip, AS PHV has demonstrated, there is no need to SELECT a sheet or range as long as it is properly referenced. I'm hitting brick walls trying to get Excel to act like a database (because the boss said so). I know I'm not referencing worksheets, ranges, and cells properly and it's killing me...