Is there a formular or format to change 1 to one
Is there a formular or format to change a number "1" into the word "one".
"Kevin" <Kevin@discussions.microsoft.com> wrote in message
> Is there a formular or format to change a number "1" into the word "one".
(remove nothere from the email address if mailing direct)
"Kevin" <Kevin@discussions.micro...Compile Error: Can't Find Project or Library
I have a spreadsheet containing 7 userforms and 9 modules. The
spreadsheet has been developed on the same computer for a number of
years and remained stable. However, I now want to make some amendments
to one of the userforms. Whenever I make any changes to the
UserForm_Initialize statement (even entering a blank space), I get the
compile error 'can't find project or library'.
Does anyone know why this happens and, more importantly, how to stop it.
Operating System: Mac OS X 10.4 (Tiger)
I'm thinking of buying Mac: Office 2008, but before I do I want to check that I will be able to download Scritpsmart collection of templates without any glitches:
Does anyone know if I can do this?
In article <email@example.comR9absDaxw>,
> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: intel
> I'm thinking of buying Mac: Of...XmlSchemaSet Compile error ?
Here under 4 schemas i'm working with ( it may be long: sorry...)
The context is the following :
Resident.xsd imports Person.xsd and includes Common.xsd ( anonimous schema:
no TargetNamespace )
Person.xsd includes Common-Naming.xsd ( anonimous schemas )
Common-Naming.xsd includes common.xsd ( both are anonimous schemas )
Compilation of Resident.xsd raise the following exception:
"System.Xml.Schema.XmlSchemaException: The attribute 'oid' already
That is wrong : the schemas are valid and well done ( Xml-Spy ).
The problem seems to be that Common.xsd app...Attached Toolbars Macros
I have a custom tool bar, this tool bar has several items, each item is
pointing to a VBA code. This tool bar is attached to the worksheet.
I've copied this spreadsheet to several computers. After I copied the
spreadsheet I decided to rename the spreadsheet, after I renamed the
spreadsheet the Toolbar Item's macros were still pointing to the old name, I
reasigned each tool bar item to the current spreadsheet, saved the
spreadsheet and everything was working on my computer, but when I re-copied
the new spreadsheet to other computers and I clicked on the Toolbar Item...VBA code to say Yes or No if any VBA code is present in ActiveWork
Using XL 2003 & 97
Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.
I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .
I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
David McRitchie, Microsoft MVP - Excel ...Outlook Today
Outlook 2002 - Outlook Today allows customizing. When I select the
style names Summer and save changes it shows up for that session. Next
time I start Outlook it's back at the default. Is this a bug???
Don in San Antonio <firstname.lastname@example.org> wrote:
> Outlook 2002 - Outlook Today allows customizing. When I select the
> style names Summer and save changes it shows up for that session.
> Next time I start Outlook it's back at the default. Is this a bug???
Try setting it in the registry directly.
"...Run macro automatically.
How do I make a macro run automatically when a worksheet it is attached to is
right click on the sheet tab>view code>left window worksheet>right window
"Excel macro" <Excel email@example.com> wrote in message
> How do I make a macro run automatically when a worksheet it is attached to
I am unable to find "activate " when I right click on worksheet. ( i assume
that you are referring to the windo...Help with macro/and or formula?
Perhaps this is a silly question, but i just can't figure out how t
format this worksheet. The problem is that a lot of the cells hav
numbers in them with negative signs in the back instead of in the fron
(ie. 23-) and i was wondering if anyone knew of a macro/formula i coul
use to quickly fix this problem for all the cells. I would b
extremely grateful. Thanks
brefed15's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3557
View this thread: http://www.excelforum.com/showthre...Let me use the Line Color icon on charts
It would speed up a lot of my work if I could use the Line Color icon on
Excel charts, the same way I am able to use the Fill Color and Font Color
However, when I highlight any chart object, like the Plot Area, Chart Area,
or a Series, the Line Color icon is disabled.
Stuart Bratesman, Jr., MPP
Muskie School of Public Service
Univ. of Southern Maine
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If ...How to Use One PST file on Two Computers?
I have a desktop machine with a pst file in my Outlook 2003. I would
like to copy this pst file to my laptop. How do I synchronize the same
file on 2 machines so I won't get duplicate e-mails? I use one premium
Yahoo e-mail account and several free Yahoo accounts with YahooPOPs..
Thanks in advance,
it is not possible by default to share PST files.
A list of a list of third-party synctools are also on this site:
On the Microsoft Office Marketplace site is a list of third-party messaging
http://office.microsoft.com...Unhandled object exception error message
one of our staff is receiving this message when trying to export an excel
document from Smartlist:
Unhandled object exception:
Unable to set the Interactive property of the Application class
Does anyone know what this means and/or how I can resolve the problem
...Use VBA to update Access table or Query from Excel
Can I use VBA to update Access table or Query from Excel?
Thanks in advance
> Can I use VBA to update Access table or Query from Excel?
Of course, using ADO or DAO.
Jan Karel Pieterse
Thanks. I think ADO is what I want.
But I am not only want to export from excel to access.
I want to edit some data in access table.
For example, Access has a table "ProductList"
I want to use Excel to call the product by "Pro...Some macro help with shelling out to other program
We are using VNC in house to do remote control between workstations.
As there are over 25 of them, I would like to set up a little macro in
Excel (2003) that when run, displays a list of user names along with a
box prompting for which # on the list you want to connect to.
Here's what I have so far:
Shell ("c:\program files\hyena\vncviewer.exe sv-ws6")
I would like to see something like:
Please enter the number to connect to:
Typing 1 and pressing ENTER would run the Shell command abov...Missing DLL file prevents me using PST Files?
Hello - I posted on here a while ago asking for help as following a company
merger I cannot use PST files in Outlook 2000 (Windows NT machine).
I have been told that work have removed a DLL file which is causing this.
Do any of you have experience of this? If so any idea what DLL file I need
to add back in?
Do you mean that the corporate IT removed the DLL so you can't use PSTs? Do
they have a good reason for this?
"Carl Jarvis" <firstname.lastname@example.org> wrote in message
news:email@example.com...Query Based Address List using boolean "company1 or company2" possible?
Hello, I'm trying to make a query based address list for multiple
companies so that all those from company1 or those from company2 will
be included in the address list.
I've tried just adding both filters "company is exactly company1" and
then the next of "company is exactly company2" through System
Manager>Recipients>All Address Lists, Right click, click Filter
rules>Advanced Tab... but it yields no results, as it appears it's
and'ing them (if company = company1 and company=company2).
Is there a way I can make a filter to include both companies w...Print, Merged Cells, and VBA
I'm looking for a code that will help me with a print job
for a worksheet. There are a lot of merged cells and a
lot of "IF"s to be used in the VBA for range selection.
Thanks in advance,
...Hyperlinks that I recieve in e-mails don't work in outlook 2003
LMT <LMT@discussions.microsoft.com> wrote:
Ask your question in the body of the message, not the subject.
If you're using Internet Explorer, try this: click Tools>Internet
Options>Programs>Reset Web Settings
"Brian Tillman" wrote
Thanks Brian worked great.
> LMT <LMT@discussions.microsoft.com> wrote:
> Ask your question in the body of the message, not the subject.
> If you're using Internet Explorer, try this: click Tools>Internet
> Options>...Dex 11 error
I am getting the flowing error when using test mode. This error occurs
before the login screen appears and when error I click the server drop down.
Has anybody ran into this error before?
Unhandled script exception:
Could not load external 'DexIsODBCsqlDriver@GPDWIN32.dll'.
Reinstalling the application will help.
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
"Jason" <Jason@discussions.microsoft.com&...VBA and Scheduled task in Outlook
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don'...Footer Macro?
Months ago I read a Public Sub Macro that read the selection of a drop down
list in a combo box and placed it in the center Footer at the same time it
also placed the date in the right Footer and tme in the left footer. I have
searched most of the regular sites including this one and cannot find it
anywhere --- Can anyone help with my search.
Any help much appreciated
Cheers ---- Mully
...vba select field
having a button on a form, is it possible to select only some fields
(all from the same table) of the current record instead of all fields?
I've tried this code:
Forse dipende dei dati nel record.
but it selects ALL fields in the form.
On 10.04.2010 18:01, remigio wrote:
> having a button on a form, is it possible to select only some fields
> (all from the same table) of the current record instead of all fields?
> I've tried this code:
> RunCommand acCmdSelectRecord
&...Using CListCtrl #3
Does application get any notification message,
when List Item is losing Selection?
I need to apply some checks and want to prevent
deselection in some cases?
...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...I can't change fonts. Why??
I have a strange problem, with Publisher. I only can use some basic fonts in
textboxes. If I choose one (for example Jokerman), the font bar jumps back to
Times or to other basic fonts.
I have this problem on Vista-Office2007 Beta 2, XP SP2-Office 2003, XP
SP2-Office 2000 too. What is interesting, that I can use all of them in the
In Word I can use all of the fonts too. What could be the matter?
Could you help me?
Thanks, Gábor from Hungary.