Recent content by DeeBeeGee

Does anyone know if it is ever possible to change the compresed file attribute at runtime

Macropod, Is your site still available? I cannot get a connection to see your ready built progress bar.

Why not cut out the ShowForm subroutine and simply use the .Show property of the form you want to show? or are there other commands you have stripped from the sub for simplicity?

ZZ the formula should be set out as =VLOOKUP(value to be found, range to be searched, column of range to return value from, whether an exact match is required) You need to be more specific with specifying your range. Something like [emp2]Sheet1!A1:B12 for example. Then you need to specify...

Thanks PH I have nothing against collection at all. However there is no need to group together my variables and in some cases there may only be just the one in which case a dictionary (or a collection) would be superfluous and messy* I have usefully used the dictionary in such a way before but...

I am trying to write a solution to addressing variables using a string equivalent of their name much like using a key to refer to a member of a collection but without the collection. The way I have succeeded in doing this is creating a temporary sub at runtime, calling it, then deleting it and...

In what application are you working? ".Clear" should work for a ComboBox on an Excel MSUserform but I know Word has slightly different methods and syntax. If you delete ".Clear" and put back the "." then you should be prompted with a list of methods that are applicable to MyDropdown. If not then...

Aha! regsvr32 scrobj.dll /n /s /i:T:\Acgscripts\wsc\userinfo.wsc works. And I definitely mean it this time. I've tested it and everything!!! Thankyou ever so much for all your help. A star for you

I am using Windows NT so the first method failed and the second succeeded although still with the msgbox I am trying to eliminate. Where should I put the "/s" flag? ps. I hope you're not hoping you'd never answered my first query :)

I think I am trying to use the dll to register the wsc (It may be that my understanding is off piste). However, I do know that the line REGSVR32 /i:"T:\Acgscripts\wsc\corporateheader.wsc" "C:\WINNT\System32\scrobj.dll" works but produces the pesky msgbox. I was hoping that it might be as simple...

It didnt like that at all. What would be the correct command as typed in ms-dos ie. without all the Chr(34)s confusing everything

Actually TomThumb I was duped!! The code was running through without error but not registering the file. I have tried WshShell.Run ("REGSVR32 /u /n /s:" & Chr(34) & "T:\Acgscripts\wsc\userinfo.wsc" & Chr(34) & Chr(32) & Chr(34) & "C:\WINNT\System32\scrobj.dll") and WshShell.Run ("REGSVR32 /u /n...

Thinking a long way outside of the box and indeed good programming practice but hey where needs must you could maybe get your program to send you an email with an individual subject line and a delay if necessary just before calling Analyst_CubeUpdate and in Outlook you could set up an event...

TD Probably the simplest way to do this is to clear down MyDropdown then individually add each item you require depending on the value of MyCheckbox each time you change the value of MyCheckbox. You can call the sub when the form is originally invoked Sub MyCheckbox_Change MyDropdown.Clear...

Actually you can scrap that as I was being dim. Thanks for the help. It works perfectly