windows

  1. L

    Can Excel VBA Windows run on Mac and vice versa?

    I have lots of Excel VBA applications developed on PC for the Windows platform (over the past 20 years). I have lots of trouble recently after Windows update - system very very unstable. I am thinking of ditching the Windows completely, and move all my development to iMac. Question: 1. Can...
  2. I

    How to use Windows regional date format in Excel vba

    Dear all, I have made a vba macro code to get date from Excel cells in a special format to be used for follow up. ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""ÅÅÅÅ-MM-DD"")" ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""YYYY-MM-DD"")" In Sweden, Windows regional date format is ÅÅÅÅ-MM-DD. The letter Å...
  3. A

    Control handle in SAP with VBA

    In our SAP system, we have a mass attack tool. There is one point at which my VBA cannot control the SAPgui anymore, it's when the "Select Files:" window appears (see screenshot). Yesterday I got a solution on how to find this window from a good man here in the Forum. The macro gave me all the...
  4. 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...
  5. 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)...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. Y

    Run code on windows 7 and above

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

Some videos you may like

This Week's Hot Topics

Top