Tag: Microsoft

microsoft powerpoint – How: Convert Image Files from Screenshots of a Presentation to PPT – on Windows?

I’ve got a bunch of screenshots from some lengthy online presentations and do wish to pull some structured notes from them AS IS into PPT/X.

A manual copy or type would take a lot of time.

The presenter used a standard B&W so there’s not much in terms of distracting design.

Would prefer to replicate these screenshots as slides into PPT.

I presume it would require some kind of OCR of the images and some level of PPT layout/ structure/ bullets understanding by whatever way or steps its done.

Similar but how to commonly do it on windows?
Convert .png images into a .ppt presentation on Linux?

microsoft excel – Merge CSV Files Error 1004

So I am trying to make a macro that will merge multiple .csv files into one excel worksheet. I used the following tutorial for it:
vba code

However, once I put in the correct path to the .csv files, I get “Run-time error ‘1004: Sorryy we couldn’t find April2019.csv. Is it possible it was moved, renamed or deleted?” (April2019.csv is the first file in the folder).
So the macro obviously finds the right folder and the .csv file but then it stops and I have no idea why. I’ve been trying to change the code around a bit but it won’t work. The code below is what I am using at the moment, credits to Jie Jenn who made the tutorial.

Option Explicit

Dim wsMerge As Worksheet
Dim RowInsert As Long

Sub Merge_Files()
Const FolderPath As String = "H:DocumentsInvoices"

Dim Files As String
Dim wbTemp As Workbook
Dim LastRow As Long

Set wsMerge = ThisWorkbook.Worksheets("Merge")

RowInsert = 2

Files = Dir(FolderPath + "*.csv")

Do Until Files = ""
        
        Set wbTemp = Workbooks.Open(Files)
        
        With wbTemp.Worksheets(1)
        LastRow = .Cells(Rows.Count, "A").End(xlUp).Row
        
                .Range("A2:N" & LastRow).Copy
                wsMerge.Range("A" & RowInsert).PasteSpecial xlPasteValues
                
                Application.DisplayAlerts = False
                wbTemp.Close False
                Application.DisplayAlerts = True
                
                RowInsert = RowInsert + LastRow - 1
        End With
        
        Files = Dir()
Loop

MsgBox "File Merge Complete", vbInformation

End Sub

The error arrises when I “Set wbTemp = Workbooks.Open(Files)”

I hope this is enough context for the problem.

macbook pro – Issue with Microsoft Word on Mac

Hopefully, this is the right site for this. I am using a 2020 MacBook Pro and Word 2016. I am having issues opening a document sent by a friend. He is able to open it, and this problem does not occur when I try to open files that originated on my computer. When I try to open the document, I get the following error message:

Word experienced an error trying to open the file.
Try these suggestions.
* Check the file permissions for the document or drive.
* Make sure there is sufficient free memory and disk space.
* Open the file with the Text Recovery converter.

To resolve this, I tried having my friend paste the contents of the document into a new document, but I also wasn’t able to open that file. Here’s what I tried regarding the specific suggestions.

Check the file permissions for the document or drive.

I checked and the file is totally accessible, read-write enabled, Word has access to the folder it’s in (just the Desktop), etc.

Make sure there is sufficient free memory and disk space.

I just got a new computer and have 1.88 terabytes of space left, so definitely not a problem here.

Open the file with the Text Recovery converter.

In Word, I went to File>Open and selected the document. In the bottom-right corner of the window, I went to the drop-down that said “Open Original” and instead selected “Open Recover Text.” The file it produced is blank except for the words “Error serving file.” I also tried the “Open Repair” option in the drop-down menu, but that gave the same error as before.

Something else that might be relevant is that the files were sent through Slack, and the Slack preview worked on the document, but the Mac QuickLook preview does not work on the document (it just shows the document icon instead of a preview of the contents).

Any help would be greatly appreciated. Thanks!

office365 – Microsoft Forms or Google Forms quiz answers from spreadsheet, or some way to input all at once

Is there a way to have Microsoft Forms or Google Forms quizzes use an answer key from a spreadsheet or some other list that can be input all at once, instead of having to add an answer for each question one by one?
Creating questions from said list would also be good if possible.
I don’t need actual question content, just numbered multiple choice questions with answers associated with them from a list.
Right now just creating one question and duplicating it works for creating questions, but answers have to be done one by one.

Or an alternative service that supports it if neither of these services support it.

If really nothing exists, is there an API for these services I could use to try to do it programmatically for Office 365?
Google Apps Script Forms API would be the only choice I’m guessing.

privacy – How to contact Microsoft regarding security flaw?

Here I see:

If you believe you have found a security vulnerability that meets Microsoft’s definition of a security vulnerability, please submit the report to MSRC at https://msrc.microsoft.com/create-report

Also here:

We want to know about a security vulnerability as soon as you’ve found it.

But..

When signing into the create-report page (via google auth or MS account), it signs in as expected but signs out ~5 seconds later (using Chrome, also in Chrome incognito, and safari on macOS Catalina).

After signing out, it redirects to https://msrc.microsoft.com/create-report:

enter image description here

I have called MS’s tech support number (the call center did not come across as knowledgable about cyber security), and emailed bounty@microsoft.com, but have not received a reply.

How can one submit a bug report on a security vulnerability – is there a direct phone number for MS Cyber Security?

How to get consistent spacing from the body to the footer in Microsoft Word?

I am writing here to see if anyone can help me out with a spacing issue at the bottom of pages in Microsoft Word.

It appears that the spacing between the body and the footer changes on different pages. For example, sometimes Word allows an extra line of the body paragraph to fit onto the page while in other instances it simply pushes it onto the next page, thus making the spacing inconsistent across pages.

Is there any way to systematically make the spacing uniform by setting limits in the settings?

I’ve attached a few screenshots that demonstrate this inconsistency in spacing across pages to help show what I’m talking about.
Screenshot One

Screenshot Two

sharepoint list – Microsoft flow to trigger email when condition is met

Looking at the screenshot , when two fields are updating to ‘Yes’ in one go , both the conditions are resulting to true at the same time and the update action used after Send email action might conflicts due to which , when flow is running again after first email and before the second email , it is sending another email.

Try to use Switch condition instead of simple Condition you have used , where you write third condition in addition to above 2 conditions.

The condition will be –

Mail to be sent to Maths == ‘Yes’ and Mail to be sent to Science ==
‘Yes’ and IsmailsentMaths == ‘No’ and IsmailsentSci == ‘No’

By this, the flow will perform action for this third condition only and will not go to the two individual conditions for Maths and Science at the same time.

Refer this for how to use Switch in Flow.

windows 10 – Disable Microsoft Office Telemetry not working properly. Data Logging Locations very confusing

Due to the Data Privacy regulations in our Country we have been asked by management to disable Microsoft Office Pro Plus, 365, 2016 from sending Telemetry Data to Microsoft so i did the following as stated on the official website https://docs.microsoft.com/en-us/deployoffice/compat/manage-the-privacy-of-data-monitored-by-telemetry-in-office .

So I downloaded ADMX templates > Configuration > Administrative Templates > Microsoft Office 2016 > Telemetry Dashboard and did the following in order to disable Telemetry
Agent policy settings that disable logging

TO STOP LOGGING BY USING THE GROUP POLICY SETTINGS

Setting

Turn on telemetry data collection

Set this setting to Disabled to turn off data collection.

Turn on data uploading for Office Telemetry Agent

Set this setting to Disabled to stop uploading data to the shared folder.

According to Microsoft if logging is deactivated folder this %LocalAppData%MicrosoftOffice16.0Telemetry folder does not exit.
I double checked on one of our test clients and truly that path doesnt exist.

Nevertheless my attention was then drawn to another location %localappdata%MicrosoftOfficeOTele. Check out this article https://www.gruppenrichtlinien.de/artikel/office-20162019365-telemetrie-deaktivieren-disabletelemetry/

This location also logs some kind of Office Telemetry Data and it gets populated anytime office is active.
Is this location relevant? If so how do we stop it from logging office Data?

Reference link: https://social.technet.microsoft.com/Forums/office/en-US/f98dd521-fc45-4187-af30-f00031585f44/disable-microsoft-office-telemetry-not-working-properly-data-logging-locations-very-confusing?forum=Office2016ITPro#f98dd521-fc45-4187-af30-f00031585f44

microsoft excel – How to filter a column while the value in another column is constant?

I would like to have an Ascending filter on a column, but subsetted based on the value in another column. So for example, in column A I have 25 rows equal to 1, followed by 25 rows, equal to 2, followed by 25 rows equal to 3 and so on. Column D has either a 17 in it representing 2017 or a 16 in it representing 2016. I would like to put an ascending filter on D so that all the 2016 data is grouped, followed by the 2017 data, but only while whatever is in column A is the same. So while column A is 1, column D has several rows with a 16, followed by several rows with a 17. Once column A’s value changes to 2, column D’s filter would start again with 16’s followed by 17’s. I couldn’t find a way with filter to apply it within a repeating cycle.