Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
what does pk ??? mean ???
when I run the code below I get the result pk??? but what does it mean ? it should echo all the value's in the xlsx Option Explicit 'Force explicit variable declaration 'decales variable Dim fso Set fso = CreateObject("Scripting.FileSystemObject") Dim strPath, RootFolder, objFolder, colFiles... -
file exists doesn't work how it supposed to be
true it looks almost the same but there is a kind of difference. now it copies the files where it first got an error the hole time:) -
file exists doesn't work how it supposed to be
thnx guys, the problem is solved. it now works perfectly. here is the script wich is working: Option Explicit 'Force explicit variable declaration 'declare variable Dim fso : Set fso = CreateObject("Scripting.FileSystemObject") Dim sourceFolder : sourceFolder = Array ("D:\sourceFolder... -
file exists doesn't work how it supposed to be
well... i already found out that the problem lies in the destinationfolder where you wan't to copy to ' example: fso.CopyFile dubble(sourceFolder(RFcounter) & "\" & file), dubble(targetFolderFTP(RFcounter)) & "\" & file 'Moves files dubble(sourceFolder(RFcounter) & "\" & file) =... -
file exists doesn't work how it supposed to be
ok.. first its echo's all the files in the direcorty's (that are in the array). then it checks if the file exits and if it exits it delete's it at the targetfolder after that its checking if the file extension is .TIF if its a .Tif file it should run one of the two subs (methodOne & methodTwo)... -
file exists doesn't work how it supposed to be
ok.. its seems you are wright, you don't need it to be double quoted. for the fso.fileexists. However, when you call the sub methodOne() and sub methodTwo() it doen't copy. what ever i try just the both code doesn't work: 'Movefiles Sub moveBestanden() fso.MoveFile sourceFolder(RFcounter) &... -
file exists doesn't work how it supposed to be
it loops to echo all the files in de directory's from the array sourceFolder een & souceFolder Two. Then it has to check if the file exists in that dictory (the derectory is based on the RFcounter). when it exits it should run the sub deletefilesfromtargetFolder. however its still keeps saying... -
file exists doesn't work how it supposed to be
Option Explicit 'Force explicit variable declaration 'declare variable Dim fso : Set fso = CreateObject("Scripting.FileSystemObject") Dim sourceFolder : sourceFolder = Array ("D:\sourceFolder Een","D:\sourceFolder Twee") Dim targetFolder : targetFolder = Array("D:\Dest Een","D:\Dest Twee") Dim...
