Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel -The most efficient way
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........ PLEASE HELP!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel -The most efficient way
I think VBA would be your best bet. Creating an excel
object in a .NET lang is a little hard and I think not as good as VBA. But that is my opinion. Keith www.kjtfs.com -----Original Message----- 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........ PLEASE HELP!!!! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel -The most efficient way
You are probably right-I already have reports coded with VBA......but the
next step is getting them on the web and making them interactive...efficiently..thanks "Keith" wrote in message ... I think VBA would be your best bet. Creating an excel object in a .NET lang is a little hard and I think not as good as VBA. But that is my opinion. Keith www.kjtfs.com -----Original Message----- 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........ PLEASE HELP!!!! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Excel -The most efficient way
Programming XL (using automation) on a server is not recommended due to instability issues when serving multiple users. If you have access to ASP functionality (or any other server-side platform) then your best bet might be to run the queries as dynamic web pages, and have the code output the results to Excel by writing out an Excel header followed by an HTML table containing the data. http://www.15seconds.com/Issue/970515.htm http://www.aspalliance.com/articleVi...spx?aId=1&pId= Tim. "ibeetb" wrote in message ... You are probably right-I already have reports coded with VBA......but the next step is getting them on the web and making them interactive...efficiently..thanks "Keith" wrote in message ... I think VBA would be your best bet. Creating an excel object in a .NET lang is a little hard and I think not as good as VBA. But that is my opinion. Keith www.kjtfs.com -----Original Message----- 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........ PLEASE HELP!!!! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Efficient data clearance in Excel spreadsheets | Excel Discussion (Misc queries) | |||
Most efficient method in Excel? Mouse or Keyboard keys? | Excel Discussion (Misc queries) | |||
What is more efficient | Excel Discussion (Misc queries) | |||
Excel Randoming Becoming More Efficient | Excel Worksheet Functions | |||
is there a more efficient formula than... | Excel Worksheet Functions |