Excel Offer Tool for rental companys

[JoelJohanssonHostlov]

Hello! Ive made an offer software that i use in my small AV rental-company. My Idea was to sell it to others in my level and line of work. Instead of paying a monthly fee to softwares like Rentman. But ive come to grips with that the more correct way of doing this was to program it i C# as a windows forms application with an installation file, this might be a futureproject of mine. However, now I just feel like sharing it and open up for engagement and improvements.

The excel file is fairly straight forward. A bit ambivalent with use of language hehe, I mix swe and eng alot.

The excel file/app works across plattforms mac and pc.

As of now it has 3 main pages 1. offer page 2. inventory page 3. data page

1. offerpage
this page is for making your offer. Entering the relevant products and information. You can switch between adding products from inventory and adding custom products (often used during subrentals).

2. The inventory page is for adding new products into your existing categorys of products

3. the data page is for setting up you inventory categorys and setting you progressive discount factors, so perhaps youd like for day two the rental price is 1.8, day three factor 2, day 5 factor 3 and so on.

The admin passwords for both the admin state of the excel "app" and the vba code is: admin

This is a freeware, I keep the rights of the software I post here. Any adjustments an improvements and changes made to my excel file will make it an officially new excel software and I no longer hold either responsibilty or claim to that file. Any usage of my code for your own purposes is ok. I dont take responsibility for missusage of the software. If you don know how to forcebly stop an application if it freezes or goes into an eternal loopstage in the vba code then dont download this and experiment with it.

The reason for me to post this is more to share and maybe engage others in this weird little home project of mine.

Important note. There is some bugs. Maybe bugs I still havent discovered myself. Some code is written in a way that is "unsafe" that iteration loops can go forever if adjustments to endmarkings in the excelfile is made. This will cause excel to freeze and you will have to forcebly end the application. As of what I know, this will not happen with the version Ive attached, ive made as much "safe" code as possible. But it can be good to take in consideration.

Look forward to hear what you think of the "excel app" and maybe what you can do to improve it! Best regards.

Offertmall Beta 7 - DEMO.xlsm.zip

[.paul.]

This is the VB.Net General Forum. This is the place to ask questions about VB.Net coding. Your post is neither a question or related to VB.Net. The Office Development Forum is the place for VBA questions, but as your post isn’t a question, I’d guess it should be posted in one of the CodeBanks…

[JoelJohanssonHostlov]

Mybad, trying to find how to delete the post. Dont know how to. Have any sugestions?

[.paul.]

Mybad, trying to find how to delete the post. Dont know how to. Have any sugestions?

Don’t delete it. I’ve notified a moderator. They’ll move it for you…

[.paul.]

I had a quick Look at your .xlsm file. I briefly looked through some of your code. My biggest problem with your app. is the use of the Swedish language. Much more difficult for a non Scandinavian to read.
Did you know you can use Forms in Excel Macro enabled apps.? You’re not limited to spreadsheet and cell based controls. No huge advantage over what you have though.

[JoelJohanssonHostlov]

DeletedByUser

[JoelJohanssonHostlov]

I had a quick Look at your .xlsm file. I briefly looked through some of your code. My biggest problem with your app. is the use of the Swedish language. Much more difficult for a non Scandinavian to read.
Did you know you can use Forms in Excel Macro enabled apps.? You’re not limited to spreadsheet and cell based controls. No huge advantage over what you have though.

Yes, youre very right. Some features i myself miss is:
*settings where you can choose language and currency. So that it all translates accordingly.
*Also a quicker loading and saving function of current Offer ...due to formatting it takes a while when youve started to load a real length of a list. The Loading and saving offers is internal int he excel file and does a do while loop cell by cell.
*Im sure theres lots of other stuff that could be enhanced.

And yes I know about the forms. I Actually use it some already. But due to cross plattform compatibility isues with some features I chose to try to stay with excel as far as possible. But now in retrospect I realize it would have taken me the same amount of code or maybe less to just do a windows forms app, ohwell.