i got the solution. I can not use fileexists becaseu i am checking if there is file in the folder or not as i dont know the file name. Solution is: for loop to count file in the folder.
Hi,
I need to check if .doc file exist in a folder called My Documents but it seems to be not working. dont know what am i going wrong:
Set filesys = CreateObject("Scripting.FileSystemObject")
Set NewFolder = filesys.GetFolder("C:\My Documents")
If filesys.FileExists(NewFolder & "\") Then...
Hi,
I have macro below which converts .doc to .him. Can anyone write me a VBScrpit using this or your own programmin knowledge? I would really appriciate your time.
thaks.
Sub SaveToHTML()
'
' SaveToHTML Macro
Dim inputFolder As String, outputFolder As String
Dim docFile As String...
LB,
Your idea works and i what did is i calcuated average of all fields and checked against average.
Question: Where you find correspoinding number for different inches, you said 1 inch = -1440. I need to set to .5 inch.
thanks.
I have about 18 columns and i can suppress columns if there is no values. I want to know how would i move column2 to it's left if column1 is empty?
This is what i have:
Name Orders Address
asc 1213 E
512 546 W
This What i Want:
Name Address
asc 1213...
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.