User Profile
Collapse
-
do you want to start te two exe files together?... -
You have a table with records that has a colunm containing 1250 as value in a field and you want to updat that value with +1 and then you want to have a second table to look for that particular value(1251) in the first table?...Leave a comment:
-
Sorry, wrong code! find the correct code below
For Each objFile In objFolder.Files
If objFso.GetExten sionName(objFil e.Path) = "xls" Then
Set objWorkbook = objExcel.Workbo oks.Open(objFil e.Path)
naam = objWorkbook.Nam e
objWorkbook.wor ksheets("Assess ment").Activate
If objWorkbook.wor ksheets("Assess ment").Range("F 60").Value <= 3 Then...Leave a comment:
-
Not much wrong really, you missed a "if/then" statement to print the workbook yes or no, and you used "cells" instead of "range" to point to the location of the cell in the sheet. Range always requires quotes "F60" if not populated as variable.
if it does not work on your side then let me know the errormessage.
Set objFso = CreateObject("S cripting.FileSy stemObject")...Leave a comment:
-
-
-
Hi,
I guess you mean new empty rows or do you mean rows containing data....Leave a comment:
-
No activity results to display
Show More
Leave a comment: