Search results

@Ken Sheridan - the second code set worked. Thanks for your help. It is weird how the codes worked fine on some numbers and not on others.

@Ken Sheridan - I am working with (35) numbers. I used RoundUp([MyFieldName], 0.01) It did (34) of them correctly. For some reason it made 2.47 into 2.48. I checked the cell to see if there was space or anything at the end and there was nothing.

I am not sure what you are asking?

Good morning everyone. I am using this VBA a google search provided: Public Function RoundUp(ByVal Num As Double, ByVal Decimals As Integer) As Double Dim Factor As Double Factor = 10 ^ Decimals RoundUp = -Int(-Num * Factor) / Factor End Function I am getting inconsistent results...

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

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