Category: Microsoft
Category Archives: Microsoft
Adding assignee for subtasks in Microsoft To Do
Hi,
Will there be future plans for allowing to add assignee for subtasks in Microsoft To Do?
Hi, Will there be future plans for allowing to add assignee for subtasks in Microsoft To Do? Read More
How can I enter ABC in one text field and it should automatically write it in the second text field
How can I enter ABC in one text field and it should automatically write it in the second text field too.
How can I enter ABC in one text field and it should automatically write it in the second text field too. Read More
Conditional Access App Control keeps Bypassing
Hi all,
I’ve setup a Conditional Access policy in Entra ID with the following settings:
Targeted User: me (as a test)Targeted Resource: Office 365 (I’m interested specifically in SharePoint and OWA)Session Control: Use Conditional Access App Control > Custom Policy
I’ve then setup two policies in the Defender CAS service, one that prevents downloads and one that prevents Cut/Copy. I’ve not used the templates as I’d like to learn how to create these from scratch anyway.
The targets for both policies in CAS are simply App > Manual Onboarding > Microsoft Online Services. My understanding is that using “Microsoft Online Services” here should basically encompass all services I want. If I go to Settings in Defender Microsoft Exchange Online and Microsoft SharePoint both show as onboarded and enabled.
When I sign into one of these services, I can see it try and redirect me to the mcas.ms URL but then falls back to the original and the controls in my policies are not applied. If I check in the Activity Log my sign-ins show as “Bypass Session Control”.
Does anyone know what I might be missing?
TIA
Hi all, I’ve setup a Conditional Access policy in Entra ID with the following settings:Targeted User: me (as a test)Targeted Resource: Office 365 (I’m interested specifically in SharePoint and OWA)Session Control: Use Conditional Access App Control > Custom PolicyI’ve then setup two policies in the Defender CAS service, one that prevents downloads and one that prevents Cut/Copy. I’ve not used the templates as I’d like to learn how to create these from scratch anyway. The targets for both policies in CAS are simply App > Manual Onboarding > Microsoft Online Services. My understanding is that using “Microsoft Online Services” here should basically encompass all services I want. If I go to Settings in Defender Microsoft Exchange Online and Microsoft SharePoint both show as onboarded and enabled. When I sign into one of these services, I can see it try and redirect me to the mcas.ms URL but then falls back to the original and the controls in my policies are not applied. If I check in the Activity Log my sign-ins show as “Bypass Session Control”. Does anyone know what I might be missing? TIA Read More
#CONNECT! Error – Stockhistory down?
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn’t. I can change the time period, shorter or longer, and it just seems random when it decides to retrieve the data or not
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn’t. I can change the time period, shorter or longer, and it just seems random when it decides to retrieve the data or not Read More
How to get UserMeetingRole
Hi, we’ve got a tab app which needs to be able to find which of the users inside the meeting is the Organizer.
I see there is microsoftTeams.UserMeeringRole object with constants (Organizer, Attendee, etc).
However can’t find which API function returns this value?
This is essential because the organizer of the meeting needs to be able to access a few more actions and controls in the tab app.
Hi, we’ve got a tab app which needs to be able to find which of the users inside the meeting is the Organizer. I see there is microsoftTeams.UserMeeringRole object with constants (Organizer, Attendee, etc). However can’t find which API function returns this value? This is essential because the organizer of the meeting needs to be able to access a few more actions and controls in the tab app. Read More
VBA Code to Split Text
Hello,
My place of employee switched programs and there is currently not a way to extract data. I’m looking to insert a VBA code that splits the Job Title and Job Req # into seperate cells.
All job reqs start with a P. Here is a sample position/req.
Material HandlerP25-116021-2
Thank you!
Hello, My place of employee switched programs and there is currently not a way to extract data. I’m looking to insert a VBA code that splits the Job Title and Job Req # into seperate cells. All job reqs start with a P. Here is a sample position/req.Material HandlerP25-116021-2 Thank you! Read More
Uap16/17 BaseNamedObjectsIsolation
Some early feedback.
The latest Windows SDK includes a few new schema extensions. Documentation on these new extensions are not yet posted, and I assume that implementation is a work-in-progress and not released yet, but I am concerned that perhaps one of the items needs more thought before finalization.
Assuming that the new BasedNamedObjectsIsolation is an intended new feature to rename kernel named objects (like semaphores, mutexes, and other types) needed by software in the package, this would be a feature similar to that previously available via Microsoft App-V to help with running certain apps on multi-user operating systems or even multiple versions of the same app in parallel on a single user OS.
The schema for this element appears only to allow the specification to enable it for the package, and I am concerned that this is an insufficient level of control.
The equivalent feature in App-V included a system implemented (but registry editable) list of names to be excluded from the name spoofing. Furthermore, on a package basis the AppXManifest supported an override to include/exclude items.
The general system exclusion was a list of nearly 100 names. These exclusions were needed because the objects would also need to be recognized by name by an OS component that was not in the App-V container, so renaming one end would not work.
While Microsoft maintained this exclusion list (see HKEY_LOCAL_MACHINESOFTWAREMicrosoftAppVSubsystemObjExclusions) there was at least one time that IT Pros had to locally add to the exclusion list when Microsoft made a security change to RDS that broke almost half of App-V packages.
There was also a case where I helped a vendor with a package customization to the list because there were components in their package that ran outside of the App-V container (an out of process COM object) and needed to communicate using a name with a component running inside of the container.
Given that MSIX services might not be running inside the same container as the packaged app (I’m not sure about that) there might be more issues.
The bottom line is that there needs to be some exclusions applied somewhere, and overrides to the exclusion, at least on a system level, would be wise.
@Fiza_Azmi
Some early feedback.
The latest Windows SDK includes a few new schema extensions. Documentation on these new extensions are not yet posted, and I assume that implementation is a work-in-progress and not released yet, but I am concerned that perhaps one of the items needs more thought before finalization.
Assuming that the new BasedNamedObjectsIsolation is an intended new feature to rename kernel named objects (like semaphores, mutexes, and other types) needed by software in the package, this would be a feature similar to that previously available via Microsoft App-V to help with running certain apps on multi-user operating systems or even multiple versions of the same app in parallel on a single user OS.
The schema for this element appears only to allow the specification to enable it for the package, and I am concerned that this is an insufficient level of control.
The equivalent feature in App-V included a system implemented (but registry editable) list of names to be excluded from the name spoofing. Furthermore, on a package basis the AppXManifest supported an override to include/exclude items.
The general system exclusion was a list of nearly 100 names. These exclusions were needed because the objects would also need to be recognized by name by an OS component that was not in the App-V container, so renaming one end would not work.
While Microsoft maintained this exclusion list (see HKEY_LOCAL_MACHINESOFTWAREMicrosoftAppVSubsystemObjExclusions) there was at least one time that IT Pros had to locally add to the exclusion list when Microsoft made a security change to RDS that broke almost half of App-V packages.
There was also a case where I helped a vendor with a package customization to the list because there were components in their package that ran outside of the App-V container (an out of process COM object) and needed to communicate using a name with a component running inside of the container.
Given that MSIX services might not be running inside the same container as the packaged app (I’m not sure about that) there might be more issues.
The bottom line is that there needs to be some exclusions applied somewhere, and overrides to the exclusion, at least on a system level, would be wise. Read More
Add-Ons for Access 2019 (for PC)
Hello,
Today I search for some add-ons because there are none into my installed office 2019. So, I try it within Acces 2019 at settings, management. Oops… empty and nothing there to install.
Can anyone tell me how to get this add-ons into my system?
In previous Office (2007, 2009, 2013 and so on) they are installed at first installation.
Where or how can I get these COM and ACCESS add-ons???
By example: Analysis Toolpak, Analystis Toolpak – VBA, ASAP Utilities, Euro Currency Tools, Solution Add-Ons.
Thamks in advanced for your suggestions and help.
Hello,Today I search for some add-ons because there are none into my installed office 2019. So, I try it within Acces 2019 at settings, management. Oops… empty and nothing there to install.Can anyone tell me how to get this add-ons into my system?In previous Office (2007, 2009, 2013 and so on) they are installed at first installation.Where or how can I get these COM and ACCESS add-ons???By example: Analysis Toolpak, Analystis Toolpak – VBA, ASAP Utilities, Euro Currency Tools, Solution Add-Ons.Thamks in advanced for your suggestions and help. Read More
SQL and .net issue
Hi I am unable to see .mdf file in my visual studio when I opened one project of C# .Net in visual studio.
But same way the files are visible in data connections in YouTubers video.
I don’t have sql server installed and connected, is it happening due to this?
(I AM A BEGINNER PLS HELP IN THIS)
Hi I am unable to see .mdf file in my visual studio when I opened one project of C# .Net in visual studio.But same way the files are visible in data connections in YouTubers video. I don’t have sql server installed and connected, is it happening due to this? (I AM A BEGINNER PLS HELP IN THIS) Read More
Conditional Access Help
Hi –
Thought this would be easy but it’s not. We have a group of 5 temporary employees that need to access one custom built app in our environment. That app utilizes M365 authentication. I setup these users in a security group and want to block all access with the exclusion to this one app. The problem is, if I block Office 365, it does not allow them to login to the custom app. They get an error that blocks them, even though the app itself is excluded. I then exclude the app and Office 365 and it allows the login. This is frustrating because we cannot allow any access to Outlook, Sharepoint, OneDrive, etc. Any advice? When I try to search for just Exchange or Sharepoint by itself, there are no options to select under Cloud Apps.
Hi – Thought this would be easy but it’s not. We have a group of 5 temporary employees that need to access one custom built app in our environment. That app utilizes M365 authentication. I setup these users in a security group and want to block all access with the exclusion to this one app. The problem is, if I block Office 365, it does not allow them to login to the custom app. They get an error that blocks them, even though the app itself is excluded. I then exclude the app and Office 365 and it allows the login. This is frustrating because we cannot allow any access to Outlook, Sharepoint, OneDrive, etc. Any advice? When I try to search for just Exchange or Sharepoint by itself, there are no options to select under Cloud Apps. Read More
Unable to start Microsoft Defender for Endpoint Service. Error message: The service name is invalid.
I am trying to onboard Microsoft Defender for Business by using the onboarding script “WindowsDefenderATPLocalOnboardingScript.cmd”
As I use Admin to run it, it just shows “Unable to start Microsoft Defender for Endpoint Service. Error message: The Service name is invalid”
I tried to find the ATP service but I did not find the service has anything to do with “Windows Defender ATP”. Also I did not find the same Error message in the help document though we have the same error number.
I tried to reference the
for the solution, but it doesn’t work.
Output log:
C:WindowsSystem32>”D:DownloadsGatewayWindowsDefenderATPOnboardingPackage(3) WindowsDefenderATPLocalOnboardingScript.cmd” This script is used to enroll the machine in the Microsoft Defender for Endpoint service, including security and compliance products. Upon completion, the machine should light up in the portal within 5-30 minutes, depending on the availability of an Internet connection to the machine and the power status of the machine (plugged in vs. battery powered).
IMPORTANT: This script is optimized for single machine uploads and should not be used for large scale deployments. For more information on large-scale deployments, see the MDE documentation (link available in the Endpoint Upload section of the MDE portal).
Press (Y) to confirm and continue, or (N) to cancel and exit: y
Start the Microsoft Defender for Endpoint onboarding process…
Test Administrator Privileges
Scripts run with sufficient privileges
Perform the onboarding operation
Start the service (if not already running)
Microsoft Defender for Endpoint service is not yet started
Wait for the service to start
[Error ID: 15, Error Level: 1] Microsoft Defender for Endpoint Service could not be started. error message: The Service name is invalid.
For more information, please visit: https://go.microsoft.com/fwlink/p/?linkid=822
I am trying to onboard Microsoft Defender for Business by using the onboarding script “WindowsDefenderATPLocalOnboardingScript.cmd”As I use Admin to run it, it just shows “Unable to start Microsoft Defender for Endpoint Service. Error message: The Service name is invalid”I tried to find the ATP service but I did not find the service has anything to do with “Windows Defender ATP”. Also I did not find the same Error message in the help document though we have the same error number.I tried to reference thehttps://answers.microsoft.com/en-us/insider/forum/all/unable-to-start-microsoft-defender-for-endpoint/854aec41-ff21-4daa-8321- b7a4eb9ba5cdfor the solution, but it doesn’t work.Output log:C:WindowsSystem32>”D:DownloadsGatewayWindowsDefenderATPOnboardingPackage(3) WindowsDefenderATPLocalOnboardingScript.cmd” This script is used to enroll the machine in the Microsoft Defender for Endpoint service, including security and compliance products. Upon completion, the machine should light up in the portal within 5-30 minutes, depending on the availability of an Internet connection to the machine and the power status of the machine (plugged in vs. battery powered).IMPORTANT: This script is optimized for single machine uploads and should not be used for large scale deployments. For more information on large-scale deployments, see the MDE documentation (link available in the Endpoint Upload section of the MDE portal).Press (Y) to confirm and continue, or (N) to cancel and exit: yStart the Microsoft Defender for Endpoint onboarding process…Test Administrator PrivilegesScripts run with sufficient privilegesPerform the onboarding operationStart the service (if not already running)Microsoft Defender for Endpoint service is not yet startedWait for the service to start[Error ID: 15, Error Level: 1] Microsoft Defender for Endpoint Service could not be started. error message: The Service name is invalid.For more information, please visit: https://go.microsoft.com/fwlink/p/?linkid=822 Read More
DOES Not match SHA256 hash of WinDev2407Eval.VMWare.zip
Get a Windows 11 development environment
https://developer.microsoft.com/en-us/windows/downloads/virtual-machines/
DOES Not match the SHA256 hash of WinDev2407Eval.VMWare.zip
WELL ARE you recommend downloading to an internal HDD?
FOR THIS USED AN EXTERNAL USB STICK… Well? but not matching the sha256
Get a Windows 11 development environmenthttps://developer.microsoft.com/en-us/windows/downloads/virtual-machines/ DOES Not match the SHA256 hash of WinDev2407Eval.VMWare.zipWELL ARE you recommend downloading to an internal HDD? FOR THIS USED AN EXTERNAL USB STICK… Well? but not matching the sha256 Read More
)neDrive-Personal in Taskbar
A rectangle with an icon and label OneDrive-Personal has just appeared toward the right side my taskbar.
Can’t find anything about it in TaskBar Settings or with Google Search.
Anybody know how to get rid of it?
A rectangle with an icon and label OneDrive-Personal has just appeared toward the right side my taskbar. Can’t find anything about it in TaskBar Settings or with Google Search. Anybody know how to get rid of it? Read More
Excel- auto formula
Hii,
Is it possible auto formula in excel, i want to sum 20 rows with the image i entered same formula, or any other formula or options??
Thank you
Hii, Is it possible auto formula in excel, i want to sum 20 rows with the image i entered same formula, or any other formula or options?? Thank you Read More
Any Idea Why I Keep Getting These When Outlook Starts
Microsoft® Outlook® 2021 MSO (Version 2407 Build 16.0.17830.20056) 32-bit
I keep getting various warnings when I start Outlook:
Any idea as to what is going on?
Microsoft® Outlook® 2021 MSO (Version 2407 Build 16.0.17830.20056) 32-bit I keep getting various warnings when I start Outlook: Any idea as to what is going on? Read More
Vlookup9
Sub santo()
Dim LastRow As Long
Set ws = Worksheets(“Customer”)
LastRow = Cells.Find(“*”, , xlValues, , xlRows, xlPrevious).Row
wrk = Array(Worksheets(“MIDDLE_INITIAL”), Worksheets(“LAST_NAME”))
na = Array(“old”, “new”)
a = Array(“I”, “J”, “K”, “F”)
For j = 0 To 1
For i = 0 To 2
With ws
.Range(a(i) & “1”).EntireColumn.Insert
If i > 1 Then
.Range(a(i) & “1”).Value = na(j) + ” ” + “Fullname”
For b = 2 To LastRow
ws.Cells(b, a(2)).Value = ws.Cells(b, a(3)).Value + ” ” + ws.Cells(b, a(0)).Value + ” ” + ws.Cells(b, a(1)).Value
Next b
Else
.Range(a(i) & “1”).Value = na(j) + ” ” + Sheets(3 + i).Name
.Range(a(i) & “2”, a(i) & LastRow) = Application.WorksheetFunction.VLookup(ws.Range(“B2:B” & LastRow), wrk(j).Range(“A:F”), (6 + i), False)
.Range(a(i) & “2”, a(i) & LastRow).Replace what:=”#N/A”, Replacement:=” “
End If
End With
Next i
a = Array(“M”, “N”, “O”, “L”)
Next j
End Sub
Sub santo()
Dim LastRow As Long
Set ws = Worksheets(“Customer”)
LastRow = Cells.Find(“*”, , xlValues, , xlRows, xlPrevious).Row
wrk = Array(Worksheets(“MIDDLE_INITIAL”), Worksheets(“LAST_NAME”))
na = Array(“old”, “new”)
a = Array(“I”, “J”, “K”, “F”)
For j = 0 To 1
For i = 0 To 2
With ws
.Range(a(i) & “1”).EntireColumn.Insert
If i > 1 Then
.Range(a(i) & “1”).Value = na(j) + ” ” + “Fullname”
For b = 2 To LastRow
ws.Cells(b, a(2)).Value = ws.Cells(b, a(3)).Value + ” ” + ws.Cells(b, a(0)).Value + ” ” + ws.Cells(b, a(1)).Value
Next b
Else
.Range(a(i) & “1”).Value = na(j) + ” ” + Sheets(3 + i).Name
.Range(a(i) & “2”, a(i) & LastRow) = Application.WorksheetFunction.VLookup(ws.Range(“B2:B” & LastRow), wrk(j).Range(“A:F”), (6 + i), False)
.Range(a(i) & “2”, a(i) & LastRow).Replace what:=”#N/A”, Replacement:=” “
End If
End With
Next i
a = Array(“M”, “N”, “O”, “L”)
Next j
End Sub Read More
Mail merge with excel
I have created a mail merge letter that is meant to merge in dates taken from my excel spreadsheet. I have in there a statement that says something like, The start date of this event is “Date” to “Date”. Another words, Begin Date and End Date. The problem I have is the end date will not display or print the end date as a date. It will only show or print as numbers representing the date. I have tried switches to no avail. I’m pulling my hair out here. Anyone know how to fix this. I have my dates in the decline formatted as date and switches attached to the mail merge fields. Just can’t get it to show the dates I so desperately need. HELP
CARL
I have created a mail merge letter that is meant to merge in dates taken from my excel spreadsheet. I have in there a statement that says something like, The start date of this event is “Date” to “Date”. Another words, Begin Date and End Date. The problem I have is the end date will not display or print the end date as a date. It will only show or print as numbers representing the date. I have tried switches to no avail. I’m pulling my hair out here. Anyone know how to fix this. I have my dates in the decline formatted as date and switches attached to the mail merge fields. Just can’t get it to show the dates I so desperately need. HELP CARL Read More
TRANSLATE() function not available in Excel
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel.
My Specs:
Windows 11 ARM 64bit
Excel version 2409 Insider Beta Channel
OS and MS365 both fully updated.
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel. My Specs:Windows 11 ARM 64bitExcel version 2409 Insider Beta ChannelOS and MS365 both fully updated. Read More
Help w. Word Template Formatting
i have a template and there is a final piece i am unable to move/work with in word
help!
i have a template and there is a final piece i am unable to move/work with in wordhelp! Read More
Visual Search Documentation
Looking at the Visual Search documentation I see there’s a filter for URL selection:
The KnowledgeRequest object includes the following fields:
filters — A Filter object that you use to filter the results.site — The site filter returns similar images and similar products results from the specified site only.
Is there a way to format this site filter key with multiple URLs? If I would like to search multiple sites for a visual search match, do I need to make multiple queries?
Looking at the Visual Search documentation I see there’s a filter for URL selection:The KnowledgeRequest object includes the following fields:filters — A Filter object that you use to filter the results.site — The site filter returns similar images and similar products results from the specified site only.documentation here Is there a way to format this site filter key with multiple URLs? If I would like to search multiple sites for a visual search match, do I need to make multiple queries? Read More