Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 4th, 2006, 10:11 PM
Authorized User
 
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel automation from aspx page

Hi,
I'm stuck to automate some functionality of Excel form my ASPx page.
I can launch an instance of Excel and also inserting data to a cell. However, I couldn't move a sheet.

I found this example in VBA document:
" Sheets(Array("Sheet4", "Sheet5")).Move before:=Sheets(1) "

But My problem is that how to change it to a Visual Basic statement in my aspx page ?
 
Old April 5th, 2006, 03:17 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

check out http://www.greggriffiths.org/webdev/both/excel/ which covers automation of this type.
 
Old April 6th, 2006, 01:03 AM
Authorized User
 
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Greg
That was quite useful. However, how can I convert VBA statements like those we see in Macro editor of Excel, to VB statements ?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Automation MAKO C# 0 August 16th, 2006 01:05 PM
How do you embed Excel in an aspx page? Mathew ASP.NET 2.0 Basics 0 July 17th, 2006 03:29 PM
Automation with Access and Excel venomm Access 2 March 20th, 2005 11:34 AM
Excel Automation ameysun C# 0 November 4th, 2004 07:33 AM
Excel Automation ameysun Pro VB 6 0 November 4th, 2004 02:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.