Downloads

All the files listed below are available for free download, and include full open source code. Click on the file name to download, or the associated blog post link to open the post in a new window. Click on the icon in the bottom right hand corner to open this window full size.

The table now has two “category” columns.  Scroll across or open in full window mode to view.  The second category column links to the associated “Download by category” page, with more details and links for each file.  It is also possible to sort on any column when the worksheet is in “Edit” mode, or open in Excel to use all Excel functions.

18 Responses to Downloads

  1. Pingback: Interactive File List | Newton Excel Bach, not (just) an Excel Blog

  2. Zoul says:

    Hi,
    I’ve just started with vba programming. By googling I found your blog very helpful and interesting.
    Zoul

    Like

  3. vivek says:

    one of the best help or toturial you people made availabe to world
    in so simple manner to new usser

    Like

  4. Pingback: JRodSIM 1, or, How to use Excel to figure out your wishbones. | Hyllest

  5. Pingback: Embedding Skydrive worksheets in WordPress | Newton Excel Bach, not (just) an Excel Blog

  6. Colin Legg says:

    Thanks for the Skydrive wordpress support link, Doug. I was struggling with this myself so it’s a great help.

    Like

  7. mustaffa says:

    please can anyone help me ….. I want an Excel sheet make analysis for 2D truss using VBA
    thanks

    Like

  8. Pingback: Download update 2 | Newton Excel Bach, not (just) an Excel Blog

  9. Costas says:

    Doug, The files in the Textin2 zip won’t open. Could you take a look and reload the file, Thanks.

    Like

  10. Costas says:

    Doug, Files open now……thanks mate.Text-in2 works with your text files, but bombs out with error message 1004 with my text file. My file is colon separated with no header line, from a mobile phone company. Any ideas on what the problem is? Thanks again.

    Like

    • dougaj4 says:

      I don’t know why a colon separated file wouldn’t work. If you send a copy of a file that gives that problem to my gmail account (DougAJ4), I will take a look at it.

      Like

  11. Costas says:

    Will do Doug. I will strip it down and email.

    Like

  12. Costas says:

    Doug, Just downloaded the latest Text-in2 files. Hopefully the formatting issues are resolved. I will test and get back to you with the results.

    Like

  13. Costas says:

    For some inexplicable reason amounts in the original text file are not maintaining their comma in the correct location and shifting one number right (19,7150 is reflected as 197,150 in the output). However this is not the case for all amounts. The amount of 000,1666 maintains its format.
    Hmmmmm ?

    Like

  14. Costas says:

    Doug, OK, disregard my previous post, I realized I had skipped a step. The output is as I wanted. Would it be possible to save the file as a tab delimited text file? What modifications are required to the VBA code. Thanks for your invaluable support.

    Like

  15. Costas says:

    Sorry, Mis-spoke. When the text file is Read, it looks OK. However, when Read and Split is pressed; some amounts are General format and others are numerical format. The amounts with General format are OK, but the numerical formatted amounts have the decimal comma in the wrong location, as noted above. Sorry for the confusion.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s