Search results for query: *

What is wrong with this statement I keep getting an error invalid path or unknown path sub btnRun_onclick() dim filesys, newfolder, newfolderpath newfolderpath = "..\images\TAS\TAS_PayrollFiles\" & document.all ("cboCC").value & "" set...

I have the following: dim fso Dim newfolder Dim strFolder strFolder = "..\images\TAS\TAS_PayrollFiles\" & CCNum & "" set fso=CreateObject("Scripting.FileSystemObject") If Not filesys.FolderExists(strFolder) Then Set newfolder =...

How do i create a timestring with date time and the time being in military time. So far I have TAS_" & year(date())& month(date())& day(date()) & ".xls" But I need it to say 20040211_14:35:37

Hi I have written a code that would create a file and a link that opens up online into excel format. Now the problem is that I need to customize it. For example currently I am suing something like this For each x in rs.Fields strLine = strLine & x.name & chr(9) Next strLine = strLine &...

Hi I need to write a Case statement in saying if the difference between two fields ends up being a positive number then place in the code and the number the field. Then I will have another field to give me if the difference ends up being a negative number. I have no idea how to start this case...

Hi: What is wrong with this statement set f2=fso.CreateFolder ("U:\My Documents\CCNum",true) I need to create a folder called CCNum in this directory. Does anyone have any good websites on FSO

Hi: I have a text file that looks something like this: 0195393417 Jan 31 2004 12:24:03PM Z 0195393808 Jan 31 2004 12:34:11PM Z I need to import this text file into a table using either fso or csv. I do not know how to start this project. Please Help Thanks

Hi I am trying to figure out if there is a way to press a button and print automatically to the setting I need. The report that needs to print has to be setup in the page setup to legal size paper and then automatically print. so far I have this: function ZPrint() window.factory.PageSetup...

Hi I have an asp page that opens a report in excel format using Response.ContentType = "application/vnd.ms-excel" I need to know how can set the columns automatically so that when it opens up it doesn't look all unformatted. Thanks

Hi I need to know how to convert 01/01/2004 12:00:00 pm to 01/01/04 in T-sql. Thanks

Hi my aps page opens up an excel document but I need it to autofit the columns and have the row height to 13. How do you do that. So when excel opens up it looks nice and not jumble up. Thanks

Hi I have the following statement: strH(1) = strH(1) & &quot;<TR>&quot; & vbcrlf strH(1) = strH(1) & &quot;<TH bgcolor=#cccccc nowrap>Total Hours for &quot; & CCNum & &quot; </TH>&quot; strH(1) = strH(1) & &quot;<TH bgcolor=#cccccc> =sum(B2:B&quot;& intRowCount & &quot;)</TH>&quot; strH(1) =...

Hi I am using an array. I dim the array at the beginning and then redim the array again. I get this error This array is fixed or temporarily locked .... Part of my code goes something like this: Dim Code(1) strZ=&quot;Select 8 from tblOrders&quot; set rs = server.CreateObject...

Hi I need help writing this on T-SQL: TRANSFORM Sum(Data.dblHours) AS [The Value] SELECT A.LastName + ' , ' + A.FirstName AS Analyst, A.UID, M.LastName + ' , ' + M.FirstName AS Manager, A.CCNum, Data.dtsDate FROM ((TAS_PeopleDynamic AS A INNER JOIN TAS_PeopleDynamic AS M ON A.MgrUID = M.UID)...

How do you kill excel on the machine when you run another report that opens up excel. It is telling me it can not because exzcel is open already. Thanks

Hi: I have the following statement in t-sql: SELECT A.LastName + ' , ' + A.FirstName AS Analyst, A.UID, M.LastName + ' , ' + M.FirstName AS Manager, A.CCNum, TAS_TimeProdData.dtsDate, Sum(CASE WHEN TAS_validTimeProdCodes.TPCode IS NOT NULL THEN TAS_TimeProdData.dblHours ELSE 0 END) FROM...

Hi I was wondering if someone can help me with this thought process. I have a strSQL which would create something like this: Analyst Manager CCNum Total_Hours Category date ABC CBS 1867 5 System Down 01/01/04 and so on... I need it to list out something like this...

Hi: I am using this Response.ContentType &quot;application/vnd.ms-excel&quot; in my code to bring place an excel looking like document on the browser. But it seems not to be filling in the data. What can I do to make it fill in the data? <%@ Language=VBScript %> <% Response.Expires = -1000...

Hi: I have a recordset that I need to export to excel. It is telling me that my recordset is empty. Can someone glance over my code and tell me where I am wrong. Thanks <HTML> <HEAD> <TITLE>Create Tab Delimited Text File</TITLE> </HEAD> <body> <% OpenADOConn Dim strSQL Dim rs...

Hi everyone: How do I write code to export my data set to a text file on my C: drive in vbscript. Thank you Z