Recent content by jmarkus

When I open a folder in Windows Explorer and have my view type set to medium, large or extra large icons, it will briefly display some old thumbnail images before refreshing itself and showing the correct, current thumbnail images. This will happen every time the view is refreshed. I have run...

This error occurs when I am running a java application in Windows 10. The main application works fine for both the normal user and the administrator accounts. There is a button to change some preferences in the application that when run as administrator also works correctly, but when run as a...

I took the 'easy' way out. Thought I could reduce to one line of code and not resort to copy, but moving on now: src.Sheets(Sht).ListObjects(tbl).ListColumns(col).DataBodyRange.Copy wba.Sheets(Sht).ListObjects(tbl).ListColumns(col).DataBodyRange.PasteSpecial (xlPasteValues) Jeff

Skip, I appreciate your straightforward-ness. My original enquiry was: So ultimately that is what I would like to do. I thought that I could populate one ListColumn.DataBody range from another, but I seem to get mixed up with hole DataBodyRanges, Ranges, Range.Values and all the other...

Because of the way I am trying to work with the data from old to new, it is possible that the two tables won't be identical, but they will have identical columns (e.g. the wbA workbook table might have additional columns not present in the src workbook table). That is why I am trying to set...

I have a blank structured table in one workbook and I wish to populate it column by column from another table in another workbook with the same sheet, table, column names. I tried this: wbA.Sheets(Sht).ListObjects(tbl).ListColumns(col).DataBodyRange.Value =...

Arrggghhh...it turns out there were extra spaces in the string that I couldn't see until I switched to a monospaced font! Once I accounted for the extra spaces, it made sense! Sigh... Thanks anyways. Jeff

Hi Skip, In my worksheet, I have column A of the table at the top of my post (I used the column B to test out and show what I want/expect but it doesn't exist on my sheet). As I mentioned, I don't want to process it into separate columns because the depth of the hierarchy is variable and I...

Skip, It's simply a parent/child hierarchy. If I use simple representations of each leaf of the tree, then Excel knows how to sort it correctly. However, once I substitute in various strings of different numbers and letters (and lengths) it doesn't know what to do. For Example: amh66304...

Hi, I have generated a table with a column that shows the hierarchy of part numbers. When I try to sort the column, it doesn't sort the way I would expect. I have delimiters ('>') to visually show the precedence and if I make a similar column with each field in a logical/same size way, I can...

@edfair I need external access from the work computer as well. @sbcsu I thought I could leave my basement router set up as an access point connected to my main router, but change to a static IP on the access point with a 10.XX.X.XX address, but I guess those 2 ideas are mutually exclusive...

I realize that my home network doesn't NEED static IP addresses, but it is already set up with multiple devices, remote access, etc which is based on static IP and I don't wan't to undo all of that to change my IP address range, so I was hoping there was another way. Thanks, J

My home network is based on 192.168.X.X, like most default router setups. I already have many devices on my home network which have been assigned static IP addresses on this network, so I don't want to mess with that. Unfortunately, now that I am working at home with my work computer, I have...

Thanks Paul, but in this case it isn't what I wanted. Sometimes the cells contain FormFields and sometimes they don't. I am only interested in the visible contents. Jeff

Ok, this is what I did and seems to work: If .cell(3, 4).Range.Fields.Count > 0 Then 'MsgBox ("Contains a field!") TrStr = .cell(3, 4).Range.Fields(1).Result 'MsgBox ("TrStr is " & TrStr & "and is " & Len(TrStr) & " long") End If If TrStr = "" Then TrStr = "Empty" Thanks, Jeff