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
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
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...
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.
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.
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 =...
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)...
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...
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!!!
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 =...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.