Search results for query: *

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 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 =...

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...

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...

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 have a vbscript which works on my Windows 7 computer, but trips up on my colleague's. It throws an error at the following line: Set objShell = CreateObject("WScript.Shell") We both have Microsoft .NET Framework installed, although mine is 4.6.2 and his is 4.6.1 Is there some other...

Hello, I have a workbook with multiple sheets. Each sheet has a (different) code which is executed when I switch to that sheet. One of the sheets (A) has linked pictures in the first column. When I switch to sheet (B) I execute some code which, after populating the sheet with text values...

Hi, I'm using the following code to create a series of named range formulae: ImageRanges(TableSz) = "INDEX(PARTS!$E$5:$E$200,MATCH(BOM!$D$" & ImgRowNum & ",PARTS!$B$5:$B$200,0))" RangeNames(NItems) = "AsmImage" & NItems ActiveWorkbook.Names.Add Name:=RangeNames(NItems)...

Hello, I'm trying to make some VBA code work which scans a directory full of PPT files and opens them to perform some actions. The problem is that some of the PPT filenames have Japanese characters, so when I use the following code it substitutes '?' for each Japanese character and then cannot...

Sorry, I'm not sure if this is the right forum. I have a windows command script which adds "like-named" files (with an appended suffix) to a zip file. for %%f in (*.zip) do "c:\program files\7-zip\7z.exe" a %%~nf.zip %%~nf_SUFFIX001.pdf I now need to revise the script to accept similar...

I have some existing code (.vb) which contains a windows form, among other functions and routines. I would like to import the code into a project in Visual Studio so that I can take advantage of the tools, including the Windows Form Designer. When I create a new project, using "Project from...

I'm trying to present the user with a folder dialog to pick a destination directory when they click a button. I can't get the sub that handles this to show the dialog. I've stripped down my sub to just the following bare bones code and it still hangs and doesn't show the dialog. How can I...

I have a windows form with 2 group boxes. The first groupbox has 3 radio boxes which set an option when the user submits the form and the second groupbox has 2 radio boxes. When the form loads I can see the default radio button for each groupbox is pre-selected as intended, but as soon as I...

I've got a VB.NET application which I am working on which uses the Word spellchecking feature. I've tried numerous things to get the dialog box for the spellchecker to pop-up on top of all the other windows, but it doesn't work. Below is the code for the function which I have tried to make...

Hello, I have a VB.net application within a single .vb file which contains windows form code which was modified manually (despite the 'It can be modified using the Windows Form Designer. Do not modify it using the code editor.' message). I would like to somehow import this code into Visual...

I like to use Auto-filter in Excel 2013 to help filter the contents of a column so that I can get a quick look at all the unique entries. For example, I might have the following colours in my cells below the filter: red blue green yellow blue blue green red orange yellow If I click on the drop...

I would like to generate a Form using code based on a variable number of fields. Essentially I am creating code a simple dialog box which sometimes might have 5 fields and sometimes 15. Currently I only know how to manually set each field using: Me.TextBox1 = New...

I am trying to modify a form created in VB by someone else. I don't have Windows Form Designer or any other visual form editing software, I am doing it in code only. I added a GroupBox and 2 radiobuttons inside the group box, but I can't see them. If I put the drawing.point below the form, I...

I am trying to modify a form created in VB by someone else. I don't have Windows Form Designer or any other visual form editing software, I am doing it in code only. I added a GroupBox and 2 radiobuttons inside the group box, but I can't see them. If I put the drawing.point below the form, I...