Search results for query: *

...disk cleanup, both under my normal user, and as administrator with "Files to delete"->"Thumbnails" checked. I have also deleted all the iconcache*.db and thumbcache*.db files from my C:\Users\username\AppData\Local\Microsoft\Windows\Explorer folder. The above 'fixes' don't change the...

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

Part way there. That will tell me if there is a field in the cell, how do I check if that field is empty or not? Jeff

Trim will remove whitespace, but it won't remove the field, so it still thinks that something is there when I try it. Jeff

I have a VBA macro which runs from Excel, opens a Word document and reads cells in a table in the Word document. I read the cell with the code: <code> TrStr = .cell(3, 4).Range.Text </code> I need to know if the cell is empty. Sometimes the cell contains a Text Form Field which is empty, but...

I tried that and got the message: The module "wshom.ocx" was loaded but the call to DllRegisterServer failed with error code 0x80040201

The error I get is: ActiveX component can't create object: 'GetObject' As for the language, this is VBscript as far as I know, I was just guessing that .NET might have something to do with it, but obviously I'm mistaken. Here is some more related code which comes before the Wscript line...