Search:

Hi Rory, et al,

Does this still apply to Office 2007 and specifically VBA projects in Excel 2007 ?

I know Excel 2003 VBA passwords could be cracked instantly for reasons you have already...

No, I bought Office 2007 with the machine and have never had Office 2003 on it.

The puzzling thing is it used to work with the .xls, now it refuses to load it automatically. It will still load as...

I presume one must "Save As" .xlsb as opposed to renaming from .xls otherwise Excel will complain that the file is not in binary format.

I have solved my recent problem with Personal.xls, but am...

Yes, thanks, it was SHIFT, not CTRL - I had forgotten.

Can you believe that they have "dumbed down" the graphics engine. I've also noticed when moving an object or group of objects that you...

Hi,

When drawing freeform lines in PPT 2003, I used to hold down CTRL to force line segments to be horizontal, 45 degree or vertical. This no longer works in PPT2007. Does anyone know how to...

Thanks Hans - I had searched on Google, but maybe I used the wrong phrases. Anyway, at least you have confirmed it wasn't only me and something stupid I was doing. I will definitely turn off the...

Since recently moving on to Office 2007, I have twice lost my .mdb files. Lost as in without a trace . . . !

Compact on close was enabled, and upon quittting the DB, a msg box popped up to inform...

replying to my own post - seemed easier than editing the original

I may have stumbled on a solution, but I am still none-the-wiser . . .

I tried a different provider for the SQL server...

Hi,

I have an Excel 2003 application that reads data from either a .mdb or from SQL Server, depending on the user's choice. If the user selects MS Access, then all data is read from or written to...

I don't see why this code shouldn't work in Excel 2002.

In your immediate window, type "? Application.LibraryPath". I get "C:Program FilesMicrosoft OfficeOFFICE11LIBRARY". WIthin the Library...

er . . . what a fool - thanks Hans, I must have constructed dozens of clauses like that when generating SQL strings in code, but because I was in the query designer it confused my brain for some...

Hi,

My archive search mainly found references to the RunningSum property which can be used on reports, but I want to return the equivalent cumulative totals in a query. I found a similar need...

Hans,

Thanks for the solution - i.e. this is a bug and needs to be worked around. I don't know why, but I only searched the archives for "Option Button" as two words, otherwise I would have found...

Hi,

I have three option buttons on a user form. Each one has a click event that runs a common procedure that either enables or disables a textbox depending on which button was clicked.

I have...

Thanks Rory, Hans and Jan Karel. The key was definitely the <font color=red>Application.EnableEvents = False</font color=red> statement. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>...

I had tried that, but it didn't suit me because some of the sheets contained charts which I wanted to be copied to the new workbook. The PasteSpecial options were however very useful in this case :...

Hi,

Could somebody please tell me why the following code kills Excel ?

I want to copy the current sheet to a new workbook by clicking on a custom toolbar button and the following code is one of...

Hi Hans,

With your help I think I've finally nailed this problem and I'll describe what I've found to maybe help others . . . If you see anything wrong with my "findings", please shout.

The...

Two PC's, two versions of XL :

Home : Excel 2003 (11.5612.5606), solver in C:Program FilesMicrosoft OfficeOFFICE11LibrarySOLVER

Work : Excel 2002 (10.2614.3501) SP-1, solver in C:Program...

Thanks, that is more or less what I do to get going again, but I plan to distribute this application to a few people and I don't want this sort of erratic problem to keep arising. I suspect Hans is...

Hi Hans,

I am working on both a work and a home PC.

After I posted my original message, the whole .xls file got corrupted - I had a feeling that something was "going wrong" with the file. ...

Hi,

I seem to be experiencing erratic problems with the Excel Solver add-in (again!!) with an application that I am writing.

When I call the code that uses the Solver.xla functions, I check...

Following on from where Hans last helped me to get a class module sorted out to easily automate the creation of embedded charts in a workbook, I'm now stuck on a seemingly trivial issue.

When I...

Thanks, I saw your addendum to the original reply . . .

Rudi,

Thanks - I still have the fun part of moving, sizing, aligning, formatting a whole range of charts coming up. I had seen the Shape object used to move charts around,

Regards,