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

    'Next without for' Compile error Excel 2010

    I'm not sure if it still works in excel 2007/2010 but in 2003 I used Pretty Code print to isolate these sorts of problems http://submain.com/products/prettycode.print.aspx
  2. nodrog77

    RANT TIME!

    I find that Ranting on the companies Facebook page is effective. At the moment that is. Posting this on their page is also good for a laugh: http://theoatmeal.com/comics/customer_service
  3. nodrog77

    Copy two text files to a third text file in VBA

    I worked it out!!! I'm not sure exactly why but I had a look at the Wikipedia articles for "command.com" and it referred me to "cmd.exe" as being possibly a better alternative. This solution works whether I use a shortened folder name as suggested by MintJulep above or enclose the folder name...
  4. nodrog77

    Copy two text files to a third text file in VBA

    PHV, the copy commands work fine when I test them by copying the string from the watch window and into a dos prompt but I can't get them to work in VBA – I get the error "Invalid procedure call or argument (Error 5). Andrzejek, I get the same error with or without the double quotes. Lea.
  5. nodrog77

    Copy two text files to a third text file in VBA

    Got the short path name working but still no luck - very good idea though. MintJulep
  6. nodrog77

    Copy two text files to a third text file in VBA

    Thanks PHV but your solution isn't working either - maybe it's something to do with dos/network drives. I'm stumped. I may have to work out another way to stick the files together.
  7. nodrog77

    Copy two text files to a third text file in VBA

    Hi All, I have two fixed width text files which I have created from an excel workbook and I'm trying to append one to another and output the result to a third text file. I've been using the shell to do it as it seemed to be the simplest way. The following works fine: OutputFolderName =...
  8. nodrog77

    Excel VBA

    Andrzejek , in answer to your question "Just a shot in the dark here, but is there any place in Excel where you can set: enable/disable macros on start? " The answer might be in setting your macro security to "medium" as follows: (correct me if it's changed slightly - I'm still on 2003 here)...
  9. nodrog77

    ENDIF without IF block

    techie88, I also recommend Pretty Code Print it graphically draws a vertical line down the side of the page between the if statements, do loops etc. I've found it very handy when debugging large pieces of code - I often just use it in preview mode so I don't kill half a dozen trees every time I...
  10. nodrog77

    Can't display Watch window in VBA

    Thankyou so much - the little %@&% was hiding and minimised in a corner just offscreen
  11. nodrog77

    Can't display Watch window in VBA

    View > Watch window somehow isn't displaying the watch window. I suspect that I have moved it to one side at some point and somehow I can't get it back. Help!!!
  12. nodrog77

    Syntax to add a hyperlink to a pulldown menu

    Thanks Combo, I never would have guessed it was via the .tooltip property. Have a good one, Lea
  13. nodrog77

    Clever Company Names (Maybe too clever)

    House of Balscheit" - Secondhand Furniture & Homewares (the expensive type) in St Kilda, Melbourne, Australia.
  14. nodrog77

    Syntax to add a hyperlink to a pulldown menu

    This is probably an easy question but I couldn't find the syntax to do this anywhere. I just want to use VBA to modify a pulldown menu to open a word document (in excel). I can do it manually so there must be a way to do it using VBA Note that this is excel 2003. Set Btn_HelpSupps =...
  15. nodrog77

    Can't remove old excel toolbars

    OK, Finally located the .xlb and yes - deleting it resets all the menus back to the defaults. Except those menus - which reappear again!! have tried accessing and deleting them via the workbook objects, the code now reads: Public Sub DeleteOldToolbars() Dim cntrl As CommandBarControl Dim...
  16. nodrog77

    Can't remove old excel toolbars

    Thanks All, I was unable to locate any .xlb files on my PC running under Vista - but then again I can't get access "Application Data folders" etc, even when I run in admin mode which is one of the things that make Vista so useless. I don't have admin rights to the other users machines either so...
  17. nodrog77

    Can't remove old excel toolbars

    Thanks Gavin, I'm not sure what .xlb you are referring to? Where would it be stored and can I access it using VBA? Is removing/deleting it going to effect any of the other settings of the user (in which case I might as well just get IT to re-install excel) I tried saving personal.xls...
  18. nodrog77

    Can't remove old excel toolbars

    Note: Excel 2003, OS Windows XP (or Windows Vista) Hey There, I have a couple of old excel toolbars which I can't seem to get rid of (and neither can my users): Both the code below and manual edits work fine in the current excel session but then if I exit excel and start again, Hey...
  19. nodrog77

    Alt-Tab, Switch Focus, multiple instances of excel

    Prudge, I could be wrong here but wouldn't you have to get some sort of handle on each Application object for each process. All of the other objects such as Windows and Workbooks would be children of that Application Object (they just can be referenced without the Application object...
  20. nodrog77

    Defining ranges in vba : Syntax error help

    Hey Kuda, The Bit: '----------------------------- Dim levelrange As Variant levelrange = Worksheets("Sheet1").Range("a4:z4") '------------------------------- maybe could be replaced by: Dim LevelRange as Range set LevelRange = Worksheets("Sheet1").Range("a4:z4") I'd also start with using...

Part and Inventory Search

Back
Top