Category: Microsoft
Category Archives: Microsoft
Style previews are totally unreadable
Im using Word Version 16.84 on a Mac. I am having major issues with the styles pane on both the ribbon and the right hand side box. It doesn’t matter what fonts I use, they refuse to show up properly. This is what I’m seeing.
Im using Word Version 16.84 on a Mac. I am having major issues with the styles pane on both the ribbon and the right hand side box. It doesn’t matter what fonts I use, they refuse to show up properly. This is what I’m seeing. Read More
How to Fix QuickBooks payroll is not working windows 10?
Troubleshooting Solutions: QuickBooks payroll is not working
QuickBooks Payroll is an essential tool for managing payroll tasks efficiently. When you encounter issues with QuickBooks Payroll is not working, it can disrupt your business operations. Here are some troubleshooting steps to resolve common QuickBooks Payroll issues:
Check Internet Connection: Ensure that you have a stable internet connection. QuickBooks Payroll requires an active internet connection to function properly. If your internet connection is unstable or disconnected, it can cause errors or interruptions during payroll processing.Update QuickBooks Payroll: Make sure that you are using the latest version of QuickBooks Payroll. Outdated software may contain bugs or compatibility issues that can lead to errors. Check for updates in QuickBooks and install any available updates to ensure that you are using the most recent version of the software.Verify Payroll Subscription: Double-check your payroll subscription status in QuickBooks. If your subscription has expired or is inactive, you may encounter errors when processing payroll. Renew your subscription if necessary to regain access to payroll features and resolve the issue.Review Employee Information: Check the accuracy of employee information entered in QuickBooks Payroll. Incorrect or incomplete employee details can cause errors during payroll processing. Ensure that all employee information, including tax withholdings and payment methods, is up to date and accurate.Run Payroll Updates: Run payroll updates in QuickBooks to ensure that tax tables and other payroll-related information are current. Outdated tax tables can lead to errors in payroll calculations. Running payroll updates regularly helps keep your payroll system accurate and compliant with tax regulations.Restart QuickBooks and Computer: Sometimes, simply restarting QuickBooks and your computer can resolve temporary glitches or issues. Close QuickBooks and any other applications running in the background, then restart your computer. After restarting, reopen QuickBooks and try accessing payroll features again to see if the issue persists.Run QuickBooks Repair Tool: If QuickBooks Payroll continues to experience issues, use the QuickBooks Repair Tool to diagnose and repair any software-related problems. The Repair Tool can fix common issues that may be causing QuickBooks Payroll to malfunction, helping you resolve the issue efficiently.Contact QuickBooks Support: If none of the above troubleshooting steps resolve the issue, contact QuickBooks customer support for assistance. QuickBooks experts can provide personalized support and guidance to help you troubleshoot and resolve complex payroll issues, ensuring smooth payroll processing for your business.
By following these troubleshooting solutions, you can address common QuickBooks Payroll not working issues and ensure that your payroll processing runs smoothly and efficiently. Regularly updating and maintaining your QuickBooks Payroll software is essential to prevent future issues and stay compliant with tax regulations.
Troubleshooting Solutions: QuickBooks payroll is not working QuickBooks Payroll is an essential tool for managing payroll tasks efficiently. When you encounter issues with QuickBooks Payroll is not working, it can disrupt your business operations. Here are some troubleshooting steps to resolve common QuickBooks Payroll issues: Check Internet Connection: Ensure that you have a stable internet connection. QuickBooks Payroll requires an active internet connection to function properly. If your internet connection is unstable or disconnected, it can cause errors or interruptions during payroll processing.Update QuickBooks Payroll: Make sure that you are using the latest version of QuickBooks Payroll. Outdated software may contain bugs or compatibility issues that can lead to errors. Check for updates in QuickBooks and install any available updates to ensure that you are using the most recent version of the software.Verify Payroll Subscription: Double-check your payroll subscription status in QuickBooks. If your subscription has expired or is inactive, you may encounter errors when processing payroll. Renew your subscription if necessary to regain access to payroll features and resolve the issue.Review Employee Information: Check the accuracy of employee information entered in QuickBooks Payroll. Incorrect or incomplete employee details can cause errors during payroll processing. Ensure that all employee information, including tax withholdings and payment methods, is up to date and accurate.Run Payroll Updates: Run payroll updates in QuickBooks to ensure that tax tables and other payroll-related information are current. Outdated tax tables can lead to errors in payroll calculations. Running payroll updates regularly helps keep your payroll system accurate and compliant with tax regulations.Restart QuickBooks and Computer: Sometimes, simply restarting QuickBooks and your computer can resolve temporary glitches or issues. Close QuickBooks and any other applications running in the background, then restart your computer. After restarting, reopen QuickBooks and try accessing payroll features again to see if the issue persists.Run QuickBooks Repair Tool: If QuickBooks Payroll continues to experience issues, use the QuickBooks Repair Tool to diagnose and repair any software-related problems. The Repair Tool can fix common issues that may be causing QuickBooks Payroll to malfunction, helping you resolve the issue efficiently.Contact QuickBooks Support: If none of the above troubleshooting steps resolve the issue, contact QuickBooks customer support for assistance. QuickBooks experts can provide personalized support and guidance to help you troubleshoot and resolve complex payroll issues, ensuring smooth payroll processing for your business.By following these troubleshooting solutions, you can address common QuickBooks Payroll not working issues and ensure that your payroll processing runs smoothly and efficiently. Regularly updating and maintaining your QuickBooks Payroll software is essential to prevent future issues and stay compliant with tax regulations. Read More
Excel Formula with INDEX returning #REF! error but cannot see why, checked everything
Excel Formula with INDEX returning #REF! error but cannot see why, checked everything
Excel Formula with INDEX returning #REF! error but cannot see why, checked everything Read More
Microsoft AI Partner Innovate, Brisbane, April 16 | Content now available
Hi everyone, I’m happy to share the content from the “Microsoft AI Partner Innovate” run in Brisbane on April 16. You’ll find 3 files here – one for each key segment – early morning, late morning, and after lunch.
Again it was so good to catchup with the partners, share learnings, gain insights and enjoy chatting about work and life.
I look forward to coming back to Brisbane, the Gold Coast and other parts of Queensland in the near future to help innovate further around Microsoft 365, the Copilots, Business Applications and Azure.
Regards, Phil
Hi everyone, I’m happy to share the content from the “Microsoft AI Partner Innovate” run in Brisbane on April 16. You’ll find 3 files here – one for each key segment – early morning, late morning, and after lunch.
Again it was so good to catchup with the partners, share learnings, gain insights and enjoy chatting about work and life.
I look forward to coming back to Brisbane, the Gold Coast and other parts of Queensland in the near future to help innovate further around Microsoft 365, the Copilots, Business Applications and Azure.
Regards, Phil Read More
SharePoint page is not loading in personal tab of app under MS Teams
Hello All,
I have created a Teams app and added a SharePoint page as a Teams personal tab.
I have referred to the below links for the same,
https://aakashbhardwaj619.github.io/2020/01/16/Add-SharePoint-Site-To-Teams-Personal-App.html
https://www.c-sharpcorner.com/article/sharepoint-site-as-static-app-in-ms-teams/
My SharePoint page is throwing an error in the Teams app. Please refer to the below screenshot,
Can anyone help me with the same?
Thanks
Hello All,I have created a Teams app and added a SharePoint page as a Teams personal tab.I have referred to the below links for the same,https://aakashbhardwaj619.github.io/2020/01/16/Add-SharePoint-Site-To-Teams-Personal-App.htmlhttps://www.c-sharpcorner.com/article/sharepoint-site-as-static-app-in-ms-teams/My SharePoint page is throwing an error in the Teams app. Please refer to the below screenshot,Can anyone help me with the same?Thanks Read More
Non-Delivery Report NDR delivered to Junk E-mail folder.
Non-Delivery Reports are critical for business. But in our Microsoft 365 tenant, NDRs are delivered to the Junk E-mail folder.
Only some users are affected. Others have no issue.
I logged the case with Microsoft, and the engineer said it is a bug. Microsoft is releasing a fix globally. But the issue has existed since the year 2023.
So far, no fix has been deployed by Microsoft.
Please advise.
Non-Delivery Reports are critical for business. But in our Microsoft 365 tenant, NDRs are delivered to the Junk E-mail folder.Only some users are affected. Others have no issue.I logged the case with Microsoft, and the engineer said it is a bug. Microsoft is releasing a fix globally. But the issue has existed since the year 2023.So far, no fix has been deployed by Microsoft.Please advise. Read More
Introducing Infra Copilot – Unleashing GitHub Copilot for Infrastructure as Code
Introduction
In the ever-evolving landscape of infrastructure management, the demand for efficient, scalable, and reliable solutions has never been higher. As organizations increasingly embrace cloud-native architectures and adopt Infrastructure as Code (IaC) principles, the role of infrastructure professionals has expanded, presenting new challenges in the development and maintenance of infrastructure configurations.
The Challenges Faced by Infrastructure Professionals
Complexity of IaC: Managing infrastructure through code introduces a layer of complexity. Infrastructure professionals often grapple with the intricate syntax and structure required by tools like Terraform and PowerShell. This complexity can lead to errors, delays, and increased cognitive load.
Consistency Across Environments: Achieving consistency across multiple environments—development, testing, and production—poses a significant challenge. Maintaining uniformity in configurations is crucial for ensuring the reliability and stability of the deployed infrastructure.
Learning Curve: The learning curve associated with IaC tools and languages can be steep for those new to the domain. As teams grow and diversify, onboarding members with varying levels of expertise becomes a hurdle.
Time-Consuming Development Cycles: Crafting infrastructure code manually is a time-consuming process. Infrastructure professionals often find themselves reinventing the wheel, writing boilerplate code, and handling repetitive tasks that could be automated.
Enter Infra Copilot
What is Infra Copilot?
In response to these challenges, Leveraging GitHub Copilot to generate infra code specifically for infrastructure professionals—Infra Copilot. Infra Copilot is helping to revolutionize the way infrastructure is written, addressing the pain points experienced by professionals in the field.
The Significance of Infra Copilot
Code Generation with Precision: Infra Copilot harnesses the power of machine learning to interpret the intent behind prompts and swiftly generate precise infrastructure code. It understands the context of infrastructure tasks, allowing professionals to express their requirements in natural language and receive corresponding code suggestions.
Streamlining the IaC Development Process: By automating the generation of infrastructure code, Infra Copilot significantly streamlines the IaC development process. Infrastructure professionals can now focus on higher-level design decisions and business logic rather than wrestling with syntax intricacies.
Consistency Across Environments and Projects: Infra Copilot ensures consistency across environments by generating standardized code snippets. Whether deploying resources in a development, testing, or production environment, Infra Copilot helps maintain uniformity in configurations.
Accelerating Onboarding and Learning: For new team members and those less familiar with IaC, Infra Copilot serves as an invaluable learning tool. It provides real-time examples and best practices, fostering a collaborative environment where knowledge is shared seamlessly.
Efficiency and Time Savings: The efficiency gains brought about by Infra Copilot are substantial. Infrastructure professionals can witness a dramatic reduction in development cycles, allowing for faster iteration and deployment of infrastructure changes.
Infra Copilot in Action
Prerequisites
1.Install visual studio code latest version – https://code.visualstudio.com/download
Have a GitHub Copilot license with a personal free trial or your company/enterprise GitHub account, install the Copilot extension, and sign in from Visual Studio Code. https://docs.github.com/en/copilot/quickstart
Install the PowerShell extension for VS Code, as we are going to use PowerShell for our IaC sample.
Below is the PowerShell code generated using VS Code & GitHub Copilot. It demonstrates how to create a simple Azure VM.
We’re employing a straightforward prompt with #, with the underlying code automatically generated within the VS Code editor.
Another example to create azure vm with vm scale set with minimum and maximum number of instance count. Prompt used with # in below example.
The PowerShell script generated above can be executed either from the local system or from the Azure Portal Cloud Shell. Similarly, we can create Terraform and devops code using this Infra Copilot.
Conclusion
In conclusion, Infra Copilot emerges as a game-changer in the realm of infrastructure as code, alleviating the challenges faced by professionals and ushering in a new era of efficiency and collaboration. As we wrap up our exploration of Infra Copilot’s capabilities, the preceding examples have provided insight into its features, supported technologies, and practical applications. This comprehensive guide aims to equip infrastructure professionals with the knowledge to enhance their IaC workflows effectively.
Microsoft Tech Community – Latest Blogs –Read More
beginner formula help
hi!
need some help.
I am trying to create a formula that will do the following
if answered yes then will calculate a percentage of another cell to equal a total number used to calculate commission.
for example if house loan is typed yes then the overall commission is x’s 40% to = net income made
hi! need some help. I am trying to create a formula that will do the following if answered yes then will calculate a percentage of another cell to equal a total number used to calculate commission. for example if house loan is typed yes then the overall commission is x’s 40% to = net income made Read More
How do I convert multiple PDFs to Word document without losing formatting (Windows11)?
I’m currently trying to convert multiple PDF into Word documents on Windows 11 while ensuring the original formatting is preserved. The PDFs feature a mix of text, images, and complex layouts that I need to maintain accurately in the Word format. Despite exploring various methods and tools to convert PDF to Word, I haven’t found a solution that consistently preserves the layout and elements across different documents. I’m seeking advice on software or techniques specifically adept at handling the conversion from PDF to Word without losing the integrity of the content. Any suggestions or recommendations would be greatly appreciated. Thank you!
I’m currently trying to convert multiple PDF into Word documents on Windows 11 while ensuring the original formatting is preserved. The PDFs feature a mix of text, images, and complex layouts that I need to maintain accurately in the Word format. Despite exploring various methods and tools to convert PDF to Word, I haven’t found a solution that consistently preserves the layout and elements across different documents. I’m seeking advice on software or techniques specifically adept at handling the conversion from PDF to Word without losing the integrity of the content. Any suggestions or recommendations would be greatly appreciated. Thank you! Read More
How to compare data fields with in customer tablle
select
Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone,
Other_Phone, email1, email2
from customer c
where Active=’Y’ — About 1.5 Million Records
Here in this sql server table, I have customers table, custno is unique id.
we are trying to grouping customers and give one ID lets call it groupingID.
INSERT INTO Customer (Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2)
VALUES
(1, ‘123 Main St’, ‘New York’, ‘123-456-7890’, ‘987-654-3210’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(2, ‘456 Elm St’, ‘Los Angeles’, ‘456-789-0123’, ‘012-345-6789’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(3, ‘123 Main St’, ‘New York’, ‘789-012-3456’, ‘234-567-8901’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(4, ‘321 Pine St’, ‘Houston’, ‘890-123-4567’, ‘345-678-9012’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(5, ‘654 Cedar St’, ‘Phoenix’, ‘901-234-5678’, ‘890-123-4567’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(6, ‘987 Maple St’, ‘Philadelphia’, ‘333-444-5555’, ‘567-890-1234’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444’, ‘555-666-7777′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(7, ‘210 Walnut St’, ‘San Antonio’, ‘123-456-7890’, ‘678-901-2345’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555’, ‘666-777-8888′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(8, ‘543 Birch St’, ‘San Diego’, ‘234-567-8901’, ‘789-012-3456’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(9, ‘876 Redwood St’, ‘Dallas’, ‘345-678-9012’, ‘890-123-4567’, ‘999-000-1111’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(10, ‘1091 Poplar St’, ‘Austin’, ‘456-789-0123’, ‘901-234-5678’, ‘000-111-2222’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(11, ‘121 Pineapple St’, ‘Seattle’, ‘567-890-1234’, ‘012-345-6789’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(12, ‘231 Cherry St’, ‘Portland’, ‘678-901-2345’, ‘123-456-7890’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(13, ‘344 Oakwood St’, ‘Miami’, ‘789-012-3456’, ‘234-567-8901’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(14, ‘456 Maplewood St’, ‘Tampa’, ‘890-123-4567’, ‘345-678-9012’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),
(15, ‘567 Pine St’, ‘Orlando’, ‘901-234-5678’, ‘456-789-0123’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’);
Custno 1 & 3 Adress & City match, custno3(faxphone) & custno6 (resphone) matching so these three records should match and get same groupid
custno2 record fields not match with any fields so that one will get one groupid.
custno4 & custno5 matches with res phone & business phone so these both reecords get same groupID
so any phone no filed matches with any other customers any other field consider as matched.
any email1 or email2 matched with any other customer email then all matched customer no get same groupID.
Please let me know if I need to provide any more information from myend.
Thank you in advance
selectCustno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone,Other_Phone, email1, email2from customer cwhere Active=’Y’ — About 1.5 Million RecordsHere in this sql server table, I have customers table, custno is unique id.we are trying to grouping customers and give one ID lets call it groupingID.INSERT INTO Customer (Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2)VALUES(1, ‘123 Main St’, ‘New York’, ‘123-456-7890’, ‘987-654-3210’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(2, ‘456 Elm St’, ‘Los Angeles’, ‘456-789-0123’, ‘012-345-6789’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(3, ‘123 Main St’, ‘New York’, ‘789-012-3456’, ‘234-567-8901’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(4, ‘321 Pine St’, ‘Houston’, ‘890-123-4567’, ‘345-678-9012’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(5, ‘654 Cedar St’, ‘Phoenix’, ‘901-234-5678’, ‘890-123-4567’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(6, ‘987 Maple St’, ‘Philadelphia’, ‘333-444-5555’, ‘567-890-1234’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444’, ‘555-666-7777′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(7, ‘210 Walnut St’, ‘San Antonio’, ‘123-456-7890’, ‘678-901-2345’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555’, ‘666-777-8888′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(8, ‘543 Birch St’, ‘San Diego’, ‘234-567-8901’, ‘789-012-3456’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(9, ‘876 Redwood St’, ‘Dallas’, ‘345-678-9012’, ‘890-123-4567’, ‘999-000-1111’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(10, ‘1091 Poplar St’, ‘Austin’, ‘456-789-0123’, ‘901-234-5678’, ‘000-111-2222’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(11, ‘121 Pineapple St’, ‘Seattle’, ‘567-890-1234’, ‘012-345-6789’, ‘111-222-3333’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(12, ‘231 Cherry St’, ‘Portland’, ‘678-901-2345’, ‘123-456-7890’, ‘222-333-4444’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(13, ‘344 Oakwood St’, ‘Miami’, ‘789-012-3456’, ‘234-567-8901’, ‘333-444-5555’, ‘666-777-8888’, ‘999-000-1111’, ‘222-333-4444′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(14, ‘456 Maplewood St’, ‘Tampa’, ‘890-123-4567’, ‘345-678-9012’, ‘444-555-6666’, ‘777-888-9999’, ‘000-111-2222’, ‘333-444-5555′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’),(15, ‘567 Pine St’, ‘Orlando’, ‘901-234-5678’, ‘456-789-0123’, ‘555-666-7777’, ‘888-999-0000’, ‘111-222-3333’, ‘444-555-6666′, ’email address removed for privacy reasons’, ’email address removed for privacy reasons’);Custno 1 & 3 Adress & City match, custno3(faxphone) & custno6 (resphone) matching so these three records should match and get same groupidcustno2 record fields not match with any fields so that one will get one groupid.custno4 & custno5 matches with res phone & business phone so these both reecords get same groupIDso any phone no filed matches with any other customers any other field consider as matched.any email1 or email2 matched with any other customer email then all matched customer no get same groupID.Please let me know if I need to provide any more information from myend.Thank you in advance Read More
Super Mario Song Powershell
function b($a,$b){
[console]::beep($a,$b)
}
function s($a){
sleep -m $a
}
write-host “Super Mario!”
b 660 100;
s 150;
b 660 100;
s 300;
b 660 100;
s 300;
b 510 100;
s 100;
b 660 100;
s 300;
b 770 100;
s 550;
b 380 100;
s 575;
b 510 100;
s 450;
b 380 100;
s 400;
b 320 100;
s 500;
b 440 100;
s 300;
b 480 80;
s 330;
b 450 100;
s 150;
b 430 100;
s 300;
b 380 100;
s 200;
b 660 80;
s 200;
b 760 50;
s 150;
b 860 100;
s 300;
b 700 80;
s 150;
b 760 50;
s 350;
b 660 80;
s 300;
b 520 80;
s 150;
b 580 80;
s 150;
b 480 80;
s 500;
b 510 100;
s 450;
b 380 100;
s 400;
b 320 100;
s 500;
b 440 100;
s 300;
b 480 80;
s 330;
b 450 100;
s 150;
b 430 100;
s 300;
b 380 100;
s 200;
b 660 80;
s 200;
b 760 50;
s 150;
b 860 100;
s 300;
b 700 80;
s 150;
b 760 50;
s 350;
b 660 80;
s 300;
b 520 80;
s 150;
b 580 80;
s 150;
b 480 80;
s 500;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 220;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 200;
s 300;
b 1020 80;
s 300;
b 1020 80;
s 150;
b 1020 80;
s 300;
b 380 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 420;
b 585 100;
s 450;
b 550 100;
s 420;
b 500 100;
s 360;
b 380 100;
s 300;
b 500 100;
s 300;
b 500 100;
s 150;
b 500 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 220;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 200;
s 300;
b 1020 80;
s 300;
b 1020 80;
s 150;
b 1020 80;
s 300;
b 380 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 420;
b 585 100;
s 450;
b 550 100;
s 420;
b 500 100;
s 360;
b 380 100;
s 300;
b 500 100;
s 300;
b 500 100;
s 150;
b 500 100;
s 300;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 350;
b 660 80;
s 150;
b 500 80;
s 300;
b 430 80;
s 150;
b 380 80;
s 600;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 150;
b 660 80;
s 550;
b 870 80;
s 325;
b 760 80;
s 600;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 350;
b 660 80;
s 150;
b 500 80;
s 300;
b 430 80;
s 150;
b 380 80;
s 600;
b 660 100;
s 150;
b 660 100;
s 300;
b 660 100;
s 300;
b 510 100;
s 100;
b 660 100;
s 300;
b 770 100;
s 550;
b 380 100;
s 575;
function b($a,$b){
[console]::beep($a,$b)
}
function s($a){
sleep -m $a
}
write-host “Super Mario!”
b 660 100;
s 150;
b 660 100;
s 300;
b 660 100;
s 300;
b 510 100;
s 100;
b 660 100;
s 300;
b 770 100;
s 550;
b 380 100;
s 575;
b 510 100;
s 450;
b 380 100;
s 400;
b 320 100;
s 500;
b 440 100;
s 300;
b 480 80;
s 330;
b 450 100;
s 150;
b 430 100;
s 300;
b 380 100;
s 200;
b 660 80;
s 200;
b 760 50;
s 150;
b 860 100;
s 300;
b 700 80;
s 150;
b 760 50;
s 350;
b 660 80;
s 300;
b 520 80;
s 150;
b 580 80;
s 150;
b 480 80;
s 500;
b 510 100;
s 450;
b 380 100;
s 400;
b 320 100;
s 500;
b 440 100;
s 300;
b 480 80;
s 330;
b 450 100;
s 150;
b 430 100;
s 300;
b 380 100;
s 200;
b 660 80;
s 200;
b 760 50;
s 150;
b 860 100;
s 300;
b 700 80;
s 150;
b 760 50;
s 350;
b 660 80;
s 300;
b 520 80;
s 150;
b 580 80;
s 150;
b 480 80;
s 500;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 220;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 200;
s 300;
b 1020 80;
s 300;
b 1020 80;
s 150;
b 1020 80;
s 300;
b 380 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 420;
b 585 100;
s 450;
b 550 100;
s 420;
b 500 100;
s 360;
b 380 100;
s 300;
b 500 100;
s 300;
b 500 100;
s 150;
b 500 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 220;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 200;
s 300;
b 1020 80;
s 300;
b 1020 80;
s 150;
b 1020 80;
s 300;
b 380 100;
s 300;
b 500 100;
s 300;
b 760 100;
s 100;
b 720 100;
s 150;
b 680 100;
s 150;
b 620 150;
s 300;
b 650 150;
s 300;
b 380 100;
s 150;
b 430 100;
s 150;
b 500 100;
s 300;
b 430 100;
s 150;
b 500 100;
s 100;
b 570 100;
s 420;
b 585 100;
s 450;
b 550 100;
s 420;
b 500 100;
s 360;
b 380 100;
s 300;
b 500 100;
s 300;
b 500 100;
s 150;
b 500 100;
s 300;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 350;
b 660 80;
s 150;
b 500 80;
s 300;
b 430 80;
s 150;
b 380 80;
s 600;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 150;
b 660 80;
s 550;
b 870 80;
s 325;
b 760 80;
s 600;
b 500 60;
s 150;
b 500 80;
s 300;
b 500 60;
s 350;
b 500 80;
s 150;
b 580 80;
s 350;
b 660 80;
s 150;
b 500 80;
s 300;
b 430 80;
s 150;
b 380 80;
s 600;
b 660 100;
s 150;
b 660 100;
s 300;
b 660 100;
s 300;
b 510 100;
s 100;
b 660 100;
s 300;
b 770 100;
s 550;
b 380 100;
s 575; Read More
Two meetings created where there should only be one
I just started deploying a reservation page that allows up to 85 people to attend a single service. It actually is training on a wide scale, and consists of five such Teams meetings spread over two weeks.
There is however a bug : most people registered correctly, but about 15% of attendees are registered under a different Teams meeting, even though the first meeting still has availability.
I would like to prevent a second meeting from being created. Right now, I have to check the “minor” meeting for a list of its attendees, and manually add attendees to the “major” meeting. Then, I cancel the “minor” meeting. But this second “minor” meeting ends up being created again a few hours later.
I plan on having about 500 attendees, so this is rather tiresome. Does anyone know how to prevent this?
I just started deploying a reservation page that allows up to 85 people to attend a single service. It actually is training on a wide scale, and consists of five such Teams meetings spread over two weeks.There is however a bug : most people registered correctly, but about 15% of attendees are registered under a different Teams meeting, even though the first meeting still has availability. I would like to prevent a second meeting from being created. Right now, I have to check the “minor” meeting for a list of its attendees, and manually add attendees to the “major” meeting. Then, I cancel the “minor” meeting. But this second “minor” meeting ends up being created again a few hours later. I plan on having about 500 attendees, so this is rather tiresome. Does anyone know how to prevent this? Read More
composeExtension with type “message” will not return text to compose message area with Messaging Ext
composeExtension with type “message” will not return text to compose message area with Messaging Extensions
I meet the same issue as “composeExtension with type “message” will not return text to compose message area with Messaging Extensions” . Could anyone please give some suggestions.
composeExtension with type “message” will not return text to compose message area with Messaging Extensions I meet the same issue as “composeExtension with type “message” will not return text to compose message area with Messaging Extensions” . Could anyone please give some suggestions. Read More
bing vision search API param ‘mkt’: ‘zh-CN’ does not take effect
we meet issue when accessing bing vision search API.
When we call the bing vision search API, specifying the market by adding the parameter {‘mkt’: ‘zh-CN’} as mentioned in https://learn.microsoft.com/zh-cn/bing/search-apis/bing-visual-search/reference/query-parameters, but the searching result returned does not fit Chinese market. The returned links in “hostPageUrl” cannot be accessed due to China local policy.
we meet issue when accessing bing vision search API.When we call the bing vision search API, specifying the market by adding the parameter {‘mkt’: ‘zh-CN’} as mentioned in https://learn.microsoft.com/zh-cn/bing/search-apis/bing-visual-search/reference/query-parameters, but the searching result returned does not fit Chinese market. The returned links in “hostPageUrl” cannot be accessed due to China local policy. Read More
Cannot enter dates in English (Australia) format
Hi,
I just spent about 1 hr with Microsoft 365 live chat and went around in circles without resolving the issue.
Here are the details:
– Using Mac Sonoma latest version with m3 max and excel (Microsoft 365)
– I have confirmed my Language and region settings are for Australia
I tried adding EXCEL to the customized Applications at the bottom but this didn’t change the results.
When I enter the Australia date format it reverts to USA format.
When dates start from ’13’ ie 13th June 2024 –> 13/6/24 they will display correctly because this would not work in USA format as 6/13/24 is an invalid date.
Hopefully someone out there has a fix for this.
Thanks!
Hi,I just spent about 1 hr with Microsoft 365 live chat and went around in circles without resolving the issue. Here are the details: – Using Mac Sonoma latest version with m3 max and excel (Microsoft 365)- I have confirmed my Language and region settings are for Australia I tried adding EXCEL to the customized Applications at the bottom but this didn’t change the results. When I enter the Australia date format it reverts to USA format. When dates start from ’13’ ie 13th June 2024 –> 13/6/24 they will display correctly because this would not work in USA format as 6/13/24 is an invalid date. Hopefully someone out there has a fix for this. Thanks! Read More
How to pin business locations using a city map in excel
Hello, I’m an average user on Excel. I’ve created a simple spreadsheet for our local historical society to enter business information from city directories with column headings of “business name,” “street address,” “city,” “state,” “business category” “owner(s)” and then several columns following with the years of the city directories. As business information is entered from each directory, the user simply enters an X in the corresponding year column. We would like to be able to see locations of these businesses on a city map by corresponding year. I was thinking that prompts for the user to choose a city directory year and another prompt for the user to choose a business category. Regarding the business category, I was also thinking about allowing the user to either choose 1 or any number of categories, along with the choice of all categories too. If that is possible? I’ve seen some videos about Map charts and I’m not sure if this would work or if something else would be more feasible. Any help would be greatly appreciated.
Thanks,
James
Hello, I’m an average user on Excel. I’ve created a simple spreadsheet for our local historical society to enter business information from city directories with column headings of “business name,” “street address,” “city,” “state,” “business category” “owner(s)” and then several columns following with the years of the city directories. As business information is entered from each directory, the user simply enters an X in the corresponding year column. We would like to be able to see locations of these businesses on a city map by corresponding year. I was thinking that prompts for the user to choose a city directory year and another prompt for the user to choose a business category. Regarding the business category, I was also thinking about allowing the user to either choose 1 or any number of categories, along with the choice of all categories too. If that is possible? I’ve seen some videos about Map charts and I’m not sure if this would work or if something else would be more feasible. Any help would be greatly appreciated.Thanks,James Read More
Can i Synchronize a network Drive with One Drive that synchronizes with Sharepoint?
Hello, We are currently working on a migrating Documents from Shared/Mapped network drive to SharePoint, we didnt use any tools for it as it was around 60GB we were able to just drag and drop all the folders,subfolders and documents. However, We have customers who regularly access the Mapped network drive and update documents in them, and add or move around documents during migration. So we are finding it hard to find what files they have to made changes or added, sorting it by date added every day until they start using Sharepoint is a uphill task as they are not used to Sharepoint and we need to train them use it. I have few questions here. The network drive that the dccuments currently is in is not sycnhronized to one drive, i did find that Onedrive and Sharepoint is able to sycnhronize, example if i create a folder or move folders i able to see One drive and Sharepoint synchronizing the structure(its not backed up but im able to access sharepoint via quick access section inside onedrive and see teh changes), now is there a way i could synchronize onedrive with the shared network drive so any changes in the network drive witll synchronize into onedrive and then those changes will reflect in sharepoint?
1. Is there a way i can synchronise Network drive (here Drive J: to One Drive, that would synchronise files in J>>Onedrive>>SharePoint, until the complete migration/traiing is done to co ordinate the changes?).
Very new to SharePoint Migration, Migration was pretty easy as we just dragged and dropped, but following up with changes and go back to find the changes is becoming tedious. Any help would be much appreciated.
Hello, We are currently working on a migrating Documents from Shared/Mapped network drive to SharePoint, we didnt use any tools for it as it was around 60GB we were able to just drag and drop all the folders,subfolders and documents. However, We have customers who regularly access the Mapped network drive and update documents in them, and add or move around documents during migration. So we are finding it hard to find what files they have to made changes or added, sorting it by date added every day until they start using Sharepoint is a uphill task as they are not used to Sharepoint and we need to train them use it. I have few questions here. The network drive that the dccuments currently is in is not sycnhronized to one drive, i did find that Onedrive and Sharepoint is able to sycnhronize, example if i create a folder or move folders i able to see One drive and Sharepoint synchronizing the structure(its not backed up but im able to access sharepoint via quick access section inside onedrive and see teh changes), now is there a way i could synchronize onedrive with the shared network drive so any changes in the network drive witll synchronize into onedrive and then those changes will reflect in sharepoint?1. Is there a way i can synchronise Network drive (here Drive J: to One Drive, that would synchronise files in J>>Onedrive>>SharePoint, until the complete migration/traiing is done to co ordinate the changes?). Very new to SharePoint Migration, Migration was pretty easy as we just dragged and dropped, but following up with changes and go back to find the changes is becoming tedious. Any help would be much appreciated. Read More
My VBA copies row if cell NOTBLANK but I need target columns in specific order (Code in post)
Windows 10
Excel 2019
In a workbook, I have two worksheets, “Track Data” and “Titles Data”.
In worksheet “Track Data”…
Columns A:J will always have data on each row and Column K may have data in some cells or will be blank
The code below looks at, and down, “Track Data” Column K and where it finds a cell WITH data, it copies Columns A. B, F, G, I, J, K and H to worksheet “Titles Data”, then moves on and does that same for every Cell in “K” that has data.
My issue is that I need the data it copies to “Track Data” to be placed in a specific order of Columns.
Like this.
Track Data Titles Data
Col. A to Col. A
Col. B to Col. B
Col. I to Col. C
Col. J to Col. D
Col. K to Col. E
Col. F to Col. F
Col. G to Col. G
Col. H to Col. H
The code is not mine, I found it on a different site while searching for a way to copy the rows but I have adapted it as best I can to suit my needs.
As this code replaces 1000s of rows of forumulas being entered by VBA and copied down (very slow), this code does the same task but with using formulas.
If there is a better (faster) way of doing this I would also be grateful for any suggestions.
Thank you in advance.
Option Explicit
Sub CopyRowsWithData()
Dim erow As Long, lastrow As Long, i As Long
Dim RngCopy As Range
Application.CutCopyMode = True
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
With Worksheets(“Track Data”)
lastrow = .Cells(.Rows.Count, 1).End(xlUp).Row
For i = 2 To lastrow
If Trim(.Cells(i, “K”).Value) <> “” Then
Set RngCopy = Application.Union(.Range(“A” & i), .Range(“B” & i), .Range(“I” & i), .Range(“J” & i), .Range(“K” & i), .Range(“F” & i), .Range(“G” & i), .Range(“H” & i))
RngCopy.Copy ‘ copy the Union range
‘ get next empty row in “Sheet2”
erow = Worksheets(“Titles Data”).Cells(Worksheets(“Titles Data”).Rows.Count, 1).End(xlUp).Offset(1, 0).Row
‘ paste in the next empty row
Worksheets(“Titles Data”).Range(“A” & erow).PasteSpecial xlPasteAll
End If
Next i
End With
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
Application.CutCopyMode = False
End Sub
Windows 10Excel 2019In a workbook, I have two worksheets, “Track Data” and “Titles Data”. In worksheet “Track Data”…Columns A:J will always have data on each row and Column K may have data in some cells or will be blankThe code below looks at, and down, “Track Data” Column K and where it finds a cell WITH data, it copies Columns A. B, F, G, I, J, K and H to worksheet “Titles Data”, then moves on and does that same for every Cell in “K” that has data. My issue is that I need the data it copies to “Track Data” to be placed in a specific order of Columns. Like this. Track Data Titles Data
Col. A to Col. A
Col. B to Col. B
Col. I to Col. C
Col. J to Col. D
Col. K to Col. E
Col. F to Col. F
Col. G to Col. G
Col. H to Col. H The code is not mine, I found it on a different site while searching for a way to copy the rows but I have adapted it as best I can to suit my needs. As this code replaces 1000s of rows of forumulas being entered by VBA and copied down (very slow), this code does the same task but with using formulas. If there is a better (faster) way of doing this I would also be grateful for any suggestions. Thank you in advance. Option Explicit
Sub CopyRowsWithData()
Dim erow As Long, lastrow As Long, i As Long
Dim RngCopy As Range
Application.CutCopyMode = True
With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableAnimations = False
End With
With Worksheets(“Track Data”)
lastrow = .Cells(.Rows.Count, 1).End(xlUp).Row
For i = 2 To lastrow
If Trim(.Cells(i, “K”).Value) <> “” Then
Set RngCopy = Application.Union(.Range(“A” & i), .Range(“B” & i), .Range(“I” & i), .Range(“J” & i), .Range(“K” & i), .Range(“F” & i), .Range(“G” & i), .Range(“H” & i))
RngCopy.Copy ‘ copy the Union range
‘ get next empty row in “Sheet2”
erow = Worksheets(“Titles Data”).Cells(Worksheets(“Titles Data”).Rows.Count, 1).End(xlUp).Offset(1, 0).Row
‘ paste in the next empty row
Worksheets(“Titles Data”).Range(“A” & erow).PasteSpecial xlPasteAll
End If
Next i
End With
With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableAnimations = True
End With
Application.CutCopyMode = False
End Sub Read More
Not able to fillup continuous dates using Autofill option or Fill handle.
I want to fill up the excel cells with continuous date but while using fill handle the date get repeated.
Here i want to continue dates to the following cells.
Now as i use fill handle to fill up the dates, the dates gets repeated.
I want to fill up the excel cells with continuous date but while using fill handle the date get repeated.Here i want continuous dates in the following cellsHere i want to continue dates to the following cells. Here you see that i used the fill handle but the dates gets repeated.Now as i use fill handle to fill up the dates, the dates gets repeated. Read More
Numeración de títulos de tablas
Hola, necesito ayuda para lograr que en la numeración de títulos de tablas se incluya el número de capitulo el número de tabla y una letra que identifique que parte de la tabla es ej. Tabla I-3a, Tabla I-3b.
Gracias de antemano por su ayuda.
Hola, necesito ayuda para lograr que en la numeración de títulos de tablas se incluya el número de capitulo el número de tabla y una letra que identifique que parte de la tabla es ej. Tabla I-3a, Tabla I-3b.Gracias de antemano por su ayuda. Read More