Recent content by EzGoingKev

OK thanks.

Another question on this. Here is what I am using: dir "%~dp0" /b > "%USERPROFILE%\Desktop\list.txt" I am dealing with images. Is there a command that will give me the directory and the images resolution?

Once I changed the folder location your script works 100%. If I understand the code correctly it writes the file names into the text file one at a time. The folders I want to use these on contain product images. Some of them have over 36k images in them. It takes a little bit for the script to...

Yes. The BAT file appends "Windows" to the file name instead of the actual folder name.

That did not help me.

It is a subfolder.

Because I did not know that it made a difference.

I tried it on a folder on my local machine and it appends the folder name like it is supposed. When I use it on the server it appends "Windows" to the file name.

That got me this: ETA - I just noticed it created the file in the folder not on my desktop so I changed this line of code: set ts= fso.createtextfile(strDesktopPath & "\" & strFolderCurrentName & "_" & "list.txt") It ran and I did not get the error message.

That created a file named "Windows_list.txt"

OK thanks.

Thanks for the reply. I do not know what a VBScript file is. A couple of things first. Anyone can just click on the BAT file and it will create a file on their desktop name list.txt that has the folder's directory in it. I am looking for something that all the user has to do is click on it...

Good afternoon. I have BAT file that creates a text file with directory of the folder that it is in and puts in on the desktop. Here is the code: dir "%~dp0" /b > "%USERPROFILE%\Desktop\list.txt" This works 100% for me but I would like to append the name of the folder the BAT file is in to...

I know where they are right now. The sheet is an export from a customer's system. For the stuff I need the names will be constant. The export is from customer's system. The customer is always adding/removing/moving fields around so I do not want to use a range.

I am not comfortable with Excel for anything complex. My goal is to not open the Excel file at all. I know I can using SQL's INSERT INTO by manually listing the field names I want. Is there a way to automate something like that - instead of typing out all (20) field names code can select them...