No video

How to deploy Office Solutions. Step by step for both Workbook/Document and Add-ins Projects

  Рет қаралды 14,962

VBA A2Z

VBA A2Z

Күн бұрын

Пікірлер: 91
@Rahul-sn1wn
@Rahul-sn1wn 4 жыл бұрын
Thanks a lot Pamai. I’ve been struggling with this for a while now.
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Happy to help!
@user-rx2ei2uu8q
@user-rx2ei2uu8q 11 ай бұрын
Thanks for the video Pamai much appreciated!!
@VBAA2Z
@VBAA2Z 11 ай бұрын
My pleasure!!
@linnick9235
@linnick9235 4 жыл бұрын
Thanks for this simplified tutorial. I found it very helpful.
@VBAA2Z
@VBAA2Z 4 жыл бұрын
You're welcome!
@DorkaLiumsk
@DorkaLiumsk Жыл бұрын
Your knowledge is worth a lot, as I and many others have realized. Thank you
@VBAA2Z
@VBAA2Z Жыл бұрын
I appreciate that!
@roland9923
@roland9923 4 жыл бұрын
Really useful tutorial. Really appreciate you sharing all your knowledge for free. God bless
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Glad it was helpful!
@holieh5301
@holieh5301 4 жыл бұрын
Thanks for another useful tutorial!
@VBAA2Z
@VBAA2Z 4 жыл бұрын
You're welcome
@alexandershubert573
@alexandershubert573 2 жыл бұрын
Thank you so so much!
@VBAA2Z
@VBAA2Z 2 жыл бұрын
You're welcome!
@azel2239
@azel2239 4 жыл бұрын
Keep up the good work. Thanks as always
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Thanks, will do!
@matnz7546
@matnz7546 3 жыл бұрын
Thanks, your tutorials are very helpful
@VBAA2Z
@VBAA2Z 3 жыл бұрын
You are welcome!
@bazaloo
@bazaloo 3 жыл бұрын
Excellent tutorial. Keep up the good work.
@VBAA2Z
@VBAA2Z 3 жыл бұрын
Thanks, glad it was helpful!
@Imchal-hc7lo
@Imchal-hc7lo Жыл бұрын
Thanks alot for amazing tutorial
@VBAA2Z
@VBAA2Z Жыл бұрын
Glad you liked it
@wennychez5606
@wennychez5606 4 жыл бұрын
Thanks for another very useful video.
@VBAA2Z
@VBAA2Z 4 жыл бұрын
My pleasure!
@anotherusername34
@anotherusername34 2 жыл бұрын
It worked well. Thank you very much.
@VBAA2Z
@VBAA2Z 2 жыл бұрын
Glad it helped
@kumarapush2221
@kumarapush2221 Жыл бұрын
Its been very useful. I was struggling to create VSTO Install file. its been a useful time spent in your videos. Thanks.
@VBAA2Z
@VBAA2Z Жыл бұрын
Glad to hear that!
@bnancy3699
@bnancy3699 4 жыл бұрын
thanks Pamai.
@VBAA2Z
@VBAA2Z 4 жыл бұрын
You're welcome
@davidwebchile
@davidwebchile 5 ай бұрын
another level!
@VBAA2Z
@VBAA2Z 5 ай бұрын
thanks!
@alexcrown497
@alexcrown497 Жыл бұрын
Большое тебе СПАСИБО! жаль, что не нашёл тебя месяц назад😔 У меня неделя ушла то, чтобы самому понять как публиковать надстройки. А с твоими наглядными объяснениями - 20 минут и готово 👍
@VBAA2Z
@VBAA2Z Жыл бұрын
Glad it was helpful!
@ayaanansari4765
@ayaanansari4765 4 жыл бұрын
It's very very helpful
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Glad it helped
@sunil5149
@sunil5149 4 жыл бұрын
Hello sir, thanks for this excellent useful tutorial.
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Glad it was helpful!
@manul74
@manul74 2 жыл бұрын
its help me. thanks. like
@VBAA2Z
@VBAA2Z 2 жыл бұрын
You're most welcome
@rrangraj
@rrangraj 3 жыл бұрын
Good tutorial
@VBAA2Z
@VBAA2Z 3 жыл бұрын
Thank you! Cheers!
@gtxviper
@gtxviper 4 жыл бұрын
Need to do this for all my addins. Doubt my colleagues would feel confident messing with the reg lol. Clear, easy to follow, to the point video!
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Thanks Stuart!
@shaikhashad7172
@shaikhashad7172 3 жыл бұрын
How to resolve: Deployment and application do not have matching security zones
@jandeschepper7751
@jandeschepper7751 3 жыл бұрын
hi publication of the xls with add in worked fine thanks
@VBAA2Z
@VBAA2Z 3 жыл бұрын
You are most welcome. thanks for visiting.
@scotolivera8207
@scotolivera8207 4 жыл бұрын
Thanks a lot
@VBAA2Z
@VBAA2Z 4 жыл бұрын
Happy to help
@scotolivera8207
@scotolivera8207 4 жыл бұрын
VBA A2Z what’s next sir ?
@hemantjshah
@hemantjshah 3 жыл бұрын
Can we create an executable app from Excel sheet having macros n install n run it without excel?
@emrgfx3503
@emrgfx3503 2 жыл бұрын
Thank you very much for your great tutorials🙏 How to change the icon?
@VBAA2Z
@VBAA2Z 2 жыл бұрын
You're welcome. What icon?
@MindHaunter
@MindHaunter 10 ай бұрын
Thank you a lot. What if I have custom functions? How can I deploy those? This seems to only deploy the ribbon.
@VBAA2Z
@VBAA2Z 10 ай бұрын
You're most welcome. For custom functions I'd recommend kzfaq.info/get/bejne/sJmTlaSZnKnefaM.html
@jandeschepper7751
@jandeschepper7751 3 жыл бұрын
Hi again the excel addin installed even as excellent as well. So now i need to figure out where all you need to put the extra code when working with the addin via xml. I suppose you just need tot add the extra subs as in vba.
@VBAA2Z
@VBAA2Z 3 жыл бұрын
Hi again, Below series has all you need to know about RibbonX in VSTO and other topics. kzfaq.info/sun/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU
@guangqiwang2004
@guangqiwang2004 3 жыл бұрын
Dear sir: I used visual studio installer to create install file for excel add in, and when install the add in in win7 it works, but in win10 , it's not loading in the excel, same as ClickOnce way, do you have any idea about this?
@repiola174
@repiola174 10 ай бұрын
Hi Lump! Thank you for this tutorial, it was very helpful and easy to understand. Do you know how to open a workbook from an add-in project? For example if I create a button in the ribbon of my add-in do you know what code should I insert to automatically open a specific workbook?
@VBAA2Z
@VBAA2Z 10 ай бұрын
You're most welcome. Please check out the entire series. kzfaq.info/get/bejne/gbaDqNmDuN3LmGg.html
@VBAA2Z
@VBAA2Z 10 ай бұрын
sample Me.Application.Workbooks.Open("C:\Test\YourWorkbook.xlsx")
@sashidhara1316
@sashidhara1316 2 жыл бұрын
Excellent tutorial 👌 Can you please make a tutorial on publishing addin app with a key that can be used to install in a single computer? Thanks in Advance! 😊
@VBAA2Z
@VBAA2Z 2 жыл бұрын
Sure thanks for your suggestion
@ElAlesson
@ElAlesson Жыл бұрын
Hello, I need some help 🥺 How can I publish my VSTO plugin in Microsoft Partner Center? Or how I could generate the ".app" installation file for Office platforms on Mac
@VBAA2Z
@VBAA2Z 10 ай бұрын
go for app installation
@emrgfx3503
@emrgfx3503 2 жыл бұрын
Hi how to add new icon to setup file of addin? For displaying my icon in Programs and Features?
@VBAA2Z
@VBAA2Z 2 жыл бұрын
it is explained in this tut kzfaq.info/get/bejne/bLOWo5V2vdO6fn0.html
@emrgfx3503
@emrgfx3503 2 жыл бұрын
@@VBAA2Z wow Thanks🙏🌷
@edermelo6979
@edermelo6979 8 ай бұрын
Is it possible to create a VSTO and keep the logic inside the file itself? I mean… I would like to avoid the installation … and also being possible copy my file and share with people… is there a way to do it?
@VBAA2Z
@VBAA2Z 8 ай бұрын
Yes, it's possible. You can create a VSTO document-level customization, which embeds the logic directly within the document (Excel file). Users can then copy and share the file without the need for a separate installation.
@suyunagidenadam552
@suyunagidenadam552 3 жыл бұрын
Thanks man. Really appreciate. İs it possible to set a password for the installer?
@mmbcampus
@mmbcampus 3 жыл бұрын
Is it not possible to create a simple .xlsm file as another user can copy the file and paste it into the excel Add-in default folder? In my office, EXE installation is not possible.
@VBAA2Z
@VBAA2Z 3 жыл бұрын
In the video link below I have demonstrated how to create Excel Add-in. You can create .xla or xlam for excel. kzfaq.info/get/bejne/i9xdeqye1tnck40.html or .xll Addin kzfaq.info/get/bejne/sJmTlaSZnKnefaM.html or VSTO kzfaq.info/get/bejne/gbaDqNmDuN3LmGg.html
@mmbcampus
@mmbcampus 3 жыл бұрын
@@VBAA2Z 1. Sorry I did not make me clear. I have followed your ur VSTO add-in series and create my add-in. Now I want to compile my VSTO code to a .xlsm file (code will be 100% secure; may be DLL or any system binary file creation) rather than creating EXE file. Because .xlsm file easy to include in Excel; no installation is required. 2. And another point is VBA Excel add-in doesn't have any security to hide as so many silly password cracking tool can break the VBA password. If you can create a tutorial for us to secure VBA code (100% not crackable), that would be great?
@kailashsoni676
@kailashsoni676 Жыл бұрын
Can we make userform for excel in visual studio?
@VBAA2Z
@VBAA2Z Жыл бұрын
Please refer to this playlist kzfaq.info/get/bejne/gbaDqNmDuN3LmGg.html
@VBAA2Z
@VBAA2Z Жыл бұрын
you've various UI options
@hewyiyun2302
@hewyiyun2302 Жыл бұрын
Is there a way to make setup.exe silent and not show the popup?
@VBAA2Z
@VBAA2Z 10 ай бұрын
copy to target folder and register it
@pmaly1980
@pmaly1980 3 жыл бұрын
Hi, What is the easiest way to create an .MSI installation package for FREE, that will include the Excell AddIN ( Ribon with Button and VB Form. Could you please make a video with VSTO AddIN (Ribbon with button, this button open Excel VB FORM) and create setupAddIn.msi (using VS2019 Community) A simple customer installation (in a few clicks) Thx Petr
@VBAA2Z
@VBAA2Z 3 жыл бұрын
Create .exe and .msi kzfaq.info/get/bejne/bLOWo5V2vdO6fn0.html Playlist: kzfaq.info/sun/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU Also consider .xll kzfaq.info/get/bejne/sJmTlaSZnKnefaM.html
@PresentationConcepts
@PresentationConcepts Жыл бұрын
Why my add in is not showing while i m using powerpoint VSTO
@VBAA2Z
@VBAA2Z Жыл бұрын
debug the ini/load
@007_Damo
@007_Damo 3 жыл бұрын
Where can I find info on the post deployment side of the equation? You refer to this @ aprox. 21:26 into your video. The post deployment steps for user drive that you refer to can you give a link to the exact section in your blog please? Maybe a link to the correct video. PS I deployed a word macro based doc and for updates I just use the open event to check if my share-point has a later version of the file on my desk via date--time-stamp. If yes i get the later version and add it to my desk etc ........ I'm guessing these post deployment steps are similar but I'd like your input here.
@VBAA2Z
@VBAA2Z 3 жыл бұрын
Hi Damien, for more resource check video description or below --> Deploy an Office solution vbaa2z.blogspot.com/2020/05/vsto-e01-get-up-to-speed-with-vsto-vba.html --> Create a class that defines the post-deployment action docs.microsoft.com/en-us/visualstudio/vsto/deploying-an-office-solution-by-using-clickonce?view=vs-2019
@007_Damo
@007_Damo 3 жыл бұрын
@@VBAA2Z Thanks so much for taking the time to reply. I think you and your channel are awesome! keep up the hard work.
@VBAA2Z
@VBAA2Z 3 жыл бұрын
@@007_Damo thanks for watching and for your support.
@shaikhashad7172
@shaikhashad7172 3 жыл бұрын
Thanks, How to resolve: Deployment and application do not have matching security zones ************** Exception Text ************** System.Deployment.Application.InvalidDeploymentException: Deployment and application do not have matching security zones. at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.GetManifests(TimeSpan timeout) at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
How to build XLL Add-in for Excel
30:02
VBA A2Z
Рет қаралды 11 М.
Это реально работает?!
00:33
БРУНО
Рет қаралды 3,3 МЛН
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Chapitosiki
Рет қаралды 2,5 МЛН
Integrate Excel, VBA and SQL. Simplified and powerful
1:01:23
10 Free Must Have Office Add-ins for Microsoft Office
10:18
Britec09
Рет қаралды 48 М.
Deploy Office Add-in that uses SSO to Azure App Service
16:53
Microsoft Community Learning
Рет қаралды 2,8 М.
What do programmers actually do?
9:20
Physics Girl
Рет қаралды 2 МЛН
Making an Excel Ribbon App | VBA
10:26
Max DeMaio
Рет қаралды 20 М.
Creating Office.js Add-ins ​​| The XML Manifest File
10:33
ABitWiseGuy
Рет қаралды 8 М.
Это реально работает?!
00:33
БРУНО
Рет қаралды 3,3 МЛН