Front end for Excel so that I can use excel as database

[Basav]

Dear Experts,

I need to use a any front end for my excel(as database here)
That front end has to allow macros to run and data to transport to and from the front end.

request you, could you please suggest any of such(HTML ,Xcelcious).

Eagerly waiting for your reply ..thanks in advance

regards,
Basav

[zmbd]

Basav,

What you ask is counter intuitive and, imho, counter productive. No spread sheet program will ever work well as the backend for a database.

Instead, I would advise you to reconsider moving your entire project over to one of the Database programs, such as MS Access.

[NeoPa]

I have no idea what causes you to have this requirement, Basav. It's certainly unusual and counter-intuitive as Z states. I would suggest you only consider this if you have thought through the whole idea thoroughly. We can help with that if you like.

That said, while Access can handle Excel as a BE quite effectively, that does not include the ability to run BE macros easily. You may need to consider some Application Automation code to handle that. That is assuming you even go ahead with what is certainly an awkward approach.

[Basav]

Dear Z and Neopa,

Thank you for your prompt reply and suggestion.

Here, All that i want is, just need to conceal the excel.
I do not want show the Excel file to end user.

We an achieve this by using Xcelcious, but unfortunately it wont support macros in that other than few Excel functions..

And, this will not be going online it ll be in stand alone system only...

[zmbd]

Basav,

I've taken a few moments to review Xcelcious and its functionality.

What you are asking us to do is to either design and build a entire program or do extensive research into the web and other resources to find you a suitable program.

What you fail to understand is that Bytes is mainly a bunch of like minded, unpaid volunteers, not a software design company nor a research group.

[Basav]

Dear Z,

I'm a kid in Excel development.
I'm just looking for an experts advice or suggestion to get done my work.

Who am i here to urge do extensive research and why they have to do at all?

Just checking if they know any such to suggest me.

For instance Xcelcious is supporting excel functions.
Checking for similar sort of software which supports macros too..there are ample of experts in Bytes from all over the word, probably any one of them would have used or know about such..

That's all i'm looking for.

Thanks,
Basavaraj CG

[NeoPa]

We're mainly Access experts actually. Many of us are Excel experts too. Hoping for experience elsewhere is not pointless, but it is certainly not what we offer (though we're normally happy to offer anything we do have experience with).

In this case, I see no reason why you would need to complicate the situation even as far as to store your data in Excel. You can store it in Access with the same level of obscurity from the users (probably more in fact), so, from what you've said in your answer to my question, everything in Access would be your best bet.

[Basav]

Thank you NeoPa for your suggestion.

[Rabbit]

I want to echo everyone's suggestion that you not use Excel as a backend. But yes, you can write code to do what you want. I don't know of any programs that already do what you want because most people would use Access instead of Excel. I don't understand why you need to "hide" Excel.

[TheSmileyCoder]

Often times you will find that if you explain not only WHAT you want to achieve but also WHY you want to achieve it, you will get far better replies. In almost all questions, time taken to formulate a proper, precise detailed questions is returned hundredfold.

While Excel and Access might look quite similar on "first" approach, they are radically different. You will likely spend 10 times the hours trying to develop a front-end against excel then it takes to do it against Access or any other database.