Suljettu

Develop an Excel VBA based Setup File to programmatically create Custom Tab in Excel which hosts a set of Excel macros

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! :-)

Taidot: Excel, Visual Basic for Apps

Tietoa työnantajasta:
( 0 arvostelua ) Mumbai, India

Projektin tunnus: #32729074

9 freelanceria on tarjonnut keskimäärin ₹12278 tähän työhön

(175 arvostelua)
6.9
(167 arvostelua)
6.4
(102 arvostelua)
5.8
merinsinha

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 pla Lisää

₹7000 INR 2 päivässä
(125 arvostelua)
5.4
rayyankabir

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 sector Lisää

₹12000 INR 7 päivässä
(18 arvostelua)
4.9
VBAautomation

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 s Lisää

₹11000 INR 7 päivässä
(3 arvostelua)
3.0
kayush350

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 n Lisää

₹4000 INR 7 päivässä
(0 arvostelua)
0.0
vaishnavisingh56

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... Lisää

₹7000 INR 7 päivässä
(0 arvostelua)
0.0
kajalanthwal034

Best in Excel work or work dedicately in a proper way we'll maintained file in Excel sheet and do work as soon as possible

₹10000 INR 7 päivässä
(0 arvostelua)
0.0