Search results for query: *

I am trying to join two tables on ID1, ID2 and when Date > Start AND < End but I keep getting an error when I add the date fields in. Just joining on ID1 and ID2 works fine, but I'm of course getting duplicated records because in my right table I can have two lines for ID1, ID2 with a different...

I'm not understanding why this line of code gives me a Subscript out of Range error. I'm using the sheet CODENAME because the tab name in Excel gets changed occasionally. If I use the actual tab name in excel it doesn't give me any errors. "MA_BPT_Rng" is a named range in my workbook. I've...

Awesome, thank you sir.

George, Can I then create my table in SQL with data types of int/money/varchar and it will still import into them even if the format file says SQLCHAR for that field?

Here's the .csv http://files.engineering.com/getfile.aspx?folder=655812cd-bcaf-4878-85d9-2c36b6df81ea&file=IP_Data_Sample.csv

I've made a few tweaks and actually completed an upload. It still isn't working as expected though. What I did was go into my CSV tables and format all of the currency fields as Number format without a comma separating the thousands and using the -1234.56 style for negative numbers. Same thing...

I forgot to attach the data example. Here it is. http://files.engineering.com/getfile.aspx?folder=b7a9933f-c92a-48b2-b01c-b29c87629c6e&file=IP_Data_Example.xlsx

I'm trying to create a Format File for a bulk insert into SQL because I have a comma delimited file with some currency fields that have a comma to separate the thousands and it's causing issues on import. The currency fields have a text qualifier of a ". I've attempted to write an import file...

That's what I figured...thanks for the help.

Skip, I ended up doing this, where Code is my named range row where the Code values are and Selected is my named range row where the Selected Values are. =IF(COUNTIFS(Code,INDEX(Code,MATCH(1,Selected,0)),Selected,1)>=SUM(Selected),INDEX(Code,MATCH(1,Selected,0)),"Mixed") The issue is there...

Skip, I'll just use an Index-Match to find the first cell with a 1 in the Selected row. Thanks for the help.

Skip, that works awesome if I have a defined value for Combined Value. But I don't necessarily know what that will be, in my example case I highlighted that cell in Yellow with a fixed value in because that's what I wanted the result to be. In reality, it could be any of the values in that row...

I've attached an example of what it could look like in a couple different scenarios. The Selected row with 1's and 0's will be dynamic and based on user inputs on another tab. There could be up to 50 columns so a few simple if statements won't work. I think something with COUNTIFS might...

I have a number of columns that contain a letter and I want to be able to check if all letters of "selected" columns match. I'm using an indicator in row 2 with either a '1' or '0' to indicate whether the column is selected. I know the Exact function will return a True or False for comparing...

Skip, Nevermind, the change you suggested is working. I changed that subroutine in my code but the call to it in my main Sub was still commented out so I didn't think it worked. Thank you for the help.

Skip, The array shouldn't be empty, there are links in the workbook that I want to be broken. It's not seeing them and breaking them.

I've used this code in the past on a workbook and I can't figure out why it's not working now. I can't even break the links by selecting the "Edit Links" button in the Ribbon and clicking Break Links in that prompt. Sub BreakLinks() Dim vLinks As Variant Dim lLink As Long '...

You are right, it should be in the other forum, it was late last night and I clicked the wrong forum.

I've used this code in the past on a workbook and I can't figure out why it's not working now. I can't even break the links by selecting the "Edit Links" button in the Ribbon and clicking Break Links in that prompt. Sub BreakLinks() Dim vLinks As Variant Dim lLink As Long ' Define...

Can you tell me how to use the workbook name in a Application.Run call instead of hard coding the path in there. This works Application.Run "'Book1 Test.xlsm'!Pub_btnLoadPlan_Click" But this doesnt Dim wb_Name As String wb_Name = "Book1 Test.xlsm" Application.Run wb_Name!Pub_btnLoadPlan_Click...