KickStarter15 Posted October 8, 2020 Posted October 8, 2020 Hi Experts, I tried searching everywhere about my concern that would it be possible to view the excel sheet into the tabControl? I mean we have code for excel to GUI but could not find something for Reading the Excel sheet and view it in TabControl. I mean a specific sheet like "sheet 3" should be viewed in TabContol. I don't know how to start since I'm not really familiar with excel_UDF, so please🙏 let me know if you have any idea or link or any suggestions that can possibly be done. Note: I wasn't able to start anything yet coz I really don't know how to start.😅 Thanks, Experts. KS15 Programming is "To make it so simple that there are obviously no deficiencies" or "To make it so complicated that there are no obvious deficiencies" by C.A.R. Hoare.
seadoggie01 Posted October 8, 2020 Posted October 8, 2020 Are you trying to embed an Excel sheet into your GUI? If not, could you explain more of what you're attempting to do? All my code provided is Public Domain... but it may not work. Use it, change it, break it, whatever you want. Spoiler My Humble Contributions:Personal Function Documentation - A personal HelpFile for your functionsAcro.au3 UDF - Automating Acrobat ProToDo Finder - Find #ToDo: lines in your scriptsUI-SimpleWrappers UDF - Use UI Automation more Simply-erKeePass UDF - Automate KeePass, a password managerInputBoxes - Simple Input boxes for various variable types
water Posted October 8, 2020 Posted October 8, 2020 The search function is your friend I searched for "Excel worksheet embed" and got this. Don't know if it still works ... My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
KickStarter15 Posted October 10, 2020 Author Posted October 10, 2020 @seadoggie01, Im not trying to embed my Excel sheet into a GUI but what I want to do is to embed my Excel sheet into a TabItem (see below snippet). Each tab represents each sheet in my Excel. @water thanks for the link☺️ but i've got this below COM Error and nothing shows or happened. Programming is "To make it so simple that there are obviously no deficiencies" or "To make it so complicated that there are no obvious deficiencies" by C.A.R. Hoare.
water Posted October 10, 2020 Posted October 10, 2020 A Tab is an element in a GUI. The example is from 2008 so a lot might have changed in Excel or AutoIt since. I never used Excel in a GUI so I do not have any further ideas My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
seadoggie01 Posted October 10, 2020 Posted October 10, 2020 Can you show what code you've used (especially line 29)? I can test this on my computer to try a few things All my code provided is Public Domain... but it may not work. Use it, change it, break it, whatever you want. Spoiler My Humble Contributions:Personal Function Documentation - A personal HelpFile for your functionsAcro.au3 UDF - Automating Acrobat ProToDo Finder - Find #ToDo: lines in your scriptsUI-SimpleWrappers UDF - Use UI Automation more Simply-erKeePass UDF - Automate KeePass, a password managerInputBoxes - Simple Input boxes for various variable types
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now