Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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