Search results

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...

I have an Excel file (XLSM) that has (498) fields. Row1 has field types. Row2 has the field names. Row3 is where the data starts. I have an Access table that has (20) of those fields. I am looking for a way to have the code skip the first two lines and import the data from the fields that...

I figured it out. Two of the fields have periods at the end of them: - Customer Part No. - MPA Part No. When I ran my code I would get an error that it could not find the field "Customer Part No#". It changed the period to the number sign. I went into the table and added the number sign to...

That did not work.

IDK. The people I do see stuff use VLOOKUP for everything. I am not concerned about how they used to it, I am focused on how I want to do it.

It is mine to deal with so that is what brought me here. Sometimes when questions like this are asked the replies become more about the way it should be instead of the way it is. I am stuck with the file they send me. They are not going to change it just for me.

I am fairly new at this company and this is the second one I have received. Initially I deleted row 1 and imported it manually to get the table created. Access dropped the periods in the field names during the import. I did not notice there were periods in the name until I tried to use the VBA...

The Excel files are supposed to come every month but they only come when there is a change. Is Excel Automation something I can add to the VBA in my Access database so it will work on the new sheets as they come?