responding

Hi, I have a VBA program that has multiple modules and basically it starts a userform on workbook_open event. Then it goes to a log on screen in the userform. Once a userlogs in the code checks credentials against database to make sure its legit then it goes through a subroutine which basically...

I created a database and placed it on a shared network where a typical day sees two users entering data into forms that each update the same table. They have both complained of this taking a long time, errors out, and/or get a "database not responding" message. In researching this I thought I...

Hi I've recently upgraded to Excel 2016. A webscraping programe written with 2007 stops working (not responding) with Excel 2016 It'll start to loop through a list of websites but just stops responding after 3 or 4. I've tried exporting the mod,saving as a non-macro workbook and importing the...

Guys. This is quite urgent, but I hope you can easily solve my problem. I try to put formula: =IF(AND(COUNTIF(AT!$B:$B;$B2)=0;$E2=List!$B$6);"X";IF(AND(COUNTIF(Closed;$E2)>0;SUMPRODUCT((AT!B:B=B2)*(AT!H:H=""))>0);"XX";"")) into VBA code like this to place that formula in multiple cells in...

I'm an experienced Excel user and troubleshooter, and I'm somewhat at my wits' end. Symptom: Click on many options in the Ribbon (most noticed, clicking on File) immediately pauses Excel and seconds later goes to not responding. I can replicate this on any Excel document of any version, as...

Hi Everyone, I have a problem with the excel file concerning Salary as fille attached beside https://drive.google.com/open?id=0B09aWVwPVw7FWUZOTHVkUEc0NVk I am trying: 1/ FORMAT PAINTER every collumn to others - ex: column R to S - for the first time, it takes very long to finish the action...

Hi all, Let's assume we want to get a pointer to a workbook opened in a second insatnce of excel and edit a cell .. we would normally use something like this : Sub Test() Dim wb As Workbook Set wb = GetObject("C:\MyBook.xls") wb.Worksheets(1).Range("a1").Value = 10 End Sub The...

Hi, I have a fairly large sheet with 350k+ rows and it failed to respond. I closed the program and before it closed asked me if I wanted to save I chose to save. Upon re-opening the sheet it opened in a "Compatibility Mode" and with just the top row with my column headings minus my filters. I...