Recent content by bpurser

Appreciate the pointers to those pieces of code--I had found them in my search. This is definitely not my area of expertise, but those appear to be both text-centric and an automation of the Ctrl-C and Ctrl-V keystrokes--and unless I am missing something (ENTIRELY possible!) I don't think they...

I have been googling my behind off this morning, looking for a way to have Access grab an image from the clipboard (put there with PrintScreen key in an external piece of software, and save it as a file (jpg). Since VBA doesn't expose the clipboard object, it's a cumbersome issue, and I now...

OK, I will start it up and let it run all day to see what happens....now that I have that col added, it "crashed" (understanding that it might not have REALLY crashed, just using a convenient term) when I tried to access the drive this AM. We'll see what happens.... Thanks for the input. Ben

No, I waited for the objects to populate--paged up and down though the whole drive as they popped into view, then once they were all there, ran from top to bottom several times to make sure there were no more delays--took a few minutes as there are lots of objects. Then I hit the Owner column...

When I add the Owner column to the display in Win Explorer, for a shared network drive, and then try to sort by the Owner column, Win Exp crashes...anyone know why, or know a way to make this work? This is one of those "nice to have" things for a pain in the rear projects.... TIA-- Ben

Thanks--I will check them out... Ben

Well, it does restart fine in Safe Mode, so it must be a driver or device or program I've loaded. I have already come to the conclusion for other reasons that I need to wipe my disk & re-build everything, so once I work up the gumption to do that, I will identify the culprit. However, for now...

Here is what I have...am running a relatively intensive process right now, but whill change my 5 to your 30 and see if that has an impact, then will check the BIOS. [boot loader] timeout=5 default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS [operating systems]...

I have a home built PC with a PIV 2.6 gig processor and 1.5 gigs of RAM. UNFORTUNATELY, while our basement was being remodeled, my 10 yr old had free access to it, cause her PC was in storage....generally, the PC works just find, but for the past few months, when going to the Start Menu, Turn...

Seems like she is SOL...thanks for the info. Ben

OK, so I have a coworker, who wonders if there is any way to find a temp version of a document she created, then printed, but didn't save. I am of the opinion she's outta luck, but thought I would post the question, since the bucket that holds the stuff I don't know is pretty large... TIA-- Ben

I am talking about the data stored with a worksheet (or any office document) regarding author, edit history, properties, etc.... It's five separate workbook files that I am interested in scrubbing before submitting for review. Essentially I am looking to make sure that the history of the...

Anyone know a good piece of shareware that will clean metadata from an excel workbook? I don't mind paying a developer a nominal fee post facto, but I need to be able, if possible, to download something tonight that I can use. Many thanks-- Ben

OK, got the formulas exported, but they aren't being evaluated, unless I go into the formula bar, click it and then select OK....not sure what's up...code follows: objExpSheet.Range("rngDataAll").Clear objExpSheet.Activate objExpSheet.Range("expbeg").Select...

Thanks for the replies, folks...I know bupkis about Excel Automation, and was just using the TransferSpreadsheet command to export the query where I construct the forumulas...Now for the REAL story...as mentioned, I have some 2200 recs, with about 5 of these forumulas per rec...can I get a bit...