Trushna.Palo
New Member
- Joined
- Jul 24, 2008
- Messages
- 3
The similar post is already posted in site.But since I am new to ASP I couldnt get the complete code.So help is highly appreciated.
My issue is on click of a button in a ASP page the predefined excel template should open with with the column filled up by the data which comes from the previous ASP page.
Let me tell you in details.I have a ASP page called "riskonloadexcel.asp" and a Submit button "Export to Excel" in it.On click of Export to Excel the template "Risk_Mgmt.xls" should open with the data filled up in it column which comes from "riskonloadexcel.asp" .
I tried using this subroutine:
Sub Test()
Dim wbNew As Workbook
Set wbNew = Workbooks.Add(Template:="D:\Risk_Mgmt.xls")
MsgBox wbNew.Name
End Sub
But it didnt work.
Can you tell me in details how to make it work.
If I can get the reply by tomorrow it would be really great as my delivery is pending bcoz of this.
Thanks in advance..
Trushna
My issue is on click of a button in a ASP page the predefined excel template should open with with the column filled up by the data which comes from the previous ASP page.
Let me tell you in details.I have a ASP page called "riskonloadexcel.asp" and a Submit button "Export to Excel" in it.On click of Export to Excel the template "Risk_Mgmt.xls" should open with the data filled up in it column which comes from "riskonloadexcel.asp" .
I tried using this subroutine:
Sub Test()
Dim wbNew As Workbook
Set wbNew = Workbooks.Add(Template:="D:\Risk_Mgmt.xls")
MsgBox wbNew.Name
End Sub
But it didnt work.
Can you tell me in details how to make it work.
If I can get the reply by tomorrow it would be really great as my delivery is pending bcoz of this.
Thanks in advance..
Trushna
Last edited: