temp

Hello all. I have a fairly large data set (30,000 lines -will grow to 50,000) which is a set of employee payroll records. I am hoping to identify a particular type of rule violation - when a worker who has worked both as a "Temp" and as a "Part-Time" has worked hours in violation of the rule...

So I'm trying to add a row of cells that contain both letters and numbers. I'm using the following macros: Function add_num(cell1, ParamArray Arr() As Variant) Dim temp As Double For i = LBound(Arr) To UBound(Arr) temp = temp + GetNumber(Arr(i)) Next add_num =...

Hello: I need a sub to input last month's date into a column of data and then hard code the date. The only solution I came up with is below, but I'm wondering why it's not creating a circular reference. Thank you! I'm sure it has something to do with equivalency, but I'm still new! Sub temp()...

<colgroup><col span="2"><col span="2"></colgroup><tbody> 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 6 6 6 6 7 7 7 7 8 8 8 8 9 9 9 9 </tbody> Code: Function ListPermut(num As Integer) 'Permutations without repetition Dim c As Long, r As Long, p As Long Dim rng() As...

So I am currently working a project and I and I need to create verify text given through an input box against an SQL result. If the number "15" is entered and the sql table contains 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 I need it to save the number variable if a match is found and if not I need...

I am trying to convert a C language code to VBA. The converted VBA UDF code is: Public Function Poisson2( _ Optional ByVal C As Double = 4) As Long If C <= 0# Then Exit Function Dim d As Double, beta As Double, alpha As Double, k As Double, u As Double, v As Double, x As...

Good day all, This is my first post and I am looking for some help with VBA. I am new to coding and macros so what I have below has been copied from other posts on this site but it does't seem to work as I had hoped. Desired function: I have a Macro Enabled Template workbook, "MODIFICATION...

After a year as a temp (it was supposed to be 2 months) I am moving on, going back to Purchasing, this time at a Level ! Trauma Center. The project I did and re did and re did is now ready for prime time. To all the wonderful folks who answered my questions and showed me the way, thank you from...

Hi I made a spelling mistake in the code below but still working fine. the currentpostion in the loop For x = currentpostion To Len(phrase) is wrong spelling. I stepped in the code and it is always 0. However, the code worked fine. Why is that? Thank you Sub onlynumber() Dim phrase As...

Hi I am trying to understand the code below. I have 2 questions now 1) What is the idea of using Mid() function 2) What does &amp mean. Temp=Temp&amp;Mid(Phrase,Current_Pos,1) Function Extract_Number_from_Text(Phrase As String) As Double Dim Length_of_String As Integer Dim Current_Pos As...

I have some code that downloads pdf sheets at hte push of a button. The code works like a champ but (I presume because my internet connection is beyond super slow (satellite, 0.34mbps download....), excel goes into a "not responding" mode until the download completes. Is there any way to fix...

If I have this piece of code to reference each row in a continuing loop, how would I write to reference just the same row for which the button was hit (i.e. if a button was over cell a1, then it would run the code for a the row 1, but if the same code was run for a button in a4, it would run the...

I'd like to change the following code so that instead of going every row, it will allow the button on that row to run the code for just that row (if this makes sense). Basically I have two macros- one that checks every row (in a certain column) for data and if something is there, makes a button...

So my code was working perfectly last week (when it ran for the first time. Now it says it can't find the "temp" folder that it created....and I see the folder on teh desktop. It's bugging out at the "Kill (TempFolderOLD) line. Ideas? Sub Downloadx()Dim URL As String Dim tstamp As String Dim...

With a little help, I've written some code. The intention of this is to perform weekly updates of a downloadable file. This macro, if it works, will be copied over and over (unless someone has a better way, PLEASE!) so that roughly 25 different files can be downloaded individually and/or...

Hi Everyone I have a code that suppose to make the combobox in the userform searchable found this code in the internet but the subscript error out of range occurred. I already changed the worksheet name to the existing worksheet but still there is an error. can anyone please help me resolved the...

Hi Community, Hoping you can help with an error i'm encountering when running a script to create a temporary copy of the workbook > attach it to email and send using outlook. I get an error on: TempFilePath = Environ$("temp") & "" The exact error message is: "Compile Error Can't Find project...

Hi, I have the following macro that copies the master sheet and adds a sequential number every time its run. I also need it to replicate the sheet number in cell S13. My macro works but for some reason the sheet numbers change after i insert the second sheet. The worksheet numbers represent the...

I've made a workbook in Excel for Windows, and am now trying to get it to work on Excel for Mac. One option I have given the user is to output certain sheets into a single PDF file. Due to a problem with Excel for Mac, I've had to write code to output each worksheet as a separate PDF file. I...

How can I add to this formula to find the closest result in my temp. column? If I enter an exact temperature it will return the correct result. Ex: -17.56 = 1.11759 My formula is: =INDEX(C2:C8, MATCH(G2&G3, A2:A8&B2:B8, 0)) Any help would be appreciated...