473,320 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

convert Excel app to web

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?

Jul 17 '08 #1
7 2569
"CSharpCoder" <mo******@gmail.comwrote in message
news:OF**************@TK2MSFTNGP03.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

Jul 17 '08 #2
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]" <ma**@markNOSPAMrae.netwrote in message
news:u7**************@TK2MSFTNGP02.phx.gbl...
"CSharpCoder" <mo******@gmail.comwrote in message
news:OF**************@TK2MSFTNGP03.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

Jul 17 '08 #3
"CSharpCoder" <mo******@gmail.comwrote in message
news:eJ**************@TK2MSFTNGP06.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

Jul 17 '08 #4
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?
Jul 18 '08 #5
They want it on their intranet. It helps them calculate repair jobs
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:eE**************@TK2MSFTNGP05.phx.gbl...
"CSharpCoder" <mo******@gmail.comwrote in message
news:eJ**************@TK2MSFTNGP06.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

Jul 18 '08 #6
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" <no****@nospam.comwrote in message
news:%2****************@TK2MSFTNGP02.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?

Jul 18 '08 #7
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:))


"CSharpCoder" <mo******@gmail.comwrote in message
news:OF**************@TK2MSFTNGP03.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?

Jul 18 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Andrew V. Romero | last post by:
At work we have an excel file that contains the list of medications and their corresponding strengths. I would like to save the excel file as a text list and paste this list into a javascript...
0
by: Alex | last post by:
i have a module in Access which opens an existing Excel file and envokes a macro within the Excel file to draw graphs. now i am trying to convert the Excel macro to an Access one so that the...
2
by: noopathan | last post by:
Hi experts , I have an excel file in the below format --------------------------------------------------------------------- CodeID CodeName Market Name Date...
2
by: karups | last post by:
Hi when i convert Excel file to dataset using the following code, i find that, some col. such as Col1 ------ 404 403 NOT 222
8
by: pappu | last post by:
Hello friends, I want to convert .xls file into text file.So can anybody pls help me out. Thxxxxxx, Sachin.
3
by: Alain R. | last post by:
Hi, I have an excel file with charset "windows-1250" and i would like to convert it to CSV file with charset "UTF-8" how can i do that ? thanks a lot, Al.
32
by: poolboi | last post by:
hi guys, i've read a lot of thread of converting excel data into CSV files. however, i need a perl script to convert CSV file into excel file now, if required modules is needed, it would be...
0
by: Raymond Chiu | last post by:
Dear all, In my vb.net program, I am using excel object to create excel file and stored in a folder. How can it be converted to be pdf file automatically using dotnet coding or others? Actually...
15
by: pakerly | last post by:
How would i do this, convert a test file to excel? Lets say my text file has fields like this: NUMBER NAME ADDRESS PHONE 11002 Test1 ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.