windows

  1. A

    How to import .msg e-mail files from a Windows folder directly into Excel?

    Hi, With my recent Windows 10 upgrade, it seems the File Explorer "preview pane" no longer works for .msg files... I was wonder if there is a way to import the data from Outlook files in a Windows folder directly into an Excel sheet. Basically, I would specify the path to the folder...
  2. V

    XMLHTTP Request - Macro works under Win 10, does not work under Win 7

    Hello, I'm trying to add an item to Sharepoint list from local excel file and I made a macro that works in Windows 10 but does not work under Windows 7. I get Http.status 500 (Internal Server error) in debug window when i execute macro on Windows 7. Anyone has a suggestion how to make this...
  3. I

    Windows 10 seems to be crashing VBA Macro whilst running

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

    Retrieving/Displaying Aggregated Data From Pre-Populated Single Field

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

    opening 2 excel files in different windows

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

    Power Query in excel 2016 issue importing text firl

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

    VBA: Problem when addressing Workbook or Window via String

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

    Need an excel formula to look at values on one Worksheet and only pull back the differences.

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

    help me ))) run-time error '-2147012894 (80072ee2)':

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

    count the number of hidden windows

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

    Workbook failing to complete when called from Windows tasks.

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

    Spreadsheet version control

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

    Copying a worksheet with tables and cross-joins - possible to do it?

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

    Excel 2016 Mac vs. Windows (Adding Tags)

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

    How to search in a grid, when you know 2 variables, kind of...

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

    Macro working in windows 10 but not windows 7

    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...
  17. auto.pilot

    Excel 16 & Windows 10 very slow

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

    Windows Installer when file opens

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

    Windows 10 has screwed my Excel 2003

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top