How to Convert Vba Project to EXE File | Open User form Without Excel | Your Question | Excel Vba
HTML-код
- Опубликовано: 11 сен 2024
- 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
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3EXBOIl
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.
I appreciate and thank you for your like and share
Bahut hi achha tutorial laga Sir, is ke liye dil se dhanywad.
Thank you ❤️
Thank you sir for very useful information first wala question Maine bhi aapse pucha tha
Welcome and thank you for watching and sharing
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. 🙏🙏
Very soon will upload keep watching and sharing
Oh my God...! Very sensational...?!
Superb sir
Ye kuchh naya hai
Thak you sir
Welcome keep watching and sharing
Very useful session. Thank you very much for sharing this video.
Welcome and thank you ❤️ your like and share
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.
Thank you ❤️
@@vbAFun waooh! It works very powerfully .
Thank very very much Sir.
Welcome And keep watching
@@vbAFun ok, Sir
Good work Sir very well
Thank you
Very very nice tutorial sir.
Thank you
Good Work Sir. Tumps Up
Thank you
Sir I am always all video follow you
Thank you ❤️
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
Hi, yes it can be created with excel and access but it will take lots of time and trial to do this
Wow it's great video, But it's very sad that I couldn't join your live class, please so something for me Sir.
No issue you can learn many more by watching the videos
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.
Sir, Zabardast
Thank you 👍
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 ?
I am trying to do this. Will upload once I find any method
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?
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
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
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.?
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. 😊
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
Amazing trick
Thank you ❤️
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
10 se jyada column ke liye is video ko dekhe
ruclips.net/video/gHZKToL19TU/видео.html
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 ❤❤
Will upload soon with master class of listbox pr 2
Very very thanks sir 🎉
Most welcome
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 )
Maine ispe video bana Diya tha apne sayad dekha nahi hai video
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...
Aap big fix bale video ke description se file download karke check o sahi work kar raha hai
@@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...
Sir please trial balance se balance sheet bna ni h vba coading se please us pr koi video bnai
Sure, but it is very complicated step to create will try to upload video
Sir background process का
application quit userform code लिखणे के बाद अगर दुबारा excel application मे change karanaa ho to क्या करे
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.
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
@@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
Yes once the status has changed then user can not use
I have one query which is can we plot a pivot table in full or with selected fields on userform?
I have created Share market portfolio management using vba with current market price getting updated every minute. Also few technical analysis...
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.
Yes this is the problem i am trying to identify and resolved this issue
Sir have you found any solution for this
If yes please tell us
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.
Hi that is not possible to hide any app from task managers if that is running in background
Sir notepad me canvert kare ne ke bad save button par click kare to application error msg .aata hai
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
I have shown theethid for advance filter in many videos. If you want then check otherwise wait will upload a separate video for that
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?
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
@@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
Application.quit what if you have other workbooks open. How can you avoid those being closed or quit as well
Then you can use thisworkboik.close and application.visible = true
Sir is it possible to run POS application as Mobile app it will be useful to many people. Thank you.
Hi so sorry but VBA has no option to convert VBA to Android
Ye Excel EXE ka Trick Single userform me he, Ye multi userform (Exa...10'15'20 userform )me kise kareka?
Usme bhi ye same kam karega
sir my pos.vbs file not working tell me the solution plzzzzz
Sir Vba code obfucation for excel project ka application banvo. Thanks
Sure
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
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 ...
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
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 ?
You have to installed Acrobat library for that
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
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
@@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
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.
I think you want to make single user or multi user right
@@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.
Then user registery key with hdd serial no i already created for that
@@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
@@vbAFun Hi Sir ,
Thank you very much, it works.
Sir I have created application exe file but file is using to multiuser.
For multiuser you need to keep data in access
I have not understand but it means use to access database.
Hi sir
Ap continue item code nahi daloo
Alag alag item code dalki dekho arahahe or nahi
Okay dekhke update karta hun
Mne vlookup se bnai h pr data boht h vlookup hang krta h formula
Yes vlookup ek array function hai jisko jyada use karne se file heavy ho jata hai uske liye VBA ka use kare
@@vbAFun ji sir wohi poch rha h ap se kese bnao ap btain
File havy h jati h koi hal btai ap
And thank you so much sir ap ne replay kya 👍😇
Okay will make a video on that
can u share thise file sir
Why the title is in English, but then the language used is completely different?
Because i speak Hindi very well so that i used auto translated caption
Sir, how to set automatic enable excel file in 2007
I could not understand what you want to enable in excel 2007
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.
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
Ok sir
Ok sir
Please help me
What you help required
Hi ajay sir, mine ek request kiya Tha trough Instagram, jub time milega tho please answer dena
Hi, apka koi msg nahi Mila please send again
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 ❤❤