Тёмный
No video :(

How to Convert Vba Project to EXE File | Open User form Without Excel | Your Question | Excel Vba 

vbA Fun
Подписаться 20 тыс.
Просмотров 22 тыс.
50% 1

How to Convert Vba Project to EXE File | Open User form Without Excel | Your Question | Excel Vba
Today video is making to clear you doubts in excel vba. Majorily you will learn how to set you expiry date of your project, restrict to use if the system date is back dated or you can also convert excel vba project in exe file using doneex.
for video you can search on youtube with doneexteam or just search on google you will get entire detail for doneex which make your project safe and protected with exe files.
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3EXBOIl
Our Aim to Develop Skill in Excel :
=============================
Excel Userform Development
Excel Vba Projects
Advance Excel vba
Advance Excel Userform
Advance Microsoft Excel
Excel Software Development
Excel vba UDF (User defined function)
=============================
Join this channel to get access to perks:
===============================
/ @vbafun
===============================
About Excel vba
=================================
Excel VBA is a very useful programming language where you can do your work very smartly and this language is very simple to use. From this channel, you will learn how to simplify your code in excel VBA to automate your sheet for daily routine work as well as will teach you how to create an application in excel VBA to make automate the excel sheet like data entry, invoice, keeping a record of data. Maintain Stock and inventory, Student Management, School Managment and many more excel application which uses in each and every offices and school.
=================================
Never Seen Before Playlist in Excel Vba :
==================================
• Never Seen Before Tricks
==================================
Other excel vba training Video :
==================================
School Manager - Student Admission, Student Receipt, School Software
• School Manager Pt 1 | ...
Small Business Applications - sale/purchase/inventory
• Small Business Applica...
Employee Manager
• Employee Manager
School manager in excel
• School Manager
DatePicker in excel
• DatePicker
Advance Data Entry Software in excel
• Advance Data Entry App...
PoS in Excel with Image Control
• PoS with Image Control
PoS in Excel
• PoS ( Point of Sale) i...
===================================
Our Social Media Contact :
===================================
Facebook : www.facebook.c...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
====================================
Disclaimer :
=====================================
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research, Fair use is a permitted by copyright statute that might otherwise be infringing, Non-profit, educational or personal use tips the balance in favor of fair use
=====================================
#ExcelApplication #excelvba #userform #MSAccess #MsExcel

Опубликовано:

 

14 фев 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 128   
@vbAFun
@vbAFun 9 месяцев назад
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3EXBOIl
@munnachaudhary8066
@munnachaudhary8066 Год назад
आज आपकी दी हुई जानकारियां बहुत अच्छी लगी और मन मे उठ रहे कई प्रश्नों के उत्तर मिल गये। इसके लिए आपको बहुत बहुत धन्यवाद।
@vbAFun
@vbAFun Год назад
Thank you ❤️
@md.yeakubali3548
@md.yeakubali3548 Год назад
Dear Sir, I am very glad to have completed the project by watching your video and learned a lot. I am from Bangladesh, watching all your videos with great interest and learned a lot, thank you very much. thank you sir.
@vbAFun
@vbAFun Год назад
I appreciate and thank you for your like and share
@intakhabkhan9649
@intakhabkhan9649 Год назад
Bahut hi achha tutorial laga Sir, is ke liye dil se dhanywad.
@vbAFun
@vbAFun Год назад
Thank you ❤️
@amituppal
@amituppal Год назад
Thank you sir for very useful information first wala question Maine bhi aapse pucha tha
@vbAFun
@vbAFun Год назад
Welcome and thank you for watching and sharing
@falaknazzcreation4083
@falaknazzcreation4083 Год назад
Superb sir Ye kuchh naya hai Thak you sir
@vbAFun
@vbAFun Год назад
Welcome keep watching and sharing
@venugopal-pn9zt
@venugopal-pn9zt Год назад
Very useful session. Thank you very much for sharing this video.
@vbAFun
@vbAFun Год назад
Welcome and thank you ❤️ your like and share
@SM-tz1hc
@SM-tz1hc Год назад
Oh my God...! Very sensational...?!
@navadgiarun
@navadgiarun Год назад
Very very nice tutorial sir.
@vbAFun
@vbAFun Год назад
Thank you
@shahidarain9679
@shahidarain9679 Год назад
Good work Sir very well
@vbAFun
@vbAFun Год назад
Thank you
@claudegbessena5069
@claudegbessena5069 Год назад
Thank you very much Sir for your quick answer. I will apply it to my file, and be back to you for the result. One more time, thank you.
@vbAFun
@vbAFun Год назад
Thank you ❤️
@claudegbessena5069
@claudegbessena5069 Год назад
@@vbAFun waooh! It works very powerfully . Thank very very much Sir.
@vbAFun
@vbAFun Год назад
Welcome And keep watching
@claudegbessena5069
@claudegbessena5069 Год назад
@@vbAFun ok, Sir
@monirajv
@monirajv Год назад
Good Work Sir. Tumps Up
@vbAFun
@vbAFun Год назад
Thank you
@sindhuraramya9274
@sindhuraramya9274 Год назад
Thank you sir, coz of your efforts our doubts are cleared. I m waiting for this video since long time. I will work on my project n if any assistance is required I will contact. I learnt from your channel successfully on how to create inventory management system but still I am not getting in right way will do after this video. 🙏🙏
@vbAFun
@vbAFun Год назад
Very soon will upload keep watching and sharing
@mealax
@mealax Год назад
Sir, Zabardast
@vbAFun
@vbAFun Год назад
Thank you 👍
@rajbirkeshari5958
@rajbirkeshari5958 Год назад
Sir I am always all video follow you
@vbAFun
@vbAFun Год назад
Thank you ❤️
@rajbirkeshari5958
@rajbirkeshari5958 Год назад
Sir I am a senior accountant of various firm I work with tally and other software like Marg and a local software in foxbase made but I can't satisfied and want a complete software with you
@vbAFun
@vbAFun Год назад
Hi, yes it can be created with excel and access but it will take lots of time and trial to do this
@aqeelahmad3652
@aqeelahmad3652 Год назад
Amazing trick
@vbAFun
@vbAFun Год назад
Thank you ❤️
@muhammadmursaleen7879
@muhammadmursaleen7879 7 месяцев назад
Good evening sir. Sir we have a instrument whose data file export in CSV format to usb, when this usb connect to pc this data file convert in excel format. My question is that is there any method that we can make a such data file non editable.?
@chandrashekharprajapati9451
Wow it's great video, But it's very sad that I couldn't join your live class, please so something for me Sir.
@vbAFun
@vbAFun Год назад
No issue you can learn many more by watching the videos
@rakeshpal500
@rakeshpal500 Год назад
Sir, I am a regular follower of your genuine channel. I am very much thankful for efforts and contribution.Sir, I had a query: How to turn a technical product information to pdf file, the software must have the option to enter its parts number with total parts calculation and allow indication with an arrow through software format and later it can be saved as pdf file as engineering product and parts information sheet. Awaiting for your kind response. Thanks & Regards.
@kv73477
@kv73477 9 месяцев назад
Hello Sir Thanks for such a great knowledge. It was really helpful. I have one query that whenever i run this VBS file from Another Application the User form appears on background and it need to be come in front above all applications. Is there any way by which we can bring this user form above all applications ?
@vbAFun
@vbAFun 9 месяцев назад
I am trying to do this. Will upload once I find any method
@The_Light.gaming
@The_Light.gaming Год назад
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
@vbAFun
@vbAFun Год назад
Will upload soon with master class of listbox pr 2
@channel-ry4xq
@channel-ry4xq Год назад
Very very thanks sir 🎉
@vbAFun
@vbAFun Год назад
Most welcome
@parvezkhot8392
@parvezkhot8392 Год назад
Sir Thanks a lot for this useful video... I have one query... I in this method, we disabled Micro and then run the program, and its working fine BUT I have created Progress Bar and used it in For Loop Function. After Disabling Micros.. Progress Bar Not working. Sir Please help to solve this problem. Almighty Bless You. 😊
@shaileshsharma668
@shaileshsharma668 Месяц назад
Sir hume kisi bhi tareke se exe file install karwa sakte hai bina kisi popup window ke mujhe selenium library install karna hai but Mai chahata hu ki samane wale user ko install hota huya na dekhe
@amituppal
@amituppal Год назад
Sir Mera ek question hai jaise hum application mein activation code laga dete hai aur kisiko trial ke liye application dete hai toh kya hum usse mein kuch cheeze hi access karne de sakte hai baki sabhi disable ho Jaye sirf usse dekhe features but usse access na kar paye aur yeh Sara process access database mein ho sakta hai jo activation code hai woh access database mein generate ho date and all? Agar ho sakta hai toh aap iss per video bana sakte ho?
@vbAFun
@vbAFun Год назад
Y s ye sab ho sakta hai mai ek bade project pe kam kar raha hun apne client ke liye jaise o taiyar hota hai mai share karunga
@amituppal
@amituppal Год назад
Ek aur yaad aa gya woh access sirf wo hi kar paye jo trail activation code mein hum usse application mein use karne ki option de aur Jo disable ho woh sirf dekh sake agar uss per woh click kare toh usse message aaye ki iss feature ke access karne ke liye licenced version purchase karna padega woh chahe kisi bhi disabled feature per click kare MSG yeh aaye
@shaharyarahmed6124
@shaharyarahmed6124 Год назад
Sir please trial balance se balance sheet bna ni h vba coading se please us pr koi video bnai
@vbAFun
@vbAFun Год назад
Sure, but it is very complicated step to create will try to upload video
@fingercross4313
@fingercross4313 Год назад
Sir apne meri request accept nhi ki, POS ya kisi bhi user form ka data kaise excel table range me enter kr sakte with all feature like ( edit delete search update )
@vbAFun
@vbAFun Год назад
Maine ispe video bana Diya tha apne sayad dekha nahi hai video
@starcreation5329
@starcreation5329 Год назад
Sir, In notepad opening method if our user form is already open (in my case i have userform with minimized/maximise button) i have minimized my user form and by any chance if someone re-open file by clicking app icon then it shows another userform. So is there any way to stop opening another userform if it is already open or can we resume with already running userform.
@vbAFun
@vbAFun Год назад
Yes this is the problem i am trying to identify and resolved this issue
@starcreation5329
@starcreation5329 Год назад
Sir have you found any solution for this If yes please tell us
@suhagchowdhury7525
@suhagchowdhury7525 Год назад
Sir, I used Notepad for hide xl workbook and its working very well. But one problem i face that when i open notepad xl workbook show in my Task Manager. If any formula to hide xl workbook from task manager please share.
@vbAFun
@vbAFun Год назад
Hi that is not possible to hide any app from task managers if that is running in background
@Dan_De_Man
@Dan_De_Man Год назад
Application.quit what if you have other workbooks open. How can you avoid those being closed or quit as well
@vbAFun
@vbAFun Год назад
Then you can use thisworkboik.close and application.visible = true
@mohidmalik7374
@mohidmalik7374 Год назад
sir thank ap ne 1st question ka answer dia main ne b puchha tha ap se, ItmList update kr di hae, but eik problm pehly se ye b aa ra tha k agr main ne product 6 ko scan kia hae tou wo listbox mein 6 row mein ja ra, agr product 1 ko scan kia tou wo listbox ki 1st row mein ja, Gros amount net payment working but if i scan item 20 then wo item listbox mein nai show ho ga but calculate sahi kary ga...
@vbAFun
@vbAFun Год назад
Aap big fix bale video ke description se file download karke check o sahi work kar raha hai
@mohidmalik7374
@mohidmalik7374 Год назад
@@vbAFun sir main wo file download kr chuka hun, which is working 100%, main apko messenger mein video shot send kr chuka hun, time mily tou dekh lejye ga, and im trying to solve tha problm as well...
@sportsbook4059
@sportsbook4059 11 месяцев назад
sir my pos.vbs file not working tell me the solution plzzzzz
@joshitoshi9835
@joshitoshi9835 Год назад
thanks for the trick, bbut i have a problem here. I am using ur previous tutorial trick for hidden developer password by clicking on the userform, so now when i enter developer password it doesnt open excel file, how to fix that?
@vbAFun
@vbAFun Год назад
Please check what type of password has been given means if u are given in numeric then convert first textbox no in numeric using val function
@joshitoshi9835
@joshitoshi9835 Год назад
@@vbAFun im using password like password123 and here is the code: Private Sub Image1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) MyPass = InputBox("Enter Developer Password", "Developer Setting") If MyPass = Empty Then GoTo WrongDPass If MyPass = CStr(Sheet3.Range("B4")) Then Application.Visible = True Unload Me Else MsgBox ("Incorrect Password") End If WrongDPass: End Sub
@channel-ry4xq
@channel-ry4xq Год назад
Sir background process का application quit userform code लिखणे के बाद अगर दुबारा excel application मे change karanaa ho to क्या करे
@shbillingsolutions2860
@shbillingsolutions2860 Год назад
How I can add pdf reader in my userform toolbox ? i can't find it out in my toolbox additional controls. Could you please help me ?
@vbAFun
@vbAFun Год назад
You have to installed Acrobat library for that
@excelshambhu
@excelshambhu Год назад
POS me Direct listbox me additem ka coding karte hai to 10 se jyada column column header me nahi ho raha to is problem ka koi solution hai... Agar hai to batayega sir. Example ke tohr par 👇 Item code Item name HSN CODE Qty Rate Gross amt IGST % IGST AMT CGST % CGST AMT SGST % SGST AMT NET AMT
@vbAFun
@vbAFun Год назад
10 se jyada column ke liye is video ko dekhe ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gHZKToL19TU.html
@dolphinfoodsbeverages4555
@dolphinfoodsbeverages4555 Год назад
Sir is it possible to run POS application as Mobile app it will be useful to many people. Thank you.
@vbAFun
@vbAFun Год назад
Hi so sorry but VBA has no option to convert VBA to Android
@hemantjshah
@hemantjshah Год назад
Instead of comparing current date with last open date, we can post status in setting sheet. At the time of activation status will be active once it gets expired it will change status to expired.
@vbAFun
@vbAFun Год назад
Yes it can be done but suppose if the expiry date is 15 feb 2023 but he tried to use in back date from 14 feb then the status will not change
@hemantjshah
@hemantjshah Год назад
@@vbAFun that's true but once application gets launched on one day later of expiry date, status will get updated to expired. User may not realise n status changes to expired. If he goes back date then also app will not launch as status will hv expired mentioned
@vbAFun
@vbAFun Год назад
Yes once the status has changed then user can not use
@hemantjshah
@hemantjshah Год назад
I have one query which is can we plot a pivot table in full or with selected fields on userform?
@hemantjshah
@hemantjshah Год назад
I have created Share market portfolio management using vba with current market price getting updated every minute. Also few technical analysis...
@kailashsoni676
@kailashsoni676 Год назад
Sir I have best solution for the activation isntead of this code i used online date api method using xml6.0 so if we change system date it won't effect our code so i filled all cells with internet date
@vbAFun
@vbAFun Год назад
Yes you can do, but think if there is no internet then the system not run or he can use the application after expiry with disable the internet connection
@kailashsoni676
@kailashsoni676 Год назад
@@vbAFun i agree sir without internet connection it won't work but i used to get only demo date and for activation code will use system date because I set period from 365 to 365000 almost life time So what do you think about it is it good idea
@arunpatil833
@arunpatil833 8 месяцев назад
Sir I have created application exe file but file is using to multiuser.
@vbAFun
@vbAFun 8 месяцев назад
For multiuser you need to keep data in access
@arunpatil833
@arunpatil833 8 месяцев назад
I have not understand but it means use to access database.
@mohidmalik7374
@mohidmalik7374 Год назад
kindly tell me solution if u can, i hope ap bar bar questions ki wja se disturb nai ho rahy hoon gy, agr ho rahy haen tou sorry please ...
@vbAFun
@vbAFun Год назад
please ask if you have any question kyuki aplogo ke question se hi pata chalta hai ki aap kya sikhna ya dekhna pasand karte hai
@shanpalia
@shanpalia Год назад
sir meri ek query hai mujhe ek sheet 2 date ke between ka data filter karna hai with party name se start date A:A column me Hai end Date B:B Column me hai Aur Party Name C:C column me mujhe advanced filter lagana module ke jariye se please help me
@vbAFun
@vbAFun Год назад
I have shown theethid for advance filter in many videos. If you want then check otherwise wait will upload a separate video for that
@aiyazlakhani
@aiyazlakhani Год назад
Sir Vba code obfucation for excel project ka application banvo. Thanks
@vbAFun
@vbAFun Год назад
Sure
@KMTECHS
@KMTECHS Год назад
Ye Excel EXE ka Trick Single userform me he, Ye multi userform (Exa...10'15'20 userform )me kise kareka?
@vbAFun
@vbAFun Год назад
Usme bhi ye same kam karega
@kailashsoni676
@kailashsoni676 Год назад
If you change date to 10-2-2023 and click on demo or activation than in sheet it ll show 16-02-2023 as start date not 10-2-2023
@Gandaki_News
@Gandaki_News 11 месяцев назад
can u share thise file sir
@claudegbessena5069
@claudegbessena5069 Год назад
Hi Sir, Very sorry for bothering you. I have one more trouble, and the last one, i think. It's about password sharing. For example, a user has a password that he is using, then he gives it to another one. Shortly saying one password for two users. How can we set the vba code in such a way that use have one password for one user. I've tried but not success. Thank you very much.
@vbAFun
@vbAFun Год назад
I think you want to make single user or multi user right
@claudegbessena5069
@claudegbessena5069 Год назад
@@vbAFun Good day Sir. Yes, i want to make single user. A password for only one user , and not for two user. Thank you very much.
@vbAFun
@vbAFun Год назад
Then user registery key with hdd serial no i already created for that
@claudegbessena5069
@claudegbessena5069 Год назад
@@vbAFun ok Sir. Thank you very much. I will apply it to my file. And i will let you the result. Thank you very much Sir
@claudegbessena5069
@claudegbessena5069 Год назад
@@vbAFun Hi Sir , Thank you very much, it works.
@shaharyarahmed6124
@shaharyarahmed6124 Год назад
Mne vlookup se bnai h pr data boht h vlookup hang krta h formula
@vbAFun
@vbAFun Год назад
Yes vlookup ek array function hai jisko jyada use karne se file heavy ho jata hai uske liye VBA ka use kare
@shaharyarahmed6124
@shaharyarahmed6124 Год назад
@@vbAFun ji sir wohi poch rha h ap se kese bnao ap btain
@shaharyarahmed6124
@shaharyarahmed6124 Год назад
File havy h jati h koi hal btai ap
@shaharyarahmed6124
@shaharyarahmed6124 Год назад
And thank you so much sir ap ne replay kya 👍😇
@vbAFun
@vbAFun Год назад
Okay will make a video on that
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Sir, how to set automatic enable excel file in 2007
@vbAFun
@vbAFun Год назад
I could not understand what you want to enable in excel 2007
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Sir, I am to say that,I open my vba excel files at the time first done enable then work in my files. How to solve it.
@vbAFun
@vbAFun Год назад
Okay means your excel is not micro enable for that goro file select option then select trust centre then there will be button in button and left side click that then click on macro button then click enable all macro enable workbook
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Ok sir
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Ok sir
@darsalalahtrading8691
@darsalalahtrading8691 Год назад
Hi sir Ap continue item code nahi daloo Alag alag item code dalki dekho arahahe or nahi
@vbAFun
@vbAFun Год назад
Okay dekhke update karta hun
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Please help me
@vbAFun
@vbAFun Год назад
What you help required
@cristhianjfonseca2890
@cristhianjfonseca2890 Год назад
Why the title is in English, but then the language used is completely different?
@vbAFun
@vbAFun Год назад
Because i speak Hindi very well so that i used auto translated caption
@aslamkoodathil7934
@aslamkoodathil7934 Год назад
Hi ajay sir, mine ek request kiya Tha trough Instagram, jub time milega tho please answer dena
@vbAFun
@vbAFun Год назад
Hi, apka koi msg nahi Mila please send again
@The_Light.gaming
@The_Light.gaming Год назад
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
@channel-ry4xq
@channel-ry4xq Год назад
Sir notepad me canvert kare ne ke bad save button par click kare to application error msg .aata hai
Далее
Classic Italian Pasta Dog
00:20
Просмотров 6 млн
7 Days Stranded In A Cave
17:59
Просмотров 52 млн
How to compile Excel workbook to EXE file
5:16
Просмотров 182 тыс.
VBA User Form: Add, Update, Delete and Save
22:47
Просмотров 34 тыс.
Convert Excel File Into exe
11:42
Просмотров 32 тыс.
تحويل ملف الاكسل الى برنامج
14:09