January 9, 2009 01:52am pst

1. angelIII 87,325
2. BrandonG... 86,950
3. Juan_Bar... 76,100
4. capricorn1 64,298
5. LSMCons... 57,907
6. chapmandew 52,260
7. boag2000 52,220
8. tigin44 50,155
9. mwvisa1 49,195
10. Zyloch 39,025
11. mlmcc 35,650
12. DatabaseMX 35,272
13. WhiteMeat 33,800
14. ushastry 33,100
15. TheLearn... 32,355
16. expertsoul 29,495
17. Sharath_... 29,100
18. DropZone 27,920
19. mark_wills 27,825
20. objects 26,780
21. RobSamp... 25,500
22. acperkins 25,165
23. jpaulino 24,400
24. Idle_Mind 24,250
25. emoreau 24,094

1. angelIII 23,225,471
2. TheLearn... 11,578,378
3. capricorn1 11,537,516
4. objects 10,825,008
5. jkr 10,398,335
6. mlmcc 8,906,724
7. CEHJ 8,502,949
8. Idle_Mind 7,739,175
9. peter57r 6,554,390
10. ozo 6,464,478
11. Zvonko 6,306,533
12. rockiroads 6,048,161
13. aneeshatti... 5,828,679
14. nico5038 5,808,250
15. acperkins 5,593,328
16. LSMCons... 5,186,317
17. mplungjan 4,685,261
18. emoreau 4,635,866
19. AlexFM 4,598,613
20. jaime_oliv... 4,532,506
21. ScottPletc... 4,398,222
22. chapmandew 4,310,592
23. jimhorn 4,202,391
24. DatabaseMX 4,198,809
25. hielo 3,851,978

04.08.2004 at 07:38AM PDT, ID: 20947824

	[x] Attachment Details

VBScript......CreateObject("Excel.Application") is failing when run in web page.

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.8

Zones:

Miscellaneous Programming, VB Script

Tags:

vbscript

I wrote a vbscript that I need to run (client side) everytime someone visits an intranet page. Basically the vbs creates an excel.application object writes some data to the spreadsheet and then saves it. I created a test html page and inserted the vbscript and it works fine when I run it from my pc. But if I try to run it from a server, or even another computer it fails when it tries to create the excel.application object. It says the activeX object couldn't be created. Why? Can someone help please?? Here is some test vbs code I inserted into a test page, it fails when I run it from anywhere but my pc.

<Script language="vbscript">

Dim objexcel

Set objExcel = createobject("Excel.application") <----------- This is where it's failing

objexcel.Visible = True

objexcel.Workbooks.add

objexcel.Cells(1, 1).Value = "Testing"

objexcel.ActiveWorkbook.SaveAs("c:\exceltest.xls")
objexcel.Quit

</SCRIPT>

#	Title
1	VBScript
2	CreateObject in C#
3	How to manipulate Excel in ActiveX vb…
4	Need help with Excel form data automa…
5	vbscript to filter and export data from E…
6	CreateObject...