Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fine & Replace code not working
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...- MarjiS
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Runtime Error 424: Object required
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...- MarjiS
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
0 Counts in a Make-Table Query
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...- MarjiS
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Excel - Many sheets into one sheet
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...- MarjiS
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
