gtg93

Could I get a copy of the script?

Odd! Has that sorted it then?

Forgive me if I'm pointing out the obvious, but have you tried restarting the PC to make sure nothings got a lock on the reg key?

Yep I use it, as it saves faffing in the registry and I can never remember the key!

May I suggest DelProf2? Run that on the PC in question. https://helgeklein.com/free-tools/delprof2-user-profile-deletion-tool/ Seems to be quicker and more reliable in my experience than manually doing it, and has various options for deleting one / all / excluding certain ones. Failing that, it can take a while to load but built into win7 theres a tool. Just search the start menu for "Configure advanced user profile properties"

Errrm... huh.... what just happened? edit: There was sound? I got no sound...

This worked perfectly - thanks for the info!

Failing that, give them a pen and a few sheets of paper and tell them to get writing!

Don't think so - but out of curiosity - why would you want to?

Thanks for info - I automatically expect MS to have made it difficult for us

Hi All, I'm on with setting up new GPOs on a server at one of my sites, we've only recently taken over and it's a mess. At the minute everyone is working with all their work locally on their laptops so not ideal! We've created new OUs, and I'm just about to start new GPOs so we can move all staff, student and PCs across and have the new policies take over. I've recently done this at another site, so I was wondering if there's a way of just backing up the GPO I want, and importing it into this other server to save having to set it all up?I've then got a template for the future too. Both are server 2008 R2. I've realised the backup option in GP Editor, but I'm under the impressions it's not as straight forward as I would expect. Anyone know a way? Is it worth bothering? Thanks, Grant

So I've got that working - the only issue is it copies the contents of the cell too, so I've decided that if I can use this, but insert cells from another worksheet then perfect! I've tried adapting it, and it ran with no errors, just didn't insert any rows... any idea how I'd go about doing this with the code? Appreciate all the help! I do, but only some of them have the forumlas... it looks like this: There are two hidden columns, the Mileage columns has the GMaps formula, and the Origin and Destination contain drop down menus of different sites. Does that make sense? Sorry for the confusion - thanks again!

That does not look or sound legit - were these sourced from a proper supplier? Maybe they could offer you some further advice? I'm sure they'd like to know what they're selling, I for sure would! I was under the impression that UK electricals all had to be CE stamped, and as far as I'm aware, they'd also have to be fused if handling 240V? I'm no expert however...

It's likely me, but I can't seem to get that to do anything... However, correct me if I'm wrong, but wouldn't that copy the formatting and the contents of the cells above? I'm just looking to copy the formatting of the cells down so there's a new line. EDIT: No - because it'd be inserting a new line, NOT copying anything - I missed that. Sorry! Let me have another go with that.

So far I have Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = [TotalVal].Row - 1 Then Application.EnableEvents = False [TotalVal].EntireRow.Insert Application.EnableEvents = True End If Set FormCopy = Sheets("Mileage Claims").Range("B13:L13") Set FormPaste = [TotalVal].Row - 1 FormCopy.Copy FormPaste.PasteSpecial xlPasteFormats End Sub But currently getting Runtime Error 13, Type Mismatch on line: Set FormPaste = [TotalVal].Row - 1 I assume it's the "[TotalVal].Row - 1" that can't be used in this instance - any ideas for a way around this?

Hi All, I've created a mileage claim form in Excel, which has a list of support sites in there, and is linked to Google Maps to auto populate the distance travelled. All working great apart from one thing I can't get my head around. Once the last row before the Total row is full, I want a new row inserting automatically. I've managed to achieve this with: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = [TotalVal].Row - 1 Then Application.EnableEvents = False [TotalVal].EntireRow.Insert Application.EnableEvents = True End If End Sub But, I need all the formatting to remain the same as the rows above, as there are formulas in each cell etc... Anyone got any ideas if this is possible? If so how it's done? Ideally the document needs to be password protected from editing too, but not sure if this is possible if new lines are going to be inserted? It currently is protected, but this prevents the above code from running. Any advice appreciated.

Thanks Guys, Seems I was being a dope earlier, and entering the wrong key. Registers with no issues by just typing the MAK into the box. A new image would be the best option, but only being here a day a week, with the amount of software they "do definitely use" would take ages, and its only on 10 computers. Long term, I think that would be the best option however. Thanks for the info help an info!

Sorry - I mean MAK key - got a million and one other things going on this morning. What I meant was, the image is built using the OEM Media and the OEM Key, that came pre-installed on the HP Devices. Now, I have sys-prepped the HP image, and put it onto non-HP hardware. Am I able to register it with our MAK Key? Cheers

Hi all, One of my schools that I have recently taken on, have bought 30 new HP PCs. To set these up, I have built an image on one of them, using the HP install that was already on there, and imaged the rest using WDS. I want to use the same image on some non-HP older machines we have - obviously what I've not thought about is the fact that it's the OEM license etc on the HP ones so they've registered fine, but the old unbranded machines we have won't register. Is there some legit way I can make the older machines with the HP image on them register with our MAK key? Or is this totally no possible? They're both Windows 7 Pro, so there's no real legal issue that I'm aware of. I know it's a bit of a boo boo from my side, but the school had no records of their licenses when I first took over, and the last company had left me no details anywhere, so as the school wanted the new PCs ASAP, I just set them up using the included licenses. Thanks in advance for any info.

Seem to be struggling to get this to work I have: Dim C1prompts as string = "my internet does not work" Dim C1Responses As New List(Of String) If C1prompts.Contains("internet") and C1prompts.Contains("not") and C1prompts.Contains("work") Then C1Responses.Add("Turn your wireless on") End if Dim ChatItem1 As New ChatItem(C1prompts, C1Responses) But that's not working... Any ideas? It's just responding with my not recognised response... It's probably my lack of knowledge. I've tried figuring it out for myself but pulling my hair out now! My main aim is to get it working very basically at the moment, but the more I think about it the more I come up with ideas similar to the ones you mention... My thoughts more or less are to get it to recall some info, so when asked if they've checked their wireless for example, if they say no, it would then show them how to do it, if they says yes it skips that. But I think that's for somewhere further down the line. Possibly even logging a ticket on their behalf if the ticket isn't solved after x amount of questions, using the info gathered to log the ticket.

Cheers - I'll have a look at that. Still want to have a go at my own though too - basically just for learning reasons like you. edit - Those be some crazy eyes!

Dim C1prompts As New List(Of String) Dim C1Responses As New List(Of String) C1prompts.Add("My Internet Is not Working") C1prompts.Add("My Internet doesn't Working") C1prompts.Add("My internet does not work") C1prompts.Add("My internet isn't working") C1prompts.Add("My Internet won't Work") C1prompts.Add("My Internet will not Work") C1Responses.Add("OK, Have you checked your wireless is turned on?") Dim ChatItem1 As New ChatItem(C1prompts, C1Responses) The above is a chunk of coding from a chat bot I'm trying to develop in Visual Basic, using Visual Studio 2013. It's currently in its very early stages, but I am attempting to build something for the schools I support, that can basically guide them through some basic troubleshooting steps so they can possibly fix small issues before I'm on site. Basically, I was wondering if there was some form of code I could use, so rather than having to have a line of text for each possible input, it would detect that the words "internet", "not" and "working" were in there then choose the response, so regardless of how the question was originally typed, the bot would still recognise the response? Is this possible, or am I expecting too much of a basic language? I realise VB isn't the best. Thanks for any help.

Only taken a month, but if anyone's still after it, you can download the Visual Studio project files from here. If anyone has any issues editing it / no access to Visual Studio, gimme a shout and I'll see what I can do for you. @RobD @the_one_that_cant @gazlee @elliot-w @Hulbert99 Sorry for the delay to anyone who wanted it.

Haven't forgotten about you, just not had a chance... will sort it for you when I'm next at the site with the software.

I'll get it sorted soon for you