Search results for query: *

Excel 2007 Excel 2007 removes the ability to record me moving creating and moving rectangles. Does someone know the code/properties/objects required to create a Rectangle, and change its height, width, position and text ? I'm looking to create rectangles to give a visual representation of...

I have a base PC setup which successfully autologons. The below script changes the PC name and user accounts and should also make it auto logon. After the script is run, it does not autologon, but if I manually enter the password it does login proving the account and password have been renamed...

A pivot table is driving me insane at the moment. A very simplified example of the data is below Week CaseId Fix FW01 111111 1 FW01 111112 1 FW01 111113 1 FW02 111114 0 FW02 111115 1 FW03 111116 1 FW03 111117 1 FW03 111118 1 FW03 111119 0 What the pivot table should look...

I need a formula to work out a shift pattern For example, I have a date/time in A1. If the time in A1 is between 7pm and 7am it is a nightshift If the time in A1 is between 7am and 7pm is is a dayshift Sounds simple but I've have not cracked it yet. Any help appreciated.

Here's a teaser, not unlike my last post where I asked how to select the previous 12 hour period. I now need to select the current week for a report, where the StartDate will default to Saturday, 7am current week, and the EndDate will default to Saturday 7am next week. Eg. Today is 21st Jan...

This is alledegly answered here but the site has gone... http://www.tek-tips.com/faqs.cfm?spid=767&newpid=767&sfid=1973 I have a report which is scheduled to run at 7am daily and I want to grab data for the previous 12 hour period (shift patterns). I am currently doing this manually with 2...

For the life of me I cannot work out how to check if a right click menu exists. I have the following code to create & delete one, but what is the code to check if it exists before I delete/create it ? To create it I use With Application.CommandBars("Cell").Controls.Add(Before:=1...

Although Application.Quit may close any documents (we're talking Word here) it does not kill off the Word session. How can this be achieved ? I've googled & tektipped & all the rest to no avail. I want it to do exactly what it says on the tin, i.e. Quit the Application. TIA, Bob.

I have a textbox on a userform which has the following trigger : Private Sub txtLotId_AfterUpdate() Lot_Id = frmMainForm.txtLotId.Text If Lot_Id <> &quot;&quot; Then SQLStmt = &quot;SELECT POS,PIT FROM PIT_TABLE WHERE LOT = '&quot; & Lot_Id & &quot;'&quot; Set...

I am using the below code so that when the user opens the document, it displays ther userform and hides Word, but I cannot get the focus onto the userform. I have to click the taskbar to display it. Any ideas or better methods ? Sub AutoOpen() Dim Docname As Variant Docname =...

I have a few users who experience problems with their spreadsheets that no one else does. I checked through the VB editor (Help>About)what version of VB they are running with, and some are on version 8714, and some on 8967. Is this updated via service packs or by some other method ? Any help...

Is there an easy way to update VBA modules programatically, like a patch ? I have around 20 replicated spreadsheets, all with 1 protected VBA module under the bonnet. Rather than sending out a new template, or opening each spreadsheet and manually deleting and updating the module, can I do this...

Very strange behaviour... I do have my calculations set to automatic, I am not opening any other workbooks which have this set to manual, and I have even tried code to recalculate the cells. My formula is =&quot;A&quot;&(164+COUNTA(Plan!A164:A188)) The strange thing is, this WORKS for...

I have the below code attached to a workseet which updates a text box with a figure when the user enters any figure in a cell : Private Sub Worksheet_Change(ByVal Target As Excel.Range) Application.ScreenUpdating = False If Sheets(&quot;DataSheet&quot;).Range(&quot;F20&quot;).Value =...

I have a VBA macro which produces a status report from a bunch of figures & reports. The outcome is 1 reporting sheet and then I use the line Worksheets(&quot;Final&quot;).UsedRange.Copy to copy to the clipboard, the idea being to make it available to paste into Lotus Notes. The problem is it...

Is there any way without using a firewall to disable IE ? Any registry settings for example ? Thanks, Bob

Is there any way without using a firewall to disable IE ? Any registry settings for example ? Thanks, Bob.

Does anyone know if there is a registry setting to control the Address/Links/Desktop/Quicklaunch toolbars. I need to remove the Quicklaunch toolbar from around 400 PC's and I'm damned if I can find a registry setting to do this. The PC's do not have a C:\Documents and...

Does anyone know if there is a registry setting to control the Address/Links/Desktop/Quicklaunch toolbars. I need to remove the Quicklaunch toolbar from around 400 PC's and I'm dammed if I can find a registry setting to do this. The PC's do not have a C:\Documents and...

Folks, I have VB6 on my machine and it's started acting up. I can run projects, but if I try and browse to the form in Project Explorer VB is giving me an application error along the lines of 'the instruction...cannot be read, please terminate. Has anyone encountered this before ? Thanks in...