Recent content by Aurillius

Hi, I've got a column of cells with date/time values and I need to compare to an specific date and time in VBA. I'm using a CASE where cell.value appears to be stored as decimal. How do I format specific the date and time that I created to see if the cell date/time is before or after? Cell D2...

I answered my own question. The issue is (and is for probably many people), I included a backslash "\" at the end of my path "unzipToPath", this was for some other code. I spent way too much time debugging this and it was an easy fix. Mark

Hi, I've been searching through various forums on the web and then attempted to search for a solution on Tek-tips, no luck. I've also seen that many are getting the same error that I was getting. Using VBA within Excel, I want to open a zip archive and save to a selected folder. Here is my...

Thanks guys. I'll give these a try. Mark

Good Morning, I want to query a table that contains multiple appointments with time stamped status code changes for each appointment. Specifically, I need to pull the immediate next record in time, after the last "IN" status. Below, you see that in this case, "MT" is the next code after the...

I found something that I could use to achieve this...I'll share with the forum. ROW_NUMBER() over (partition by appt order by Date asc) Wrap another query around this and choose where row=1 Mark

Hi, I'm trying to create this query in Informix that will return the first row from each of these "Appt"'s. I originally wanted to find the minimum date but unfortunately, there are multiple PO's and Appt's that have the same date. I know that this should probably be simple but I can't seem to...

Hi everyone, I have a list of items that I would like spaced as evenly as possibly in a set number of rows. Eg. 7 items need to be spread over 51 rows (much larger in real circumstance). I hope that there is procedure that can work for several different circumstances. 1. Apple 2. 3. Banana...

Sorry, I should have answered that question first before explaining. I understand what programming logic is, the problem is that I haven't been able to build the logic...I only know the end result or how I want it to sort. Rand doesn't work as it bunches large numbers together...needs to be...

The data in the value column would be numbers ranging from 0 to 89. I will write code to give a standard value of "1" for values less than 20 and then 3 for values greater/equal to 20. The list could be 1 row or 5000 rows but I wouldn't run it on a list less than 50 rows. Then the list would be...

Hi Skip, The value column will be sorted ascending before I run the code. I want the script to assign a new row # to each of the values in column C which I can manually sort by this same column...C. Here is a better picture to show what I mean Mark

Hi, I have to move pick locations around in a facility to reduce congestion by spreading high volume locations out. I hope that someone can help me create some vba that will provide a sort column; this sort column would evenly spread values through a list. See the attached for the desired...

I just realized the problem. "A0010101" probably fails as it looks like a cell reference. If I use "_A0010101" it works.

Hi, I've tried searching through the forum but can't find a solution for the issue that I'm having. In Excel VBA (2007), I've created a routine to dymamically build a range and save into a string. Once the entire range is collected, I've attempted to create a named range but get a runtime...

Hi, I have created a unique number for my MS Access 2007 table. This number takes 3 of the existing fields and concatenates them together. The DB has a temporary import table which will only add records to the main table if the unique number doesn't exist in the master table. What I would...