hangs

Hello~ This is driving me insane. Any help would be greatly appreciated. I have an MS Access Application that runs a relatively complex process of extracting data from certain Excel workbooks, performing several calculations, and then populating the results of the calculations in another...

I have a loop that goes through every xlxs & xlsm file in a SharePoint folder but every now and then it hangs while opening a random workbook. It can run fine most of the time but other times it hangs. This is the command I use to open the file: Workbooks.Open...

Windows 10, Excel 2016; This worked in Excel 2010 but hangs up in Excel 2016 after the ".WindowState = xlNormal" statement ant ",Top = 1" (but not always). Anyone know why? With ActiveWindow .WindowState = xlNormal .Top = 1 .Left = 1 .Height =...

I have linked our workbook to a small workbook containing pricing data. Nothing huge, a couple of tables, Maybe a thousand pieces of data in total. (4 tables, 50 rows by 50 columns each.) I could have done this simply using direct links, index/match, etc. And in my experience the update would...

The code below stops executing at the line: St2: Company = Work.Cells(1, 1).Value and hangs. This sub is part of a module with only one other sub that stores the input values (aquired through form Input_prop) in a worksheet: see line: Call Prop_write(Propnum).e. When entering the sub, the sheet...

Hi, I have a few spreadsheets specifically that hangs up my excel for about 30-60 secs every time I do a copy/cut and hangs again when I paste. It goes into "not responding" for a period of time and then resumes as per normal. The time it freezes is the same no matter how many cells I copy, it...

Hello, I am trying to adapt this code, which reads shell output. There are many different approaches how to do it, but this one adds unique feature - Excel does not hang while it waits for the console program to complete its execution. But I don't understand how to get the response. Here is my...