Develop an Excel VBA based Setup File to programmatically create Custom Tab in Excel which hosts a set of Excel macros
₹1500-12500 INR
Closed
Posted about 2 years ago
₹1500-12500 INR
Paid on delivery
We have a client who wants to load a Custom Tab in his Excel. This tab will host a number of pre-designed macros. These macros are simple format based macros. Refer to the attachment to get an understanding of the identified items.
Our development effort is towards creating a sort of a 'setup file' such that whoever uses that setup file will have the Custom Tab on his Excel on his machine. Some parameters of the format based macros may change. We will have to accordingly identify 'variables' for each of the items and give a simple interface to an admin user to make changes in those variable values. For example, standard fill colour may be blue but we will give a chance to the user to change it to red.
All these changes will happen in the setup file. As the admin user may not make all changes in one go, we should give him a chance to save his draft changes. Ultimately, once the variable changes are finalized, the admin user can freeze and can create a 'version' of the Custom Tab. Accordingly, other users will load such version in their Excel. While they load a new version of the Custom Tab, they should have the option to either retain or delete the old Tab. In other words, if the user so desires, he should be able to simultaneously carry 4 or 5 versions of Custom Tab too.
The interfaces should be simple, using worksheets. Userforms are not necessary. Simplicity leading to user friendliness is more important than the robustness of process. I have mentioned about admin user and other user, but as such we won't have any user management system. We will simply give a password to the client and whoever knows the password, should be able to make the admin level changes.
While the client has given a list of format based macro requirements, you may expect about 20% scope creep in that. Your quote should accordingly have a margin for such scope creep.
Let me know if you have any questions related to this project. Let me know your quote in with expected number of working days to deliver this. Thank You! :-)
Excel VBA Expert.
As 9+ years experiences in these field. I can give good quality work.
I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
Hello,
I am the expert on SQL server, Excel, Microsoft Access and also in Power BI. I am also very skilled freelancer who completes his job with 100% client satisfaction. I have also profound knowledge in other sectors that are related to that field.
For these amazing skills, I have the ability to bring 100% success in every project.
Thank you
Hi, I hope you are doing well
I am a professional on SQL server, VBA programming, MS access and also in power BI.
I am doing this job since 2010. I can handle your project in a very prudent manner. Give me a chance so that I can show you my skills through this project.
Thank you
Hello, My name is ayush Kumar I belong to deoghar Jharkhand. I am 21 year young man. As a person, I would describe myself as an motivated and innovative person, always looking out for opportunities to learn something new. I am currently running my page on Instagram where I help students to prepare dissertation report and how to write paper and working as freelancer for the past 8 months, I completed my BBA from amity university Jharkhand. During my collage days, I had a keen interest in writing research paper and got also my 2 research paper under very good journals. I was also awarded student ambassador of my collage. My hobbies include reading newspaper and playing with children. I also did one marketing internship in shine projects where I vanished my fear of public speaking and also gained enhancement in my skills.
Hello sir, I thank you wholeheartedly for having seen my proposal. I want to tell you that I am a trained person who is perfect for your project. This works for me very well. i would love it if you give me this job...
THANK YOU SIR...