Recent content by MattGreer

I appreciate the feedback guys. I'll go the VBA route. I like programming better anyway. I feel like I have more control over what's going on, not to mention understanding it better! I wish Access had a way to rename columns when importing from CSV tho. Now, when that data gets...

In Access 365 I import data from a CSV file into a table "tblImport". I took the defaults when setting this up so tblImport fields match the column headers in the CSV file exactly. The fields are somewhat cryptic so I added text to the 'Description' field in the Table Design. I would like to...

Me too, that's why I just use CHR(34) in place of any quotes. ;) Thanks!! Matt

You also need a reference to the proper VBA library... In this case you need to set a reference to 'Microsoft Scripting Runtime'. Regardless, post the code you used so we can tell ya what's up. Thanks!! Matt

Not only that, but you wouldn't be able to have *any* information next to a table in Excel, because as I mentioned, attempting to delete a row in a filtered table causes Excel ask you to delete the *entire* row, not just the table row. A lot of times it makes sense to have other information on...

Of course. But the issue with deleting a row in a filtered table is if you leave the filters in place, Excel will delete the entire sheet row which may be undesirable if you have other tables/data on the same worksheet. Thanks!! Matt

If I read that code correctly, it looks like it deletes all the hidden rows? Perhaps I misunderstand. The point of my subroutine is to delete the active row (where the active cell is) in a filtered table without having to manually unfilter the table, delete the row, and then re-apply the...

Throw this in there for a "is this cell in a table" check: Function U_IsActiveCellInTable() As Boolean 'Function returns true if active cell is in a table and 'false if it isn't. Dim rngActiveCell On Error GoTo NotInTable Set rngActiveCell = ActiveCell...

When I filter a table and try to delete just that row, Excel always asks me if I want to delete the row on the entire worksheet. The only solution I know of is I have to clear the filters, delete that row in that table, and then re-apply the filters. I posted about this a while back and got my...

Excellent points, thank you Andy! Thanks!! Matt

I thought about using the Status Bar but it's a little too "hidden" for this for me. I can't speak for others but I don't look at the StatusBar that often although the MsgBox would prompt me to do so. I just use the Status Bar for messages for longer routines that have many automated steps or...

And, like always, right after I post and admit what I don't know, I figure out the answer... meh Application.InputBox will allow me to pop up a message/instruction, have the user do something in excel, and return a value to the InputBox. Documentation...

I think the tl;dr would be, how can I have Excel prompt me to take some action and then wait until I've completed the action? I'm writing a subroutine to re-sort columns in a table. I would like to be able to set it up such that the user (me) starts the macro and is prompted to click on a cell...

Hiya Skip! Hope you're doing well. :) I was disappointed that all the solutions I saw on the internet said essentially the same thing and none of them worked for me, so I posted the question here because of the outstanding expertise of the folks here. However, A few minutes after I posted my...

Oh man... is it not possible to do this then? Thanks!! Matt