Search results

Solved Thanks everyone I just needed to add vbhide and in the folder path I needed to add "\" so that dos see it as folder path. Cheers

Dear All, Thanks for helping... I have a function that I found while googling that catches that file file name and extension from a path. I would like to modify this to catch only the file name without the extension. here is the code: Function GetFilenameFromPath(ByVal strPath As String)...

OK, I got it to work but something on the way again! I put the code below: retval = Shell("xcopy " & filePath & " " & filePath2) but now I get a dos cmd prompet for every file asking if the object is a file or folder eventhough it is with extension .pdf at the end! how can I go around this...

I tried through cmd and it did work. see attached!

I tried the code to copy to log file but it doesnt do that either! maybe the xcopy code is wrong!

Hi again, I try to do the below, retval = Shell("XCOPY " & filePath & " " & filePath2 & " /E", vbHide) I dont get errors but no files were coppied! can you help me with the right code please? Thanks, Rami

Dear All, Thanks in advance for the help. I am trying to copy many files (reports as pdf) from one folder to another. I tried to do that with filecopy but the customers were complaining it takes too long. I try to use the shell command that makes the copy process faster as I heared. I took...

Thanks alot for the fast and accurate reply :D it worked

I am having an access database with field "examnumber", this is a text field. programatically I am trying to get the string and then add 1 to it then save a new one. example: the old exam number is GRT228, I want to get the last 3 digits from that string then covert it to number so it is read...