windows

I have been experiencing a problem with Excel, although before posting here about it, I thought I'd update my version of MS Office. I configured Windows (Windows 10, Office 2016) to update all MS products, not just windows. But still, my version of Excel is v.1812, which is dated to November...

Hi guys. I need to display one of my excel file on a big screen, but also need to show some data from our internal website. (In the website format, so no. Data connection is not an option) I tried messing with the Set objShell = CreateObject("Shell.Application"), but I could only find method...

I have a data feed that contains roughly 3500 rows. Columns are servername, OS, and multiple columns of software names. The data contains the version of software installed on each server. For example as below: <tbody> Servername OS Software1 Software2 Software3 server1 Windows Server 2008...

Hi everyone, I hope this is only a setup condition that someone identifies, but the transition from Windows 7 and Excel 2010 to Windows 10 and Excel 2016 has caused a lot of agita. For starters, environ("username") was not recognized (compile error Can't find project or library). Found out...

Hi, I'm looking to have an excel file in my windows startup group and have it run when windows loads. But I would like to have the code ONLY run once a day. So if the code has already run today don't run it again till it's loaded tomorrow. I can add a Power Pivot calculated column and have it...

Hello forum friends, I have an issue with the results of a DATEIF formula I am trying to build. I am receiving a result of $161.92 and it should be $50.06, so I am WAY off somewhere. I have included snapshots of the cells in question below. If anyone has any ideas, I will be grateful. Excel...

Hello forum friends, I am testing a workbook to make sure there are no errors and I am having problems figuring out why these two values are different when they should be exactly the same. If anyone has any ideas as to why, I will be very grateful. There are two columns on one worksheet...

I am starting to learn VBA. On this For/Next loop, I am stumped by one line of code: If myValue > 400 Then Range("F" & i).Value = myValue + 10 I get the first part: If myValue > 400 Then but I do not understand the second part: Range("F" & i).Value = myValue + 10 Why must I use...

Hello, I am trying very hard to find a solution to this but so far nothing works... how can I write a code for a macro that takes a chart or table or cell from Excel and uses it to create the respective Powerpoint slides? Anyone have experience with this? Furthermore, I am using Mac currently...

This appears to ONLY happen with Windows 10 Enterprise 64-bit. MS Office 2016 32-bit The problem is using a Password Char for a textbox. This Windows OS will not read characters in a masked textbox. Is there a way around that? If I remove the character mask then the textbox works fine. But...

I have a spreadsheet that retrieves data from a SQL server. I can get it to work in Windows but when I try it on the Mac it fails and when I get it working on the Mac it fails in Windows. Is there a way to create a connection that will work in either version? Windows has to be trusted...

Any idea why upgrading from Windows 7 pro to Windows 10 would break a passworded textbox? Yes, they checked the caps lock key. Every machine they upgraded now gets "The password was wrong, try again." Yes/No All machines (Win7 and Win10) are using MS Office Professional Plus 2016 32 bit...

How do i tell my code to run if the machine is windows 7 and above?

Hello guys, I have a few questions about excel on windows and on Mac. I have a file that has buttons in it, on windows they work fine but on MacOffice they wont work. I've read that ActiveX wont work so I have to use the form buttons. My question is. Activex buttons give me more options to...

I don't really have a question here, just wanted to share this experience, partially as a warning, but if you have any comments on how to improve, please post! Its a bit hard to describe but i'll try to simply. Its "complex and intricate"...and unfortunately "irregular and unpredictable" in...

I'm working on a small project in Excel (Office 365) where I'm starting to lose my mind, since code is behaving crazy! :banghead: The idea is to open two windows of same Excel workbook at the same time, side-by-side, with specific window dimensions. I prepared an example of new workbook...

Okay, my brain is cramping but I'm pretty sure this problem I'm having can be solved by someone a lot brighter than I am. The two columns in question, columns B & C, need to work together for my worksheet to be accurate. They need to be able to account for users who are younger than 70...

Good morning All I recently bought a new laptop. I have a excel sheet that checks for a companies name in a table then checks the date to see if the date is in the range I'm looking for eg. 2019. When I opened my table on my new computer my formulas all returned "0" instead of the values they...

Hello forum friends, I am having an issue with a formula that I need to modify. I think I am missing an IF statement? Not sure. I know that this is going to be a fairly complex formula and I will be grateful for any help that I receive. The formula in question resides on the 'income analysis'...

Good morning, I have a problem with a macro that runs in windows 7 but on windows 10 it runs with a small problem. Macro: Sub XXX() ' ' Macro1 Macro 'Sheet of the activeworkbook that you want save as separated workbook Sheets("XXXXXXX").Copy Dim Path As String Dim...