Recent content by wekkew

well after wasting most of yesterday on this... the penny finally dropped today! The dynamically added ws + controls are arranged with the main data ws (so I had a workbook.xlsm:1 and workbook.xlsm:2 window configuration), and it was that which was causing the problems! If you click a...

Ok, code adds togglebutton (Forms.ToggleButton.1) and event to Excel worksheet - code was working fine, no problems... and then for some reason I can't fathom... the toggle button will no longer respond. It's not locked, it's enabled - so should be able to press/depress it with a mouse click...

[orginally posted in "other access" by mistake - sorry) hi have a series of dbs containing sport results and details that I've been collecting for many years now - getting on for close on 900,000 in total. The data is a mess at the moment, some of it in .txt files, some on spreadsheets, some...

hi have a series of dbs containing sport results and details that I've been collecting for many years now - getting on for close on 900,000 in total. The data is a mess at the moment, some of it in .txt files, some on spreadsheets, some in tables - plan to bring it all together and tidy it up...

Hi macro-enabled sp which is built through vb/ie7 calling web queries. After the data has been pulled, all querytables are deleted. Despite the above, the sp takes an age to open and is currently running at 409k in memory. Anything else that should be deleted in addition to the queryTables...

following on from thread707-1462259 I was having the same problem - as it's random it's hard to be sure this fixed it, but since I changed the refreshStyle property I haven't had any problems. .RefreshStyle = xlInsertDeleteCells when I was having errors it was set to .RefreshStyle =...

I've already written the CF in vba - what I'm trying to do now is to READ the colour that's been applied to cells.

hi, what i need to do is to "read" the color of a cell that's been formatted with a conditional format. As you know, activecell.interior.colorindex returns the NON conditional formatted colour. All the solutions I've seen involve checking for the format conditions again and deducing the...

hi - ok, not a hacking query although I admit it sounds like it. Seem to recall an API that would allow you to pull HD location of file from FAT. Anyone know the api that will do this in NTFS/XP? Also, api that used allow me to write directly to HD in 98x days - anything similar in XP? ta

ok ... well seemed to come up with a sort of fix of sorts ActivePresentation.Slides(1).Shapes("Image1").Visible = msoFalse Although why I can't just say image1.visible = false when I can set so many other properties this way is beyond me. ah well.

Hi PPT presentation contaning one label and one image control. Both of these were added via the Control Toolbox. following code behind click event of label: image1.visible = false Now this is where the fun and games begins :-) this code is def. being executed but the image doesn't disappear...

go to http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=436&lngWId=10 sample code you can download

Dear Scking yesss... I know that, but the users (bless em) find that having to position AND click the mouse (twice!) is just too much of an effort. so - are you saying that if I alter some flags for Explorer they will be picked up by the common dialog control? No prizes for guessing the...

Hello using standard windows api file Open Dialog (ahtCommonFileOpenSave) to select file. Is there anyway to switch the view of files to "Details" and to sort in descending order on "Modified"? I guess there must be some flag somewhere but I can't seem to track it down...

Hello Have form with bound ole object. I need the user to be able to take screen dumps (via printScreen key) and then paste them into the bound ole object control on the form. I've played with clip/stretch/zoom but the quality is yuk. what I want to try and avoid is having to first save the...