Search results for query: *

My company is now making us "digitally sign" any Microsoft Office tools with macros or VBA. They've enabled us to create our certificates and I can manually "digitally sign" my Excel or Access files. But if the code is changed any, it ruins the digital signature. Just a bit fragile. I would...

I do that, then I can add my macro. Then I click "Modify..." (under the right-hand pane, and I see a dialog of 181 symbols that aren't meaningful to me. In the old Excel, I could edit the button face, creating initials or short words that differentiated them, almost as mnemonics. I had 15...

I've just been upgraded to Office 2007, and I can't find a way to customize buttons at the top of my Excel screen, to point to my favorite macros. I click the customize button and I find 181 icons, but none can beat my old custom ones, for what I needed. Is there a way to edit them or add to...

Just that the reported and apparent file size and used range only changes after you have saved. " - I understand and agree. I read too fast. I hadn't thought of automating the deletion of the "blank" rows and columns. I can't wait to try it out. Also, it was interesting to see other ways of...

A macro isn't necessary. I frequently get that, and there are three methods I have had success with. Pick one. 1. Highlight the column of "formulas that show as text". Do the Data>Text-To-Columns, choose "General" when you get that option, then "Finish". It sees a formula, and guesses that...

Gavona, the file size doesn't always reset just by saving. My co-worker and I have been noticing this on several of our files that are very big. It seems that the "garbage-collection" routines don't always work. When we see our big files getting over 100M, we right-click on the tab in the...

Could it be that in some cases "[rstCosting]![CostingType]" evaluates to a null? IrishJim [pipe]

Another similar thing I do is capture some of the user's settings when I open my program, set them the way I want, then set them back when the program closes gracefully. I define a few global variables: Global Save_Confirm_RecordChanges As Boolean Global Save_Confirm_DocumentDeletions As...

I've used vbCrLf successfully. I expect it puts in the traditional pair of codes Carriage Return and LineFeed, (hex 0d and 0a, decimals 13 and 10), which most text editors put at the end of each line.

Skip, Thanks for the advice above. I have been picking at this problem for a while, doing work-arounds, until I had to revisit my code and try to make the vlookup work. You said above: "2. Either Application or WorksheetFunction is the Object for VLOOKUP but NOT BOTH" Following this seems to...

On the same track as Johnniemac43-- About half of my jobs are sequential-type projects (Extract data from corporate databases, join, tweak, print or export) In these cases, I have found it invaluable to have the sequence of queries in the name (qry01_Pull_Provider_Ids, qry02_Get_Names, etc.)...

Thanks for your help! I'll make copies of the system.dat and user.dat before I start. And check my boot disk. I wasn't looking for a tool, but that Regclean sounds good. It's not compatible with the newer operating systems, so Microsoft took it off their site. However, one thing led to...

I'm about to edit my registry (actually one on Win98 and one on WinMe). In looking over past threads, FAQ's, etc., I saw the following: "Obviously, the moral of the story is 'Thou shalt not mess around with your registry unless thou doth knowest what thou art doing'". Obviously wise...

Sorry - it was the "Solution.mdb". - Jim

I just saw an example of this yesterday in the "Solutions.mdb" Access Sample database. It was in the "LimitListContents" form. Jim

Thanks for the site reference! I love how it works. I would like to know if there is an extension to prompt the user to pick a particular worksheet tab, if it's an Excel file? Would it be too much to ask somebody if they've ever gone one step further and imported said worksheet into an Access...

I've had that problem, and think I worked through it.... In Excel, I sometimes create a new sheet with: Sheets.Add I might give it a name: ActiveSheet.Name = "MyNewSheet" If I later am at a point where the focus is on a sheet, and I don't know the name, necessarily, I can find...