Hi All,
I have a crystal report(.rpt file). I need to export that to excel in my vb(6.0) application. Everything works great. The only issue i have is, when i export the file to excel, the Page Header is not getting exported. So the excel has only the data without column names.
Any ideas...
Hi,
I am trying to create a VSS object. using the following code
Set vssObj = Server.CreateObject("SourceSafe")
vssObj.Open "\\myserver\srcsafe.ini",userId, ""
However i get the following error, at the open statement
Microsoft VBScript runtime error '800a0007' Out of memory
Any idea... i am...
Hi
"SELECT MIN(SPID) FROM SYSPROCESSES WHERE DBID= <ID OF A DATABASE>"
What is the possibility of getting a SPID 5 (which is a task manager - system process) while using a query specified above. Provided a database id is specified in the where clause
I used a above specified query...
hi,
I need to write a function that would store the userid in a cookie on the users machine and automatically fill it when the user visits the same website.How do i do this!!!!....help
Thanks
Hi All,
Need some urgent help..
I optimizing Stored Procedures. The current database is of 5 GB in size and a specific tables have more than a million records. And this is just the sample db. The original has more than 20 to 30 million records and expected to grow at the rate of 5 million record...
Hi All
I have a html page with two frames and a print button in one frame.On the click event of this print button i shld be able to print the contents of both the frame in one page.Is it possible to do this operation..coz the window.print option prints the contents of the frame which...
I have an ASP page with multiple windows. I need to print the contents of all the frames using a Print button.
"window.print() or top.print() or parent.window.print()" is not helping me.
Hi,
I am in a critical state..somebody pls help me.
I need to import data from a DB2/AS400 to a SQL Server7.0
I have no knowledge of DB2/AS400.
Anybody aware of a solution, pls let me know asap.
Thanks
Hi all
i am using a vb component to generate report in excel...iam calling this component from asp......some properties which wrk fine in vb does not wrk in asp...like
the page set up property....wht can be done..
Hi All,
Iam new to asp programming ........Iam using a vb component to export datas to excel sheet .....Iam calling this component from ASP...the code seems to wrk fine when I run the asp file for the first time......but its not wrking later...it gives the following error ~method ~object not...
Hi
I am trying to import data from an excel sheet to Spreadsheet control.Following code gives Dr.watson error sometimes during the connection.Else its asking for sql statements like insert delete update
Dim vConnString as String
Dim Conn as adodb.Connection
dim oRs as adodb.RecordSet...
Hi
see i have some information like this in excel
1 | 2 | 3 | 4 | 5 each one in a row
is there an option in excel to cahnge this data to
1
________
2
_________
3
_________
4
________
each in column
thanx
I want to copy excel sheets that are present in differnt workbooks ..... will I be able to write a macro to open the excel workbook from diffrent location and copy their worksheets to a new workbook.Plz reply asap.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.