windows

Hi, i need the code for changing regional settings in windows environment: 1. Check what regional settings are used 2. If RS are Windows default (in my case polish -pl) - change to US (United States) 3. If US - change to windows defaults. Cross posted here...

We're moving from Windows 7 Pro to Windows 10 Enterprise. I'd like code in my workbook to work under either environment, meaning I need to determine which environment a user is in and adapt my code accordingly. Thoughts?

Hi all, I'm trying to change the "automatic" font colour to my company standard colour in Excel 2016. It seems it used to be possible to set this colour in Windows "Personalise" in previous versions of Windows, but Windows 10 works differently and doesn't allow this any more. VBA seems to think...

Hi My computer OS is 64-bit, windows 10. My excel is 365. When I tried =INFO("OSVERSION") I got <tbody> Windows (32-bit) NT 10.00 </tbody> Why is that? thank you very much.

Is there a software or web-service where you can verify that your macro is running smooth on different version of Excel and also on different platforms? I just wrote a Macro that works on Windows, but on my Mac. However, Excel on on Mac is very unstable all together so I want some third party...

Hi, I have a spreadsheet written in Excel 2013 in Windows 7 at 1920x1080 with a userform that fits my screen perfectly (Height = 725, Width = 1161). Recently installed Excel 2016 in Windows 10 and ran the userform and it's quite a bit larger - so much so that information on the bottom of the...

I have been using this spreadsheet, which contains various Macros, for at least 5 years using Office 2010 running on Windows 7 64 without issue. Now when I try to run the macros with Office 2010 running Windows 10 64 pro, I am getting an error" The Picture is too large and will be truncated."...

I am using the a worksheet change macro to speed up entering totals of different denominations of currencies in around thirty cash counters. The code of the worksheet change macro is as under: '======================================================== Private Sub Worksheet_Change(ByVal Target...

XL 2010 workbook opens with three windows configured (location on screen and size) as they were when the workbook is saved. XL 365 opens with three equally sized windows in the middle of the screen. Tried fiddling with Windows object and indexing but read somewhere that, for example, indexing...

I need to be able to select between windows used in home remolding. I have several GIF images that I would like to scroll through and I want to use their file names in the bill of material. I also want to know if there is a way to change the aspect ratio based on the window's dimensions. My...

Hi, I am wondering if anyone can help me. Today I have upgraded from windows 7 to windows 10 and all the macro enabled worksheets I have previously used have stopped working. It looks like they seem to error around sorting data. I have also noted that when I record a macro and review the code...

Hi all, I am having some problems with the following VBA code to color some objects and add a screentip. The code works fine on my Excel 2016 (Windows), but it does not work on Excel 2010 (Windows) (It gives Run Time Error 5) However, I need to make sure that this code can work for Excel...

im looking for a formula that returns two seperate values based on two different texts in other columns e.g <tbody> £10 £15 Product Cost Windows 10 Windows & Doors 15 Windows 10 </tbody> I then need to be able to sum the total cost Thanks

I've made a workbook in Excel (obviously) on my Mac, saved as a xls document and emailed it as an attachment. When it is opened on a windows pc (Excel 2007) it isn't displaying or functioning correctly even with macros enabled. For example I have in cell drop-down menus which aren't...

Hello, Is there a way to retrieve the Windows Release Id? Current releasid in my case being 1803, previous was 1709 and now coming up is probably 1810 or possibly 1811. My current version is 17134 but Winver says 17134.345. Any ideas on how to retrieve the last three figures? /nils

I have a very strange issue going on as follows: If I open a workbook, a "mystery" sheet opens up shortly after I open the workbook. If I close the mystery workbook, it closes the original file I opened up. There are no cells displayed and the ribbon is not displayed in the mystery workbook...

Hi, We have a huge problem with running macros in Excel 2010 on Windows 10. In macro settings we marked option "Disable all macros except digitally signed macros". We are using Certificate for Digital Signature and because of that we want to run just digitaly signed macros. I setup all...

i want to use VBA to search files in Windows 10 for a keyword and return matching documents as a list. Also the windows search facility I always find buggy, but i am not sure why thank you

Hi All, I'm using windows 10 with Excel 2016, where I'm trying to import information from another *.xlsx file. Real basic stuff, however I'm getting errors like crazy. Can anyone help? I feel like Windows 10 has robbed me! Thanks, Pinaceous

Hi there, I was recently updated to Windows 10 frm Windows 7 at work. My co-worker and I share a spread sheet in which we have to input info and refresh. All was well until I was updated. The problem lies in the date format. In Windows 7 the existing power query using date.to.text fuction is...