Search results for query: *

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

I'm trying to copy a filtered table to another worksheet. I only want to copy the filtered rows, but I also want the formulas to reference the new table, not the old table. From what I've seen, the only to copy formulas from one table to a new table correctly is to use PasteSpecial...

One annoyance for me is not being able to delete a table row when the table is filtered and there's another table occupying the same row on that same worksheet. So I was going to write a macro to do this for me. I searched the internet and couldn't find another solution so of course I came...

mintjulep it's funny you mention that. There's another software program that I use occasionally that has that built into their Excel reports and I was wondering how to build one. Thanks!! Thanks!! Matt

To all, I don't really know what's best with regards to the user interface. There's things that are duplicated on each page albeit customized. Thinks like clearing out preexisting data and resetting formatting. Or making a connection to python (opening up a cmd window and setting the port...

SkipVought, So what this is is a customized front-end interface for a pipeline modeling program. What this does for me is allows me to 'expose' inputs and outputs for the software, rather than having to dig through all the menus and dialog boxes and stuff in the software itself. Excel is much...