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 ("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 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 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("A") + i)
Response.Write "<TH bgcolor=#cccccc> =sum(" & strCol &...
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.