windows

Hello everyone. I currently run a VBA Macro that can take several hours. Previously I have never had a problem but I have just updated to Windows 10, and now when I come back to my PC I find that Excel has crashed and I am presented with recovery files. It seems that W10 is doing something...

Hello – <o:p></o:p> Thank you inadvance for any help anyone can provide. I have spent hours on this problem and I am sure it is simple...I just can't wrap my head around it...I am dangerous enough to have made a few cool things happen w/ Powerpivot and MBI, but not an expert lol. I will try to...

Hi I have 2 excel files A.xlsx and B.xlsx. I want to open them both in 2 different windows. Right now if I double click on A and then on B they will both open in the same window. I want them to open in different windows as different files. I have windows 10. Thanks Ps: what I did, i clicked...

I'm trying to create a new connection and import a text file so I can work with power query. I was expecting to see File Origin Delimiter 1252: Western European (Windows) ~ but I only see File Origin 1252: Western European (windows)...

Hello, Does anyone know the bug or problem where you get an error message (error 9 or 91) when you address a "window" or a "workbook" with a string like this? strFile = "NameOfWorkbook" Windows(strFile).visible = false Workbooks(strFile).Close The strange thing is, that this code is...

I have 3 x Worksheets. The master list is a Sheet called WINDOWS7MACHINES This contains a complete list of Windows 7 machines and only has one column called WIN7MACHINES which lists all the names of the machines running windows 7 WINDOWS10READY This is a list of machines i have picked out...

What is the cause of this error? run-time error '-2147012894 (80072ee2)': the operationg timed out With httpReq .Open "GET", matchURL, False .setRequestHeader "Host", "www.xxx.com" .setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64...

I need to count the number of windows that are hidden and display a pop-up window. My code keep giving me "0 hidden windows" no matter how many windows I've hidden, please help. Sub Hiddenwindows()Dim Cnt as Integer Dim Win as window Cnt=0 For each Win in Windows If Not Win.Visible then Cnt =...

I have a complex WB with a lot of Subs and Functions. It runs perfectly well time after time when run manually whether called manually or using Workbook_Open. However, when called from Windows tasks, it hangs. When it does this, Task Manager does not list Excel but trying to open the WB results...

Hi, I'm looking for recommendations for spreadsheet version control that works on both Windows and Apple operating systems. Found this provider: https://xltools.net/excel-version-control/ which does all required, but it's only compatible with Windows. Thank you in advance, Jack

Apologies in advance if I don't articulate this clearly. I'm not sure I understand myself exactly how to say describe it. I have 3 tables, one in each column (A-C below) I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is...

This post is regarding the addition of tags to spreadsheets on Macs vs Windows, Excel 2016. For my Excel Spreadsheet class, one of our directions after every assignment is to add some words in the 'tags' section based on the assignment. When I create a spreadsheet on my desktop, which has...

Hi - I am trying to come up with a formula for R15. The variables I know are P15 and Q15. P15 will refer to the values in column D and I need to find values in the columns where Q15 falls between, so, in this case, we'd be looking at column H. 621 is less than 650, but greater than 600. I've...

Hello, I have recorded a macro to sort each column alphabetically in a workbook. It works perfectly on our 2 computers that are windows 10 but not on the windows 7 computer. Below is the macro. Is this a common problem? Sub SuburbSort() ' ' SuburbSort Macro ' ' Columns("A:A").Select...

We just converted 5 of 6 PCs From Excel 10 to Excel 16 and also Windows 7 to Windows 10. Both the old and new PCs are 64 bit operating systems. Most of the Excel files use code for a variety of routine tasks. There are lots of loops and fairly large files. We are running on a network, but...

Hello everyone, I have been working on a Excel/Vba project for a few months, but recently, this issue cropped up. When my file is opened on other computers, Windows Installer runs (right after clicking 'enable macros'). This isn't a huge problem so far, but I'd like to understand what is...

Until recently, I have been using Excel 2003 on a Windows 10 platform, but after a Windows 10 update the program Excel program shuts down whenever I try to enter data, notably when the cell contains a formula. I have unintstalled and then reinstalled the Excel 2003 but that didn't cure the...

I can't recall where I pasted it from last year, possibly here, but the macro below used to work sweetly. However it now fails consistently, placing '??' on the clipboard instead of the text in cell B3. <code>Sub CopyTrackDescrToClipbrd() ' Copies text contents of B3 in active TrackDataSheet...

I know this isn't an Excel question but something happened over the weekend where my computer won't restart. I get a message that there is something wrong with my C drive and it tries to fix it on the fly. However, I can a message that it can' be fixed and gives me some option. I do have the...