Search results for query: *

I'm trying to write a script to check a files date and time so i know its ready to upload. I'm not sure what im doing wrong but i need to check if the file is greater than 10:00AM and also greater than yest date. Dim objFS, strFile Set objFS = CreateObject("Scripting.FileSystemObject")...

Hi, Was wondering if someone can help I'm attempting to write a vbscript to check if the file size is bigger than 9,000KB if it is then msg me back the file is bigger than 9,000kb else the file is under 9,000kb.I plan on emailing myself but im fine with the email portion. Dim maxFileSize...

i need help i tried the following in VBS to remove the filter and nothing works .usedrange.autofilter .Range("A1:B1").AutoFilter both dont remove the filter in row 1

i have most of my code created im just having trouble coverting this to work in my vbs script. can anyone help? ActiveSheet.PivotTables("Pivot Table").PivotSelect "Year[All;Total]", _ xlDataAndLabel, True With Selection.Interior .Pattern = xlSolid...

i wanted to check AD for yesterday's date using an if statement if the column has yest date or if it doesn't i know in vba i have it written like so just dont know how to conver it to vbs Sub Macro1() For Each cell In Range("AD1:AD" & Cells(Rows.Count, "AD").End(xlUp).Row) If...

Im trying to write a vbs script to Search for the word TOTAL and delete the enitre row if the word exist. also delete coumn S and remove filters

i not sure how to do this but im trying to have my vbs script check if row 2 is empty in my Arrow.xls file. if its empty i want it to email from a template with the file and if there nothing in row 2 i want it to email from a different template. so i need to check row two and email using two...

im trying to have the code to wait for the page to fully load before it goes on to the next command. sleep command doesnt work great since the page can sometimes take longer then the sleep timer. please can someone help me? Dim oIE, Set oIE =...

Hi, I'm writing a vbs script to automate through a webpage. I was hoping someone can help me with selecting from a drop box list from IE webpage.I'm able to change the value but its not submitting it or updating the page with the year i selected. the source code on the web page is the...