VBA in Access to detect a corrupt Excel workbook on open
Thu, 11 Mar 2010 14:43:12 -0800 (PST)
I am running some code within Access 2003 that opens and manipulates
then saves an Excel 2003 workbook.
The problem that I have is that once in a while the workbook that I
get from our vendor (through FTP) is corrupt.
"The fils is not in a recognizable format"
How can I test for this before proceeding into ...
|
Ribbons in Office
Thu, 11 Mar 2010 05:53:01 -0800
Hi,
I already posted this question in a newgsgroup but I can not find it anymore.
Well, I have some VB6 COMAddIns that extend the UI from Outlook and Word.
These COMAddIns should extend the Office UI in Office 2010 with Ribbons
instead the CommandBar objects.
It would be very nice, if I could extend one Ri ...
|
Content Control Highlighting
Wed, 10 Mar 2010 13:46:01 -0800
Is there a way to disable content control highlighting in word 2007?
I know that in the Word 2003 xml toolkit there is a way to set tag coloring
by means of editing registry settings. I was wondering if there are registry
settings that manage content control properties.
...
|
Force Feedback with Powerpoint Animation
Tue, 9 Mar 2010 13:18:01 -0800
My powerpoint presentation is being controled by a gamepad. It is not a
game. On one slide there is an animation that moves left and right. I would
like the game pad to buzz back and forth with the animation. Is there a
simple way to add this effect with a VBA macro? It just needs to buzz right
and buzz ...
|
Find and Replace Whole Words (like in Word)
Mon, 8 Mar 2010 12:26:45 -0300
Hi All:
I need to find and replace text using VBA and the only feature available in
VBA is the Replace Function. The problem is that I this functions has no
'matchcase' and/or 'matchwholeword' (like Word's Find Property).
Can someone point me towards any possible piece of VBA code that may add
'matchcase' an ...
|
How do you manipulate Powerpoint TextRange Indent and Tabulations with VBA ?
Sun, 7 Mar 2010 09:38:21 +0100
Dear VBA experts,
As a powerpoint user, if i put the cursor in a form with textual content,
and if the rulers are displayed, i can do many things in the rulers like
insert a tabulation, redefine indent for the different levels of text
Can such manipulations be programmed with VBA ? If i record a macro, the ...
|
sql server report service 2008 working with word 2003 or 2008
Thu, 4 Mar 2010 15:56:01 -0800
Since I am new to sql server report service 2008, I have the following
questions to ask:
1. I have alot of reports that need to have one to 10 paragraphs written
prior to when the table is displayed. Thus, I was thinking there would be
toolbox items like a 'word' document that you can drop onto a sql serve ...
|
|
|
MS Excel 2003 - Advanced Features Add-In
Thu, 4 Mar 2010 08:05:38 -0800 (PST)
The Advanced Features Team is pleased to announce the release of the
first version of their Add-In for MS Excel 2003.
Part of this realease are the following functionalities:
* Easy and powerful connection between MS Excel and MS Access
* K-Means clustering algorithm
* Additional User Defined Form ...
|
PowerPoint Events
Wed, 03 Mar 2010 11:22:40 -0800
Hi --
Is this the best group for posting questions about VBA in PowerPoint?
I couldn't find any that seemed more specific to that product.
Anyway, I'm wondering about doing a few things in PPT, and haven't
worked much in it before. We need to put up a "speaker timer", similar
to those used in political ...
|
Office product number retrieval
Wed, 3 Mar 2010 07:54:01 -0800
Hi.
I want to use a Serial number protection in my own Office Addin and I want
to generate this SN depending on MS Office Product Number.
Is there a way to retrieve MS Office product number programmaticaly?
Or maybe some kind of MS Office unique instance identifier?
Thanks. ...
|