Search results for query: *

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

sounds exactly what i am after! but where do i put the flag? my relevant line of code is WshShell.Run ("REGSVR32 /u /n /i:" & Chr(34) & "T:\Acgscripts\wsc\userinfo.wsc" & Chr(34) & Chr(32) & Chr(34) & "C:\WINNT\System32\scrobj.dll")

How can I clear a (externally created) message box ? Currently I am using sendkeys[enter] but this is very hit and miss. The message box is created when a windows scripting file is succesfully registered - a process I call using WshShell within VBA. Is there a way to refer to this box. It does...

Fair enough I guss I was thinking specifically about the pdf I was trying to get data from (an official publication) and why they would want to stop people reading data from it. I can see that commercial sites might want to prevent people screenscraping but see no benefit here

A bit of a guess but try Set objDestFolder = New MAPIFolder before you try and assign any values to it????

I was just asking around work to find out the exact same thing to be told it cannot be done so, with the exuberance of youth and a determination to prove them all wrong I searched Tek-Tips for an answer but judging by the lack of response I guess I amy have to concede defeat :o( Begs the...