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 &...

I figured it out thanks I did: 'P/R Code'=(Case When TC.dblHoursW1_PR-TC.dblHoursW1 > 0 Then TC.PayrollID else null end), '(+) Hours'=(Case When TC.dblHoursW1_PR-TC.dblHoursW1 > 0 Then TC.dblHoursW1_PR-TC.dblHoursW1 else null end), 'P/R Code'=(Case When TC.dblHoursW1_PR-TC.dblHoursW1 < 0 Then...

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 (&quot;U:\My Documents\CCNum&quot;,true) I need to create a folder called CCNum in this directory. Does anyone have any good websites on FSO

Yes I can do that But I need to write it in code instead of doing a import routine from access. But Thanks

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

Not that I know of if it does can you tell me where?

Microsoft Interdev

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...

Thank you your website helped me out a lot Bull. Thanks

Hi I have an asp page that opens a report in excel format using Response.ContentType = &quot;application/vnd.ms-excel&quot; 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

Hey Cool Thanks Mark. I wanted to know does anyone know how to make the columns automatically autofit when the excel document opens up. Cool 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

I figured it out thanks it was Chr. Cool

Hi thank you it looks like it is picking up stuff but the columns are incorrect bascially giving me =sum(662:665) in each column. it should be =sum(A2:A5) For i = 1 To intRowCount strCol = CStr(Asc(&quot;A&quot;) + i) Response.Write &quot;<TH bgcolor=#cccccc> =sum(&quot; & strCol &...

Thank You PHV it worked. I forgot you can set an array. I was thinking yesterday. Thanks