office

I have a small .xlsm file which contains two simple macros and a VB module designed to return a 10-character hash from a character string using "=BASE64SHA1(A1)". I'm not skilled in VB so I simply found the code from a web site. The only mod I made was to set the length of the hash to 10...

A few years ago at a job I created a macro that would refresh a table and save the results to a network folder so it was ready to review when everyone got into the office. I was able to do this using Windows Scheduled Tasks. The one negative to this was that the computer had to be on and...

hi guys, not sure if the subject is correct in short: i want to scrape the following data from this website "Company Name" "Company Code" "Labor Office" here's the link http://eservices.mohre.gov.ae/NewMolGateway/english/Services/EQuotaStatus.aspx?Code=715280 note that i want to start 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 have the professional enterprise version of office 365 that I use for work. However I would like to purchase a home version with the full Power Query and Power Pivot capabilities. Does anyone know what version I should buy. Does it have to be a business version?

Hi all, I would like to use a VBA code so that to copy next to each earnings or deductions or contributions, the department which is in col. “C”. Therefore, that the rows are not stably and I present just an extract of data. There are also deductions & contributions. Below the original data and...

I am running office 365. I recorded a macro with a simple sort command. It ran fine on my machine. Crashed on machines using Office 10 Comparing the code I found only one difference. Add2 vs Add Have they changed VBA in the new version?

Good morning everybody. I have a spreadsheet which is made up of six identical, adjacent blocks of data, each of twenty columns or so. The structure of each block of data is identical. Within those six blocks of data, I need to be able to find a value (which can only appear once), and look up...

Okay, I feel embarrassed to even be asking such a seemingly simple question, but I just switched to Office 365 from Office 2013. Does anyone know how to change the Insert Picture default folder in Excel? I found it in the advanced options for Word, but haven't been able to find it anywhere in...

my excel workbook says it's locked for editing by "userxx" but that user doesn't have it open. is there a way to force the workbook to close using Windows 10 Microsoft office 365

Hello Bill Jelen (Mr. Excel), I bought "VBA and Macros for Microsoft Excel" almost 15 years ago and I have dragged the book with me for three continents during all this time. I feel the urgency of learning macros (again), but I am failing to download the project files. In all my laptops appear...

Hi All, Im new here to bear with me on the newbness. My question is the following. I used to LOVE and use a lot this in Office 2011 for Mac I could move the "print line" with the drag of my mouse to resize the print area or the area to save a PDF. I upgraded to Office 2019 (ver. 16.19) and it...

We have a flight school with about 600 students. There is a training department, a flight dispatch desk, business and financing office, and a couple of others. I want ant to create a relational database with excel ( each person is already familiar with excel) with several tables. I need...

I remember seeing a company that made this add-in for Office, but I can't seem to find it now.

Hello to everyone. I saw these new features on microsoft office web sites. Are not available yet? I Use office 2016(365). FILTER function RANDARRAY function SEQUENCE function SINGLE function SORT function SORTBY function UNIQUE function

Will office 2016 open 2007 office files? And will my macros still work? Thanks

Hello, I got this sample script from Microsoft office website, and it works great in saving attachments from selected e-mail. https://gallery.technet.microsoft.com/office/Save-attachments-from-5b6bf54b/view/Discussions/4 however, I want to include or have just subject of an e-mail as file...

Last year I created a spreadsheet with the following formula: =IF(ISBLANK(B20),"",B20*$E$9) entered under the services NOTE cell E9 = 600 <tbody> Qty Service Expenses Total 1 600 20 620 </tbody> =IF(OR(ISBLANK(B20)),"",(D20+E20)) entered under Total OK this has worked until I upgraded...