473,385 Members | 1,661 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,385 software developers and data experts.

Programming Excel Efficiently

My head is exploding with the 500 different ways shown on Microsoft's site
to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and PC users
and have them access from a web site. These users not only have different
platforms (Mac and PC) but many have different versions of Excel (XP, 2002,
2003, 2000). What does Microsoft have out there that would be compatible
with all of the above differences??
I am open to VBA, VB.Net, ASP.NET, etc........
Nov 18 '05 #1
4 1093
By the way, I already have spreadsheets LOADED with vba code and would like
to use asp.net to make them interactive to users of varying
platforms.....any help would be appreciated
"ibeetb" <tb*****@aol.com> wrote in message
news:OT**************@TK2MSFTNGP12.phx.gbl...
My head is exploding with the 500 different ways shown on Microsoft's site
to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and PC users and have them access from a web site. These users not only have different
platforms (Mac and PC) but many have different versions of Excel (XP, 2002, 2003, 2000). What does Microsoft have out there that would be compatible
with all of the above differences??
I am open to VBA, VB.Net, ASP.NET, etc........

Nov 18 '05 #2
> ibeetb wrote:
"ibeetb" <tb*****@aol.com> wrote
My head is exploding with the 500 different ways shown on
Microsoft's site to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and
PC users and have them access from a web site. These users not only
have different platforms (Mac and PC) but many have different
versions of Excel (XP, 2002, 2003, 2000). What does Microsoft have
out there that would be compatible with all of the above
differences??
I am open to VBA, VB.Net, ASP.NET, etc........

By the way, I already have spreadsheets LOADED with vba code and
would like to use asp.net to make them interactive to users of varying
platforms.....any help would be appreciated


Make sure to check out Steve Orr's article on "Export to Excel -
Use ASP.NET to send functionally rich reports to your users."
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com
Nov 18 '05 #3
That's a tuffy right there. If you use the client-side spreadsheet it is a
com object so it should likely run on any COM supported platform. I'm not
sure of this simply because I haven't tried it

--
Regards,
Alvin Bruney
Got DotNet? Get it here...
http://www.networkip.net/dotnet/tidbits/default.htm
"ibeetb" <tb*****@aol.com> wrote in message
news:OT**************@TK2MSFTNGP12.phx.gbl...
My head is exploding with the 500 different ways shown on Microsoft's site
to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and PC users and have them access from a web site. These users not only have different
platforms (Mac and PC) but many have different versions of Excel (XP, 2002, 2003, 2000). What does Microsoft have out there that would be compatible
with all of the above differences??
I am open to VBA, VB.Net, ASP.NET, etc........

Nov 18 '05 #4
wasn't done yet,
If your strategy is to stream to the browser, the browser needs to support
the Mime type. I'm thinking this is your best bet. I'm not sure why I really
think that because I certainly have not tried it cross platform, but the
client side approach is troublesome even on supported platforms so it's a
good guess that it may more troublesome for cross platform.

--
Regards,
Alvin Bruney
Got DotNet? Get it here...
http://www.networkip.net/dotnet/tidbits/default.htm
"Alvin Bruney" <vapor at steaming post office> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...
That's a tuffy right there. If you use the client-side spreadsheet it is a
com object so it should likely run on any COM supported platform. I'm not
sure of this simply because I haven't tried it

--
Regards,
Alvin Bruney
Got DotNet? Get it here...
http://www.networkip.net/dotnet/tidbits/default.htm
"ibeetb" <tb*****@aol.com> wrote in message
news:OT**************@TK2MSFTNGP12.phx.gbl...
My head is exploding with the 500 different ways shown on Microsoft's site to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and PC

users
and have them access from a web site. These users not only have different platforms (Mac and PC) but many have different versions of Excel (XP,

2002,
2003, 2000). What does Microsoft have out there that would be compatible
with all of the above differences??
I am open to VBA, VB.Net, ASP.NET, etc........


Nov 18 '05 #5

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

Similar topics

52
by: Tony Marston | last post by:
Several months ago I started a thread with the title "What is/is not considered to be good OO programming" which started a long and interesting discussion. I have condensed the arguments into a...
1
by: Aiysha | last post by:
Hi, I want to take cotrol of notepad from excel (through VB programming). I have .prn files which have to opened in notepad and then I have to save these .prn files in .sim , all files format. ...
6
by: Luke Vogel | last post by:
Hi all ... could someone point me in the right direction for programming office applications (specifically excel) using vb.net? Can vb.net replace or enhance VBA that comes with the office suite?...
78
by: wkehowski | last post by:
The python code below generates a cartesian product subject to any logical combination of wildcard exclusions. For example, suppose I want to generate a cartesian product S^n, n>=3, of that...
8
by: Radu | last post by:
Hi, I have the following problem: I open a recordset based on excel/csv files, but then I need to filter (in code) in order to extract only data pertaining to a specific person. This code is...
10
by: sanou | last post by:
Hi does anyone know if the following is possible? I have an excel spreadsheet with values that i need transferred to a certain website's form. for instance, i have a value in excel spreadsheet...
2
by: hs | last post by:
I have copied some code that I am working on, I have a copy of what the page is suppose to look like, can anyone tell me what is wrong with my code. The first part is the code that I wrote and...
3
by: meetshashank | last post by:
I am learning Perl programming. I need to learn Perl programmimg for following pupose in my project : My project is having Sybase databse on Unix box. I need to get data from database from...
1
by: Darrenovic | last post by:
Hi, I'm using Vista and i have some issue that i need to know in order to do it efficiently in Ms SQL server 2008. I have an excel/word file with all the tables name in a column along their...
1
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.