• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    How to zip excel files using VBA?

    Here is the code I use: http://www.rondebruin.nl/windowsxpzip.htm
  2. J

    Giving Link To Outlook Mail with The Excel

    Instead of asking for the entire code, please let us know what you've already tried and specifically what you need help with. "Please write the code for me" isn't going to inspire many people to try and help. You've left out important details that would allow anyone to even begin to assist...
  3. J

    Opening a Userform within a Userform?

    What is your actual goal and why does it require this workflow?
  4. J

    Tab on over!

    You could create a data entry area by locking and hiding all cells, then unlocking and unhiding the cells you want to allow editing in, then protecting the worksheet. I have a VBA based approach here...
  5. J

    Hiding Application Title Bar?

    A quick Google search produced numerous links with the code you need: http://www.mrexcel.com/forum/showthread.php?t=6148 http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/736155c6-1e55-415c-add0-8d95d3e29212/ http://www.eileenslounge.com/viewtopic.php?f=27&t=1986
  6. J

    For Excel Ninjas Only --Plus anyone else who is REALLY up for a challenge... :)

    I like the Solver solution. Thought about that but went with formulas instead.
  7. J

    For Excel Ninjas Only --Plus anyone else who is REALLY up for a challenge... :)

    A1:A5 contains your values: 23, 46, 67, 12, 56 This formula calculates how much you need to add to each value to reach 250: =(250-SUM(A1:A5))/COUNTA(A1:A5) Add this to each cell's value to get the new value, i.e. in cell B1 put "=A1+((250-SUM(A1:A5))/COUNTA(A1:A5))" Does that work for you?
  8. J

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    You could use VB6 to create an ActiveX DLL. The VBA code would translate almost exactly to VB6 code.
  9. J

    dynamic data transer from access query to excel

    You can create a PivotTable in Excel based on an external data source, including an Access query. See http://office.microsoft.com/en-us/excel-help/about-pivottable-and-pivotchart-source-data-HP005199304.aspx However it may not work since your query requires user intervention. In my...
  10. J

    progress thermometer chart

    Does this help? http://spreadsheetpage.com/index.php/tip/creating_a_thermometer_style_chart/
  11. J

    Outlook VBA help

    What I would do is set up a recurring task with something like "Mail from xyz@go.com not received" in the subject. Have it occur at 5:30 PM every weekday. Then I would add an event handler (VBA) to check each incoming email. If the email address is xyz@go.com, then look for the task and mark it...
  12. J

    Can this work in a Macro

    It has to be a backtick, i.e. grave character, which is usually found next to the number 1 on most keyboards (above the letter keys).
  13. J

    Fetch MS-Acces Data by Excel VBA

    There's some sample code here that shows you how to run a query against an Access MDB and return the result into an array in Excel: http://www.ozgrid.com/forum/showthread.php?t=18289&page=1
  14. J

    Application.ontime.

    How about this: Function Speak(c As Boolean, s As String, t As Long) Dim currenttime As Date currenttime = Now If c Then Do Until currenttime + TimeValue("00:00:" & t) <= Now Loop Application.Speech.Speak s Speak = c End If End Function Call the function like this, specifying...
  15. J

    Automatic Email When Topic is Answered

    Tell Chandoo to install this plugin: http://bbpress.org/plugins/topic/subscribe-to-topic/
  16. J

    Excel Resources - Excel 2007

    Excel spreadsheets have at least 256 columns, and have had so at least as far back as Excel 2000. Are you using a lot of array formulas or volatile functions? Can you explain what errors are occurring?
  17. J

    How to create a form in Excel

    How about the Lists feature? It has a built-in form you can use to update a worksheet with new values.
  18. J

    Help wirting this ARRAY (1951 1952 1953........2008)

    This response is late, but hopefully it will help someone. What I would do is designate a separate worksheet for the array. Fill the years down in column A (although it really doesn't matter what column you use). Create a dynamic name for the array. For example, this range name assumes that...
  19. J

    Share your favorite Excel Sites

    Apologies for the dupes... http://blog.contextures.com/ http://www.databison.com/ http://dmoffat.wordpress.com/ http://msmvps.com/blogs/xldynamic/default.aspx http://www.blog.methodsinexcel.co.uk/ http://chandoo.org/wp http://peltiertech.com/WordPress...
  20. J

    Using Excel as source for your Outlook task list

    I would leave it to Outlook, it has much better tools for managing tasks than Excel. Especially the recurring tasks, as you have already seen.
  21. J

    How to debug an UDF?

    You can step through this function. Just set a breakpoint on the first line by clicking anywhere in the first line and pressing F9. Then enter the function in a cell. You should immediately jump to that line. Then press F8 repeatedly to step through the function and see where it errors. You...
  22. J

    Employee Photo that changes depending of List Validation

    Excel version? I couldn't find any event in Excel 2003 that fires when you select an entry from a data validation dropdown list.
  23. J

    How to debug an UDF?

    If there's no underscore, then InicioCadena will equal 1. To be sure, change the UDF so it starts out at zero and only add one to it if it isn't equal to zero. Otherwise, exit with a simple error message. Function extraecontrato(celda As range) Dim InicioCadena, FinCadena As Double, Cadena...
  24. J

    Hello .. Introduce yourself

    Greetings folks, my name is Jimmy Peña and I've been frequenting this blog ever since I saw Jon Peltier mention it on his blog about a year ago. Lots of great tips can be found here, and with a forum it can only get better. I've been programming for a few years now, mostly VBA with some VB and...
Top