office

Hello, I wonder if anyone can help me with a Macro issue. We have an Excel form with a Macro that automatically emails the workbook. The line of code that does this is ThisWorkbook.SendMail Range("Welcome!R3"), Range("Welcome!R6") Where R3 contains the email address to send the email and R6...

Hi Guys, I have installed the Microsoft office professional plus 2016 on my personal computer (with a subscription of course) and i signed for the insider. My question is: Is it different from the office 365 pro plus insider?? Curious, because i am using certain keyboard shortcuts like Alt+B+M...

Hi I am using Windows 10 with Office 2010 I want Excel to open to macro enabled template but where to put? Thanks

<tbody> =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card Credit"))*(YTD_GOOG_2019_CyberSource!$I$5:$I$500)) </tbody>

Hi folks. I've started to get this error with one specific wb that we've been running for over 12 months trouble free. Online search has come up with numerous possible reasons for this, but none that seem to fit my circumstances, just wondering if anyone here may have some further knowledge? I'm...

I was having problems with my mac and had to basically wipe it clean and start again. I sensibly saved all my files and docs etc. I stupidly forgot all about my MS Office suite. I really don't want to subscribe with a monthly fee. I really hate the online free versions. I can't find my key...

I know this is old news, but maybe someone knows a workaround for this error. I copy and paste up to 10,000 entries to an external program. I have reinstalled and tried every fix I've seen on the web. I simply cannot use excel with this error. I have had to switch over Open Office and it works...

I've been playing around trying to solve this, but not been able to structure my Countifs, and was wondering if someone could assist. I have data within a table in Excel 2016, and need to rank these. Table looks like this: Site Type Quantity Use Data In Main Report...

I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if I'm running Office 365 or not. I go to File --> Account --> About Excel, and it says "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit". Is this not...

Any pointer to connect a localhost service hosted on IISExpress with windows authentication from Office 365 VBA? Successfully tested example will a be great help where Authorization of Msxml2 Request is being set.

I have a command button in my workbook, which is used to resent a column of values back to zero. The button works on both me and my husband's computers (we both have office 365, fully up to date) and also works on my intern's computer (older - office 2010). However, it does not work on my...

Hi all I have an excel file open and in this file I have cells with a links to some .xlsm files that I would like to open. but recently I get a message saying... Microsoft Office Opening C:\ test\001,xlsm Some files can contain viruses or otherwise be harmful to your computer, It is...

Hello. In Excel Office 365, to create an Array formula- "Ctrl-Shift-Enter" is not making the formula work rather it produces the error code #VALUE ! - here is the formula- thank you in advance for your help on this...

My laptop Office suite has been recently updated. Office, i.e., Excel, in my virtual workspace has not been updated yet. My ComboBoxes in identical files only function completely in my virtual workspace where Office updates have not taken place. I copied a file over to my laptop (updated Excel)...

Dear Sir / Madam; I had my Laptop on service at STAPLES from Oct 2018 to Mar 2019 to “Update the Network Driver” Staples did an extremely bad job, andnow I cannot open any of my files (XL files or any of my User Forms). I asked Staples to install MS Office2010 (the ONLY CD I could find...

I am using Office 365 Business and my Excel file is on OneDrive. I want to share it to another staff but I do not want auto email sent to him. Is this possible Thanks

:confused: I have a fully functioning Excel 2007 spreadsheet with a few macros and VBA code utilised to achieve a result. A couple of days ago, I bought a new laptop and also bought Office 365 to install. I have done the installation of the Office application and now my macros/VBA are having...

Some time ago I subscribed to Office 365. I installed it without giving any thought to the VBA help files. Yesterday I realized that the VBA help files were not available so, following the instructions in Bill Jelen's book, I uninstalled Office, in order to re-installed it, expecting to see a...

I was sent a workbook that had macros selecting columns of varying length. The debugger showed me it did not like the selection (A1:A) Once I changed it to (A1:A1000) far more cells than I'll ever populate, the macro works fine. The question is why does my Office 2016 not like it but many...

Can someone help me out "sharing" a workbook without Office 365? If all four users have the desktop version of Excel 2016 and the file is on our network server, when the file is shared, can the users see the active cell of each of the other users? I believe I saw this in a demo of Office 365...