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!

Register Log in
  • Congratulations Chriss Miller 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. firefytr

    An Excel Structured Table Conundrum

    I know this is old, but I just saw it. Besides your workaround your only other option is VBA, which is a PITA in its own rite. You could use VBA to set the headers static from a set of formulas. You can return an ADO recordset to a table, just delete the data (DataBodyRange) first. Some...
  2. firefytr

    Is there a cross-compiler for Excel?

    Depending on the language you're using, and I'm not fluent with F#, you would really only need to reference the Excel OL to have access to do whatever you want with the file. This really isn't an Excel question at all, or even an Office question. From what I gather you're trying to read an...
  3. firefytr

    Is there a cross-compiler for Excel?

    That makes a lot more sense. :) In the core sense of the question, it depends on the platform you're using. Think of Visual Studio - you have multiple languages, all run through the CLR and become compiled. I think your question really should have been something along the lines of, "Where is...
  4. firefytr

    dependent Drop down lists

    Hi there, There is a lot of help on this topic on the web. Here are some links... http://www.contextures.com/xlDataVal02.html http://www.contextures.com/xlDataVal13.html http://office.microsoft.com/en-us/excel-help/use-validation-to-create-dependent-lists-HA010285033.aspx...
  5. firefytr

    Is there a cross-compiler for Excel?

    I'm not sure I agree with all of the points you make. Any coding in Excel is VBA. Sure you could get fancy and call upon other languages from the VBIDE (in Excel, or any Office application), I'm not sure you'd want to though. I'm with mintjulep on that one, there are many languages you can...
  6. firefytr

    Is there a cross-compiler for Excel?

    Seems rather over-complicated to me. This still all depends on where you're trying to do this from. You've given more about your data structure in Excel, which is good, but it still depends on what you're needing it for. If you're using another programming language, and I'm still not sure if...
  7. firefytr

    Is there a cross-compiler for Excel?

    Well, it's hard to say with any certainty, since we really don't know what it is exactly you're wanting to do, other than some form of a calculation. If you're using another programming language, then I'm not sure if you'd need Excel at all, but that depends on what you're dealing with and the...
  8. firefytr

    Excel 2010 Copy-Paste SUMIF Slow

    Have you ever thought of using a pivot table with this data source? I don't know how your data is structured though, which could be problemmatic (depending, of course). I'm a big fan of using tables, as Skip suggested. The structured table referencing is very nice. Here is some good...
  9. firefytr

    (IF(ISNA(MATCH along with named range array and sumproduct

    You can just simply use... =COUNT(MATCH(JAN!$D$2:$D1000,UNITS,0)) Also, array-entered, to simply get a count of values which do not match. If you do have blanks in UNITS range this formula will still work, as it won't count blanks. HTH Regards, Zack Barresse Simplicity is the ultimate...
  10. firefytr

    Is there a cross-compiler for Excel?

    Hello, Can you be more specific? What are you trying to do here exactly? Are you wanting to view Excel, but not using Excel? Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  11. firefytr

    Excel Range issue

    Best way to get started is actually the macro recorder. Just know that it is highly inefficient. :) Zack Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  12. firefytr

    Correcting errors from 'Change Case' format

    Hi there, You could do this with a UDF... Function ProperCase(vText As Variant) As String Dim sText As String sText = WorksheetFunction.Proper(CStr(Trim(vText))) If Len(sText) <= 2 Then GoTo ExitFunction If sText Like "Mc*" Then sText = "Mc" & UCase(Mid(sText, 3, 1)) &...
  13. firefytr

    Data Validation - all caps and no periods

    You can still use Data Validation for this, just use an additional function test to see if there are any periods... =(EXACT(L63,UPPER(L63)))*(LEN(L63)=LEN(SUBSTITUTE(L63,".",""))) Of course the trouble comes into play if you want a whole list of characters not allowed in cell entry. If that...
  14. firefytr

    Excel - Using SumIf with a date range

    Hi there, Have you thought about using a PivotTable for this? I'm not sure why you're wanting this, or what your data source looks like, but they're pretty handy-dandy. :) Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  15. firefytr

    Excel 2010 to send email with attached PDF

    Hi there, You could use something a little more efficient. This should run a little faster for you. It cleans up the PDF file afterwards and displays the email with it attached. Set the subject and recipient(s) as desired. Option Explicit Sub EmailAsPDF() Dim WB...
  16. firefytr

    personal.xlsb not opening from xlstart in Excel 2010

    You don't want to change the extension of the file to "xlsa". It is not a valid file extension. If you have your Folder options to show file extensions (folder - Alt, Tools, Options, View tab), you will be able to see a renamed file of "Book.xlsb" to "Book.xlsa" will in fact be...
  17. firefytr

    Problem with VBA code under Excel 2007

    Does adding "VBA." in front of the Format( help? I'm assuming no MISSING references were found?? Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  18. firefytr

    Disable Rename Sheet in Excel 2007

    I highly doubt that. But good luck. Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  19. firefytr

    Disable Rename Sheet in Excel 2007

    May I ask why you did not install the SP? Regards, Zack Barresse Simplicity is the ultimate sophistication. What is a MS MVP? - Leonardo da Vinci
  20. firefytr

    Trouble with Excel Range syntax using variables

    If you're going to use the With statement, you might as well qualify your range. And there is no need to Select anything. I would also recommend checking if the sheet was created before creating it. Here is an example with your partial code... Sub TekTipsTest() Dim i As Long Dim...

Part and Inventory Search

Back
Top