Recent content by eAlchemist

OK, so how do I strip out the header? I know how to re-write the file line by line, but how do I just delete a line in the file? Thanks, Chris

I have a problem that I've been wrestling with... I get a number of large text files (variable number of files ranging in size from 30-50MB) from clients that I need to concatenate together. They're all in the same format, but they all have column headers in them, so I can't simply copy the...

You might consider Option Explicit, then the debug will catch these sort of misspellings. Chris

I have some code that opens an Excel file, and among other things removes quotation marks from the file. I set display alerts to false, but when it doesn't find a quote, I still get a message box letting me know. Anyone have any ideas on how to suppress this? Here is a snippet of the code...

That was a mistake in my copying it. It's correct as "Sales Index" in both places. Thanks, Chris

Can someone tell me why this line of code comes back with a Run-time error 1004 when I run it? It doesn't error out when I run it in the immediate window Sheets("Sales Index").Range(Cells(3, 56), Cells(Sheets("SalesIndex").Range("A2").SpecialCells(xlLastCell).Row, 107)).Select

Private Sub reqYes_Change() If reqYes Then reqNo = False reqAttendees.Enabled = True End If End Sub Private Sub reqNo_Change() If reqNo Then reqYes = False reqAttendees.Enabled = False End If End Sub Private Sub ScheduleDate_Exit()...

What I was actually looking for was something that will transfer the array in one operation, not one line. This would still require looping through the array, would it not? I was thinking something more like the way this works for the whole array...

I know how to assign a whole array to a range in Excel. Is there a way to assign a contiguos range of values within an array into a range of cells? I know that I can do it with a loop, but I'm wondering if I can do it in one line. Thanks, Chris P.S. I accidentally listed this in the MS...

I know how to assign a whole array to a range in Excel. Is there a way to assign a contiguos range of values within an array into a range of cells? I know that I can do it with a loop, but I'm wondering if I can do it in one line. Thanks, Chris

And thanks for all the help you've provided over the years PHV!!!

Sure enough. It was the aliases. Thanks Skip!!

I don't think it's the double quotes (and no, qry_Cost.Year is not numeric), as I'm using the same criteria elsewhere with no problem. Could it be the aliases? That doesn't make sense to me, but I guess I'll try it. Why would this work in Access, but not in ADO? Thanks, Chris

I keep getting a runtime error: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. The query works fine if I paste it in Access, but won't work through ADO. I can't, for the life of me, figure out what the problem...

lameid was spot on. Thanks for the help! Chris