VBA code needed for calling RegEDIT windows function

If I use your code then I get regedit appear.. what are you trying to do? I think you can edit the registry with the interaction functions, for example:
interaction.SaveSetting(AppName As String, Section As String, Key As String, Setting As String)

Maybe a daft question but do you have C:\windows\regedit.exe on your system? Can you call it from say, the command window?

Thanks yudlugar, I do have regedit on my system at work and I can call it from the command prompt. Although, network setting/windows settings are warning me, would you allow this program to make changes to my computer, I click OK and then windows registry starts properly pointing to my last viewed registry entry.

Do you get an error message? Having a look on google (link), it seems that this might be specificly an issue with your excel version/windows version which is why the code works for me and not for you. Unforunately, there isn't a solution in the linked thread and I don't have an idea of what the solution might be...

3 times I replied and my posts are gone...

yes, the error message was that code needs to be debug.. so, yellow colored code was: x = Shell(Path + " " + File, vbNormalFocus) ..Tomorrow at work, I will try your google / Microsoft example...cheers

When you get the message that the code needs to debug, click debug, then with code highlighted yellow, press F8 - what is the error message then?

invalid procedure call or argument

Ok, so I can think of two options, one would be to try the code from here:
http://stackoverflow.com/questions/4...my-vb6-program
which I think might allow you to open it if you select run as instead of open:

Please Login or Register  to view this content.

Otherwise, I would probably try and get around this problem by using vba to open up the command prompt and launching the shell command from there, rather than directly through vba. Try the above and see if that works first though.

Thanks, did not work. error was after the "end type". I will use the option of calling command prompt and then regedit....cheers