Great video thank you. Saves so much time trying to tweek the essentials out of the mass of documentation on the Internet. You had me worried at the end when you said VSTO is not available with Express editions 😂 but you do cover that in the video description. Thanks again.
Steve, I have a question. If I have an add-in (I made) in an Excel file and distribute this file to my customers, would they be able to run this add-in in that file (I gave them) automatically at open, without installing anything? People hate installing stuff. Thanks!!!
It says ThisAddIn does not contain a definition for GetActiveWorksheet and no accessible extension method accepting a first argument of type ThisAddin could be found.
Awesome Video , very good explanation. I have one more question regarding this , how to create MSI installer of this , if I want to install office addin on other machines ? Please help me out in this , that will be great help
You mention at the end of your helpful video that VSTO is not available in Community editions of Visual Studio. However I have Community 2017 and found it straightforward to go to Programs and Features on my control panel and install VSTO etc from there. Everything works fine.
It is available in community editions. it is not available in older express editions. This opens it up to a lot more developers.Thanks for pointing that out! I think I corrected that in the next video.
Hi, A suggestion: If I were you (and could do so) I would change the thumbnail for this video. There is an orange bar at the bottom of the thumbnail that looks like RUclips's process bar, which made me think that I have already checked this video until the end, which was of course not the case. :)
Hello sir, are you planning to publish more videos concerning this topic, it's an interesting one, do you recommend any course or channel that covers something like that? very useful video
3 года назад+1
Hello, thank you for sharing. 1-I created Exceladdin 1.sln with Visual studio 2019 and I know how to add a tab to the excel program on my computer. 2- I created Setup (two files named setup.exe and Setup.msi) 3- I copied these files to another computer and installed them. All files are output to a folder. (ExcelAddIn1.vsto and many dll files) The problem is: the plugin is not available in excel. Can you share a document that tells me about setup from start to finish? Thank you so much.
sorry i read this on the road and missed key parts. I dont remember a document. It has always worked for me. Are you sure you have the same versions of excel? I have never checked cross compatibility.
3 года назад
@@sthue1001 You are right. I did not check this either.
Awesome!!!! thank you!!! you change my life and my works - i will use it to create my windowsforms and record in my excel sheets - goodbye userforms in VBA - have a long and good life
How to solve this issue? Severity Code Description Project File String suppression Status Error CS1061 "ThisAddIn" does not contain the definition of "InternalStartup" and cannot find an available extension method "InternalStartup" that takes type "ThisAddIn" as the first argument (possibly missing a using Directive or Assembly reference). HelloWorld C:\Users\USER\source epos\HelloWorld\HelloWorld\ThisAddIn.Designer.cs 58 Active
I have not run into that: A naming issue? social.msdn.microsoft.com/Forums/en-US/3b94e9c3-189f-4d31-bd19-b8d4dfba2f7c/thisaddin-does-not-contain-a-definition-for-startup-and-no-extension-method-startup?forum=vsto
I actually was working on something similar a year ago, but go busy with other stuff. I ll see if I get some time to revisit the project. I own some rental property and whenever I buy something from Home depot I email the receipts to myself. Wanted to create a addin that will grab the date of receipt, subject line and and contents of receipt into csv. Not sure when I can get to this.
Steven, great video. Thanks so much for taking the time. Question...Excel 2016 on my machine doesn't seem to want to load the add-in when I click Start. I've built it just as you did and it seems to compile fine, but it will not load. I tried ti load it manually, but that won't work either. Any suggestions? Is there some trust setting I may have set wrong in VS or Excel? Thanks.
Sorry, but my autocomplete does not duplicate you code. I wish I had your code to compare, but "private Excel.range" has Excel.range unlined with a red squiggly. Perhaps the version of the dll is different?
Hi, the video is great thank you. Do you know how to link your VSTO project so that it starts in an existing workbook and not a blank one by any chance?
hello, I'm new to creating this kind of programs and everything was running well but when i publish it and try to install it on another machine I cant get the add in to show on the bar or even on the list of add ins when you go to manage com add ins in the options. is there anything i'm missing to make it run?
This one is the basic 'intro' video which only shows how to get a hold of worksheet. My Visual Studio Tools for Office C# Addin Embedded Chart video starts out by, putting in the addin, how to get a hold of the work book and application. Not specifically what you are asking for, but it would be a start. Good luck and thanks for watching!
Hey i've made document document level addin using visual studio 2017 but don't know how to create installer so user can install it to any location they want ,can you help me with that?
@@riteshmathur9221 I think VSTO is now deprecated, which is sad. They want to replace it with java. My career went into a different direction so I am writing automated web tests now.
Good video! Could be nice if you explained why you do different stuff. Like what do the different 'using' do. What does 'Globals' mean and so on. but then i guess the vid would become too long.
Not sure is the best answer I can come up with.Up to VS2013 you needed at least pro version to program in it. VBA is free. VBA has not had any updates since at least the early 2000s. There are a lot more people that write in VBA. There is a learning curve when switching to .net that a lot of VBA people will not try to climb. VSTO in VS2005 was so new and hard to use. VS 2010 was where VSTO really started to work well. So if it was a replacement it took forever to roll out to a version that works well. I think it is more for .net people to write addins and stuff for Office.
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Worksheets'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208B1-0000-0000-C000-000000000046}' help me fix error
Great video thank you. Saves so much time trying to tweek the essentials out of the mass of documentation on the Internet. You had me worried at the end when you said VSTO is not available with Express editions 😂 but you do cover that in the video description. Thanks again.
Steve, I have a question. If I have an add-in (I made) in an Excel file and distribute this file to my customers, would they be able to run this add-in in that file (I gave them) automatically at open, without installing anything? People hate installing stuff. Thanks!!!
This is a great video. It's been a while since I programmed in Excel. I did a lot of addin work with VBA. But this great. Thank you.
This video is just awesome, thank you very much for this explaination. I think it was a quick exposition but also a clear and an efficient one.
It says ThisAddIn does not contain a definition for GetActiveWorksheet and no accessible extension method accepting a first argument of type ThisAddin could be found.
Awesome Video , very good explanation. I have one more question regarding this , how to create MSI installer of this , if I want to install office addin on other machines ? Please help me out in this , that will be great help
You mention at the end of your helpful video that VSTO is not available in Community editions of Visual Studio. However I have Community 2017 and found it straightforward to go to Programs and Features on my control panel and install VSTO etc from there. Everything works fine.
It is available in community editions. it is not available in older express editions. This opens it up to a lot more developers.Thanks for pointing that out! I think I corrected that in the next video.
And thanks for watching!
Hi,
A suggestion:
If I were you (and could do so) I would change the thumbnail for this video. There is an orange bar at the bottom of the thumbnail that looks like RUclips's process bar, which made me think that I have already checked this video until the end, which was of course not the case. :)
Please make a complete playlist on VSTO development with MS Excel With C#
OMG. Better than Udemy. good video.
Lol. Thanks!
Hello sir, are you planning to publish more videos concerning this topic, it's an interesting one, do you recommend any course or channel that covers something like that? very useful video
Hello, thank you for sharing.
1-I created Exceladdin 1.sln with Visual studio 2019 and I know how to add a tab to the excel program on my computer.
2- I created Setup (two files named setup.exe and Setup.msi)
3- I copied these files to another computer and installed them. All files are output to a folder. (ExcelAddIn1.vsto and many dll files)
The problem is: the plugin is not available in excel. Can you share a document that tells me about setup from start to finish? Thank you so much.
Thanks. I do have another video about creating an add in install. It is in my videos. Thanks for watching.
sorry i read this on the road and missed key parts. I dont remember a document. It has always worked for me. Are you sure you have the same versions of excel? I have never checked cross compatibility.
@@sthue1001 You are right. I did not check this either.
Awesome!!!! thank you!!! you change my life and my works - i will use it to create my windowsforms and record in my excel sheets - goodbye userforms in VBA - have a long and good life
You also!
Thanks very much under the low-materials for VSTO examples. haha
Stephen, you helped me a lot. Thanks a lot!
How to solve this issue?
Severity Code Description Project File String suppression Status
Error CS1061 "ThisAddIn" does not contain the definition of "InternalStartup" and cannot find an available extension method "InternalStartup" that takes type "ThisAddIn" as the first argument (possibly missing a using Directive or Assembly reference). HelloWorld C:\Users\USER\source
epos\HelloWorld\HelloWorld\ThisAddIn.Designer.cs 58 Active
I have not run into that: A naming issue?
social.msdn.microsoft.com/Forums/en-US/3b94e9c3-189f-4d31-bd19-b8d4dfba2f7c/thisaddin-does-not-contain-a-definition-for-startup-and-no-extension-method-startup?forum=vsto
Could you create a video using OutLook? creating a bottom to grab Body, Subject, To, From and move that data to a file?
I actually was working on something similar a year ago, but go busy with other stuff. I ll see if I get some time to revisit the project. I own some rental property and whenever I buy something from Home depot I email the receipts to myself. Wanted to create a addin that will grab the date of receipt, subject line and and contents of receipt into csv. Not sure when I can get to this.
Steven, great video. Thanks so much for taking the time. Question...Excel 2016 on my machine doesn't seem to want to load the add-in when I click Start. I've built it just as you did and it seems to compile fine, but it will not load. I tried ti load it manually, but that won't work either. Any suggestions? Is there some trust setting I may have set wrong in VS or Excel? Thanks.
Sorry did not see your question. Sometimes addins get disabled, this is in the options menu.
Awesome stuff! Would you add some data binding to listobjects & how to publish when updated? Thank you
I made a video on creating a install package ruclips.net/video/_eY8k6cPuLA/видео.html. Hope this is what you are looking for.
That was really good. Thank you!
Sorry, but my autocomplete does not duplicate you code. I wish I had your code to compare, but "private Excel.range" has Excel.range unlined with a red squiggly. Perhaps the version of the dll is different?
What is the timestamp?
Hi, the video is great thank you. Do you know how to link your VSTO project so that it starts in an existing workbook and not a blank one by any chance?
The add in should be there when you open an existing workbook. If not, check to make sure it is not disabled.
hello, I'm new to creating this kind of programs and everything was running well but when i publish it and try to install it on another machine I cant get the add in to show on the bar or even on the list of add ins when you go to manage com add ins in the options. is there anything i'm missing to make it run?
That is weird. Maybe, check to make sure you have the correct version of Office on the target machine.
Would you please tell me how the HELLO World gets into the current selected cell? What code is needed?
currentSheet.Range["A1"].Value="Hello World"; is where it selects the range. Thanks for watching!
Is there anyway to target a specific workbook and create a custom ribbon for that workbook only (Vs. an add-in) via VSTO?
This one is the basic 'intro' video which only shows how to get a hold of worksheet. My Visual Studio Tools for Office C# Addin Embedded Chart video starts out by, putting in the addin, how to get a hold of the work book and application. Not specifically what you are asking for, but it would be a start. Good luck and thanks for watching!
Hey i've made document document level addin using visual studio 2017 but don't know how to create installer so user can install it to any location they want ,can you help me with that?
I do have a video in my playlist on making an installer. Not sure if it is what you are looking for.
I have vsto addins and want to call that ribbon function using VBA, so how will I do?
Interesting. Im sure it is possible, but probably will not be easy.
@@sthue1001 lt would be great if you make video for this
@@riteshmathur9221 I think VSTO is now deprecated, which is sad. They want to replace it with java. My career went into a different direction so I am writing automated web tests now.
Hello,who can to help me? 1:56 I dont understand this step
不错的教程。
謝謝！
Good video! Could be nice if you explained why you do different stuff. Like what do the different 'using' do. What does 'Globals' mean and so on. but then i guess the vid would become too long.
You are correct. Not sure how long a video can be before everybody nods off. I think I approach it! Thanks for watching!
Is VSTO a replacement for VBA? I still don't know the concept.
Not sure is the best answer I can come up with.Up to VS2013 you needed at least pro version to program in it. VBA is free. VBA has not had any updates since at least the early 2000s. There are a lot more people that write in VBA. There is a learning curve when switching to .net that a lot of VBA people will not try to climb. VSTO in VS2005 was so new and hard to use. VS 2010 was where VSTO really started to work well. So if it was a replacement it took forever to roll out to a version that works well. I think it is more for .net people to write addins and stuff for Office.
I think MS wants people to go to Web Add Ins. Here is a good explanation ruclips.net/video/Z0kBiHR2ZJU/видео.html
Great great great tutorial. thank you!!
Great, Thanks!
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Worksheets'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208B1-0000-0000-C000-000000000046}'
help me fix error
Thx a lot, please do more videos.
Thanks! Check out my other videos on my channel for more.
...thnx a lot
(Thank you.. video for How to deploy Office plug-in ( create a setup package
I made a video on creating a install package ruclips.net/video/_eY8k6cPuLA/видео.html. Hope this is what you are looking for.
😵 19min could, and should have been squeezed into five