windows

  1. C

    Strange Windows error that only affect my Excel files

    I'm on Windows 10. When I'm working in Excel occasionally my screen starts flashing for about 1 minute (no pattern to when or why it happens ... it just randomly starts). During this time I can't click into any Excel cells or do anything in Excel. The other applications on my computer work fine...
  2. L

    excel macro file as windows associated program

    Hi All, I got to this forum after wondering the net for a solution to my problem, it's a little bit complex, I'll try to simplify it. I'd like to open specific ext. files (.SCF) on my windows system with specific excel file located in specific path on my pc (let's say C:\TEMP\SCFParser.xlsm)...
  3. K

    Excel VBA: WebBrowser Control Is Not Working In Windows 10

    Hi, I have a webbrowser control in a form, where a html files contents shows in it, it is working fine in windows 7, but I don't know it is not working in Windows 10. Code Not Working:- below code fires on click event of a button If Sheet1.CheckBoxes("chkMailBody").Value = 1 Then...
  4. N

    VBA To Send Email Not Working Since Windows 10 Update

    Good morning, Since upgrading to Windows 10 from Windows 7, my automated reports are not working. They run via Task Scheduler that simply opens the workbooks which call the associated Macros upon opening using the Workbook_Open option. They used to open, run, copy a range of cells, send an...
  5. P

    How to update Excel (or MS Office)

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

    VBA - Any way to cycle between excel window and browser window?

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

    Too many formulas, need a VBA solution for COUNTIFS

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

    Excel 2010 Macros not running in Excel 2016

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

    VBA to run a max of once a day

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

    need help with DATEIF formula

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

    Can't understand why two values are different

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

    Why does assignment needed to be on LEFT-hand side?

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

    Using Macros to Make Powerpoint Slides from Excel

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

    Windows 10 Enterprise / MS Office 2016 BUG!

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

    MS SQL connection that will work in Windows and Mac version of Excel Office 365.

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

    Upgraded to Windows 10 and broke passworded textbox

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

    Run code on windows 7 and above

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

    Excel from windows to MacOffice

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

    Musings on behavior of external references in cells in OneDrive shared workbook on Windows/Android

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

    Create New Excel Window - size and position are TOTALY WRONG!

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top