convert Excel app to web

[CSharpCoder]

I have an Excel VBA app that has 25 forms within and is reading from 60
Excel Sheets for a datasource. This needs to be converted over to the web in
10 days, and it took almost 3 months to do the original one, so my question
is, is there a way (tool add on, etc) to convert this thing to the web
without a total rewrite of the application?

[Mark Rae [MVP]]

Re: convert Excel app to web

"CSharpCode r" <moveaway@gmail .comwrote in message
news:OFPbOJE6IH A.2260@TK2MSFTN GP03.phx.gbl...

I have an Excel VBA app that has 25 forms within and is reading from 60
Excel Sheets for a datasource. This needs to be converted over to the web
in 10 days, and it took almost 3 months to do the original one, so my
question is, is there a way (tool add on, etc) to convert this thing to
the web without a total rewrite of the application?

Not that I know of...

Are the 25 forms just for data entry?

What does the app actually do...?


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[CSharpCoder]

Re: convert Excel app to web

Yes, it has one main form, and then other forms that pop up when a button is
clicked. The user then enters in data into the 'child' and that is stored to
be used on the parent form.

Its doing alot of stuff its for a body shop and they wanted it web enabled.



"Mark Rae [MVP]" <mark@markNOSPA Mrae.netwrote in message
news:u7hK8NE6IH A.3512@TK2MSFTN GP02.phx.gbl...

"CSharpCode r" <moveaway@gmail .comwrote in message
news:OFPbOJE6IH A.2260@TK2MSFTN GP03.phx.gbl...
>

>I have an Excel VBA app that has 25 forms within and is reading from 60
>Excel Sheets for a datasource. This needs to be converted over to the web
>in 10 days, and it took almost 3 months to do the original one, so my
>question is, is there a way (tool add on, etc) to convert this thing to
>the web without a total rewrite of the application?

>
Not that I know of...
>
Are the 25 forms just for data entry?
>
What does the app actually do...?
>
>
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

Re: convert Excel app to web

"CSharpCode r" <moveaway@gmail .comwrote in message
news:eJfy5RE6IH A.3856@TK2MSFTN GP06.phx.gbl...

[top-posting corrected]

>>I have an Excel VBA app that has 25 forms within and is reading from 60
>>Excel Sheets for a datasource. This needs to be converted over to the
>>web in 10 days, and it took almost 3 months to do the original one, so
>>my question is, is there a way (tool add on, etc) to convert this thing
>>to the web without a total rewrite of the application?

>>
>Not that I know of...
>>
>Are the 25 forms just for data entry?
>>
>What does the app actually do...?

>
Yes, it has one main form, and then other forms that pop up when a button
is clicked. The user then enters in data into the 'child' and that is
stored to be used on the parent form.

Doesn't sound too bad so far...

It's doing a lot of stuff its for a body shop

Like what...?

and they wanted it web enabled.

Intranet, extranet or Internet...?


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[bruce barker]

Re: convert Excel app to web

unless you are using sharepoint with the excel engine (or some third
party excel library), you will probably have to code the site from
scratch. unless you are already familar with asp.net coding, it will
take longer than the excel version, and will be a different user interface.

-- bruce (sqlwork.com)

CSharpCoder wrote:

I have an Excel VBA app that has 25 forms within and is reading from 60
Excel Sheets for a datasource. This needs to be converted over to the web in
10 days, and it took almost 3 months to do the original one, so my question
is, is there a way (tool add on, etc) to convert this thing to the web
without a total rewrite of the application?
>
>
>

[CSharpCoder]

Re: convert Excel app to web

They want it on their intranet. It helps them calculate repair jobs
"Mark Rae [MVP]" <mark@markNOSPA Mrae.netwrote in message
news:eEr59VE6IH A.4900@TK2MSFTN GP05.phx.gbl...

"CSharpCode r" <moveaway@gmail .comwrote in message
news:eJfy5RE6IH A.3856@TK2MSFTN GP06.phx.gbl...
>
[top-posting corrected]
>

>>>I have an Excel VBA app that has 25 forms within and is reading from 60
>>>Excel Sheets for a datasource. This needs to be converted over to the
>>>web in 10 days, and it took almost 3 months to do the original one, so
>>>my question is, is there a way (tool add on, etc) to convert this thing
>>>to the web without a total rewrite of the application?
>>>
>>Not that I know of...
>>>
>>Are the 25 forms just for data entry?
>>>
>>What does the app actually do...?

>>
>Yes, it has one main form, and then other forms that pop up when a button
>is clicked. The user then enters in data into the 'child' and that is
>stored to be used on the parent form.

>
Doesn't sound too bad so far...
>

>It's doing a lot of stuff its for a body shop

>
Like what...?
>

>and they wanted it web enabled.

>
Intranet, extranet or Internet...?
>
>
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[CSharpCoder]

Re: convert Excel app to web

I can make it into a SharePoint site, I don't think that will be an issue.
As for .NET (asp.net) I've been doing that for years, I was just seeing if
there was an easy way to convert this to a web app.


"bruce barker" <nospam@nospam. comwrote in message
news:%23MwhhjI6 IHA.1176@TK2MSF TNGP02.phx.gbl. ..

unless you are using sharepoint with the excel engine (or some third party
excel library), you will probably have to code the site from scratch.
unless you are already familar with asp.net coding, it will take longer
than the excel version, and will be a different user interface.
>
-- bruce (sqlwork.com)
>
CSharpCoder wrote:

>I have an Excel VBA app that has 25 forms within and is reading from 60
>Excel Sheets for a datasource. This needs to be converted over to the web
>in 10 days, and it took almost 3 months to do the original one, so my
>question is, is there a way (tool add on, etc) to convert this thing to
>the web without a total rewrite of the application?
>>
>>

[randy.buchholz]

Re: convert Excel app to web

I've converted several Excel apps to other formats and have a pretty quick
(and dirty) way to get started. I'm assuming you will get rid of the Excel
stuff and move to a database. With SQL Server I use the import function to
bring in each sheet as a table. This usually results in a nasty looking DB
and at this point you need to consider if you can cleanup the DB or use it
as is. Clean of course is best, but structural changes will cause
significant changes to the program logic. With your time constraint likely
not a good idea for now. Throw in a few views and SP's to fill the gaps,
and then just drag tables, etc from the server explorer onto your
forms/pages. Dragging a combination of Detail and Grid views can usually
get you pretty close to where you need to be, especilly if your app is
basically a store and retrieve type.

It's an ugly approach, but you can do the basics with an app of that size in
a couple of hours. From there you should be able to estimate how much
effort would be required to finish. For the code conversion if you have
access to a good CASE tool (I like PowerDesigner) you can reverse engineer
your VBA and then change your target to C# and generate your code. This
tool also makes database cleanup pretty easy.

Worst case you can run your app under an application that serves app forms
as web pages. There is one used all the time but I'm drawing a blank on the
name (not enough coffee yet:))




"CSharpCode r" <moveaway@gmail .comwrote in message
news:OFPbOJE6IH A.2260@TK2MSFTN GP03.phx.gbl...

>I have an Excel VBA app that has 25 forms within and is reading from 60
>Excel Sheets for a datasource. This needs to be converted over to the web
>in 10 days, and it took almost 3 months to do the original one, so my
>question is, is there a way (tool add on, etc) to convert this thing to the
>web without a total rewrite of the application?
>
>
>