Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂
Enabling macro in trust center
Under the Trusted Center, Macro Settings and Macro Settings dialog the “Enable VBA Macros” has been selected along with “Enable Excel 4.0 macros when VBA macros are enabled” has selected. Along with this I am using the Personal.XLSB file to hold the macros. I have attempted multiple times to enable the macros within the workbook with no success. I first open the Personal file then the workbook of interest. Upon opening I do not receive a header to enable the macros. I then attempt to run a macro and continuously receive the error message that I must enable the macro and reopen the workbook.
📣 ExcelAt40 – Days 5 to 10 Recap
Hello Excel Community 👋 I’ve been running a daily series called #ExcelAt40, celebrating 40 years of Microsoft Excel through stories, innovations, and personal reflections. Here’s a recap of Days 5 to 10 — each post dives into a pivotal moment in Excel’s evolution: Day 5: Charting the Future Before dashboards ruled the world, Excel gave us the power to visualize data with clarity https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-5-charting-the-future-activity-7364386306572828673-dpj8 🧠 Day 6: Formulas That Changed Everything From =SUM() to =XLOOKUP, Excel taught us how to reason with logic. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-formulas-that-changed-everything-activity-7364968873474908161-PGNb 📈 Day 7: PivotTables Debut Celebrating Professor Pito Salas, the visionary behind dynamic data analysis. https://www.linkedin.com/posts/olufemi-olamoyegun_day-7-pivottables-debut-activity-7366077860282896384-euqr 🧬 Day 8: VBA Rises In 1997, Excel unlocked automation with Visual Basic for Applications. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-8-vba-rises-activity-7366342708942008320-yJL7 🧩 Day 9: The Ribbon UI Revolution Excel 2007 introduced the Ribbon a bold redesign that changed how we work. https://www.linkedin.com/posts/olufemi-olamoyegun_day-9-the-ribbon-ui-revolution-activity-7367783381973053440-I-KK 🛡️ Day 10: Y2K Audits Excel’s role in averting global disaster during the Y2K crisis. https://www.linkedin.com/posts/olufemi-olamoyegun_y2k-audits-activity-7367795370120187904-5ewY I will love to hear your thoughts: 💬 Which Excel feature changed the way you work? 📌 What’s your favorite moment in spreadsheet history? Let’s celebrate the legacy together. #ExcelAt40 #MicrosoftExcel #OlufemiBuilds #NoCode #TechLegacy #ExcelCommunity
Automatic overtime scheduling
hello all, I am looking to automate my companies overtime scheduling. Overtime is awarded based on 3 criteria. First, hours worked (less hours get priority), department (ex: a press operator signing up for a press position will get priority over a packager signing up for the same position), and finally seniority (start date with the company). Where do I start? There are no good youtube videos for this specific issue.
How to split Excel worksheet into multiple files?
Hi, How do I split an Excel worksheet with 10,000+ rows into multiple Excel files based on the values in column D via a Macro/VBA? The file has 9 columns (A:I), I also need the split files to automatically save in a specified folder. Thanks! https://superuser.com/questions/tagged/microsoft-excel https://superuser.com/questions/tagged/vba https://superuser.com/questions/tagged/macros
Switch Panes Using F6 not working
I am using split panes to type a formula and I want to reference something from the top of the worksheet. When I press F6 to send me to the top pane, instead, it is sending me to the bar on the bottom of excel and the top ribbon. It is so frustrating because this worked for me before and now it is not working and is slowing me down greatly. I was wondering if anyone could help? Thank you.CreateObject("Outlook.Application") with New Outlook
Hello, I've just noticed that when using the New Outlook, the VBA command CreateObject("Outlook.Application") generates the following error: "-2146959355 (80080005) Server execution failed". Am I the only one experiencing this issue? Or is there a need to modify the command? This works perfectly fine on the classic version of Outlook. Thank you in advance
Macro Error for Pivot Table
I can create a Pivot Table for the data I download and it works fine. However, when I made a Macro to do the same thing, I get an error. The error is: Run-time error '5': The following is a screenshot of the highlighted error in the Macro. I am now using Excel 2013, however I made an initial Macro using an older version of Excel and am now trying to make a pivot table using 2013 and installing it near the start of the existing Macro I have. How do I correct for this error?
