Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ebes1099

    Join error for date range

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

    Subscript out of Range when using Sheet CODENAME

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

    Format File Help

    Awesome, thank you sir.
  4. Ebes1099

    Format File Help

    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?
  5. Ebes1099

    Format File Help

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

    Format File Help

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

    Format File Help

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

    Format File Help

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

    Comparing cells in different columns

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

    Comparing cells in different columns

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

    Comparing cells in different columns

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

    Comparing cells in different columns

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

    Comparing cells in different columns

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

    Comparing cells in different columns

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

    Method for Break Links not working

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

    Method for Break Links not working

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

    Method for Break Links not working

    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 '...
  18. Ebes1099

    Break Links not working

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

    Break Links not working

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

    Bypass User Input from someone else's Macro

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

Part and Inventory Search

Back
Top