Search results for query: *

Hi I have been using a line self.status= goforit ;in older browsers and suddenly realised the "status" function has changed, it no longer reports any content. see http://cresby.com and "errors". I am using the status line to put a message (the day of the month - eg "3rd Fri"). Any ideas...

I found how to work a macro that did most of what I wanted which disappeared when the Administrator changed our network. Legacy scripts run as they always did but dont translate automatically to a macro. I want a single click to: run a named macro or the translation of this code It is to save...

There I feel a lot better already. there is a tide in the affairs of man that you Cnut ignore.................

I have just loaded LT 2008 and tried it. the Dashboard toolbar collection seems to default off happily next day. Good job it showed itself on first showing. I tried to see if I could load a script on strat-up - which seems to be only allowed via Windows shortcuts. 1) Apart from tinkering in...

Hi Problem - the calling site links to me with #anchors and acts as you would expect in a page without frames. eg dance.htm#D.DJ This code works well in IE5 but not in Mozilla 1.7.8 and Opera 3.5 seems to ignore it as well. <script language="JavaScript" type="text/JavaScript"> var inanchor =...

OK I can assign icons manually but how to assign them in a macro. I loose toolbars occasionally and rather than chase the rare event I can re-instate them with: Application.CommandBars.Add(Name:="tester").Visible = True Application.CommandBars("tester").Controls.Add _...

Hi We get the 2 splash screens (one html) when we open Autocad (or files files from WinExplorer) telling us Security would demand that scripting is turned off normally, but the browser runs JavaScript happilly eg http://cresby.com. So apart from compromising the security of essential...

Excel 2002, Win XP We are trying to get the word "DRAFT" splashed across a spreadsheet printout. Watermark doesn't seem to be offered (that I can see) in Excel and Background is non printing. I could try looking in VBA and see if the sheet has a property but there is nothing in any menu that...

OK this opens explorer and can paste manually Private Sub emal_Click() abc = "destination base folder" dummy = Shell("explorer.exe /e, """ & abc & "\e-mails""", vbNormalNoFocus) End Sub But is there a way of pasting the clipboard item (ref or actual) to the actual folder location? SendKeys...

Hi we have a VPN to the master server in HQ. When I try to open a spreadsheet I look for the words read only on the title to be sure if it is already being accessed. However this does not appear to answer all situations. My PC is the local server (we have a wireless router which bypasses my...

I got this code from http://www.tek-tips.com/viewthread.cfm?qid=1451958 but I can't see how to unload the specific instance of ie created. tried ie.Unload, .Exit, .Close Object Browser and watch properties give no clue. any ideas anyone? Not sure how to invoke the menubar etc but values below...

Hi a colleague asked the question about laying bundles of wires in expanded mesh to form a "cable" so that all wires (or cables) get approx the same stress as the enclosed bundle is bent or flexed. These are 24AWG PTFE insulated types, Belden cables, STP PTFE &/or others He thinks there is a...

Hi I asked the question in another thread (http://www.tek-tips.com/viewthread.cfm?qid=1407102) and couldn't get the method suggested to accept the user type. This thread tiltle is more to the point. Win XP Excel 2002 (VBA/VB 6) though I do try this at home (Win98 ditto) Word Document is...

Hi I created folder and subfolders in VBA successfully. However after struggling to move a shortcut around (in VBA halting at the offending move) I think it left the file in limbo. The source folder cannot now be deleted in WinXP and the DOS window does not see it. XP says it is read-only and...

VBA help suggests this event should work Sub App_NewWorkbook(ByVal Wb As Workbook) newbuk = Wb End Sub I have tried putting it in "This Workbook" and Module1 but the event is not trapped. How do I get it to trap the event or find the name of the new workbook. Private or not private makes no...

OK this code will start IE before dinner time but how do you close that same window when the eating stops? Just to take temptation way from the guys - if they are smart enough they will find how to get round it. Public closer As Long Private Sub Workbook_Open() Application.OnTime...

Hi detecting folders &/or files with spaces in their name I just found a problem reading the file attributes when the object is a folder. By detecting an error this code then reads folder attributes. However if there is a space in the file name the error is not trapped - but in a folder it...

OK field codes - formula I want to multiply a "price per" cell in one column by a quantity in another column. My solution uses "=sum(right)*sum(left)" because it will pick-up the values in adjacent columns and sum as far as the first zero (or text). However there is a need (from an analy...

The record macro function leaves no appropriate code to change the "properties" set that read in a pop-up when you hover in Winexplorer. Variables/object.properties that can be found don't seem to do anything. And Sendkeys fails in dialogs. I use macros to generate docs (purchase orders) that...

Hi I am trying to invoke win explorer from VBA & a shortcut using the command line switch. I am not at a Win98 machine which used allow me to see this. And is XP quite as helpful (in this respect - before the blue touch paper smoulders) Getting a particular folder contents to display is easy...