External data link change
I've a sheet linked to an external data on the net, and I would like
that a cell in this sheet to indicate the last date and time it was updated,
the simplest way the better but I can do some programming too.
Thanks for your attention,
No need of help any more, I solved the question.
...Microsoft Office 2004
I have the CD, the original packaging, but the CD box is missing - so too
therefore the product key. Please advise me, am I able to get a valid product
key without having to buy a new version?
You need to contact Microsoft Product Support Services to request a
new key. You will need proof of ownership.
On 7/16/08 1:43 PM, in article 873ee0b157aa1@uwe, "LesleyF" <u44879@uwe>
> I have the CD, the original packaging, but the CD box is missing - so too
> therefore the product key. Please advise me, am I able to ...MAPI and IMAP coexsistance on same client/server for transparent users in the wild...
An exchange 2003 server with enabled secure IMAP and OWA.
Clients running Outlook 2003 with both MAPI and IMAP connections to the same
server. This is for troubleless connections for users being both on the LAN
and out in the wild without VPN.
What are your experinces about best setup in this scenario - how will users
get the most transparent feel - that is: calender working, mails getting to
the same location, still available via OWA... regardless whether they are on
the LAN or in the wild.
Go with Mapi all the way for the functionality. Implement RPC over HTTPs for
rem...AddIn Functions Have File Path and #NAME? Error
How do I get Excel 2007 to drop the file path on formulas with Excel addin
functions in them?
I've just upgraded from Office 2003 to 2007 on XP and am having some trouble
with my Excel addin workbook functions. There are a number of addins that
are kept in a directory on the computer, C:\ExcelAddins. They are updated
from time to time and so everyone has them in this directory on there
computer so IT can upload updates. After the Office 2007 upgrade I added
all these addins to Excel 2007. In 2003 I would be able to access the addin
functions by typing in the name and pa...ConvertMyFile Only $6.99 Through 1/31/2005!
ConvertMyFile, the Windows Solution for File
Conversion, is on Sale for 30% off the Regular Price
Through January 31,2005.
�ConvertMyFile will transform Word Documents (in RTF
format) to PDF Files.
�ConvertMyFile will convert Excel Spreadsheets into
PDF format as well as into HTML pages.
�ConvertMyFile will also take your pictures (BMP or
JPG) and convert them into PDF files.
Compatible With Windows ME/2000/XP/NT.
Only $6.99 to license through January 31. Quantity
discounts and site licenses available.
Secure Payments Through PayPal www.paypal.com
Email email@example.com with ...Why does the change change to a number?
I've noticed something wierd and always wondered WHY it happens. When you
type a date into a cell, and then change the Formatting of it to a 'general'
cell, it turns into a number. How does it come up with that number? What is
i.e. type today's date of "12/7/2007" - change it to a 'General' format, and
it then says "39423".
I'm a trainer of Excel and this question always comes up. I'm curious
myself too. Thanks!
It's the number of days since January zero 1900 using Excel default for
windows (M...changing the way Excel displays selected cells
Is there a way to change the way Excel displays selected cells? I'm
interested in viewing all the selected cells highlighted (with light blue for
instance), but by default excel highlights all the cells but not the first one
the same occurs when you define a range with no adyacents cells
Your definition of the display is not quite correct.
Excel highlights the current cell, Excel also highlights a selecte
The currently selected cell is generally the first of a range, bu
press enter and the current cell changes and becomes the second, the
third etc in the range.
You cannot...DST changes for Exchange 5.5
I noticed the 2007 DST Calendar Update "Exchange tool" is available now:
This will seemingly take care of calendars for mailboxes still on Exchange
5.5 servers, as Exchange 5.5 is listed as "compatible" .
However would this address the CDO issues such as BlackBerry users and OWA
users still on Exchange 5.5 ?
Thanks in advance,
On Mon, 12 Feb 2007 14:31:00 -0800, itrcb4
>I noticed the 2007 DST Calendar Update "Exchange tool" is available now:
How do i remove the track changes in outlook? When i press "Enter", a symbol
that represents "Enter" will appears. Same for space etc.
...more on VBA function name change
I thought I'd start a new thread since I haven't received any replies to my
I've declared a function in a module using mixed case:
Function TMDE_Category (FormName As Form)
I noticed recently that it appeared in the module as
Function tmde_category(FormName As Form)
I changed it back to the mixed case declaration, saved the module, exited
the app, reopened it and looked. The function had changed back to the all
Things I've tried since the original post:
Using the databse documenter, I selected all ob...Stop sheet showing when Using Datapig's Force Users to enable macr
I think this is probably not do-able
I'm using Datapig Technologies example to force users to enable macros
When the workbook is closed all sheets other than a warning sheet are very
hidden so that if the workbook is opened with macros disabled then the user
can only see a warning sheet saying to close and open with macros enabled.
Then on opening with macros enabled the waring sheet is very hidden and the
other sheets can be seen.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
Sheets("Warning").Visible = True
Sh...Can't Publish changes with Deploy Manager
After a migration process, I can't publish the changes made on CRM. When I
try do this in Deploy Manager I get the follow error:
Publish done with errors. See the event log to get deitails
NETRA-INOVACAO: ***Error*** Failed to download XSL template files from Web
Can somebody help me? I don't know if the migration process have any
relationship with the error.
Thank you for pay attention.
Vin�cius Pitta...Microsoft Outlook #22
I am trying to figure out how to receive/sent emails with
Microsoft Outlook from a remote site computer (away from
office/home computer). Where can I find this information
or what are the procedures? I like access my e-mails
Unless you are talking about an .ost file with Microsoft Exchange or Outlook
Web Access, you better HOPE you can't access your local Outlook over the
internet as this would mean that your computer is open to anyone on the
However, if you mean can you setup a mail account identical to your one at
home, then if you are using the same ISP,...aarow keys don't work
I'm not sure why, but suddenly, my aarow keys do not work any more. Well, they don't do what I want them to, at least. I know I have run into this problem before at work, but I didn't see how the issue was fixed. But, I do know, there is a way to fix it. Right now, when I hit an aarow key, it moves the page instead of changing which cell is highlighted. How do I change them back to normal? Thanks.
n i k i
Scroll lock key hit by mistake?
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.
"niki" ...Filter contact records by customer type code in views
In version 1.2 I had set up several views of contact records by customer
type code. In 3.0 this field cannot be selected as filtering criteria. While
the views I had set up in 1.2 work, that cannot be changed.
Is there a reason this field is no longer avialable under 3.0? This field
is listed attribute. Is there a way to may it appear?
Thanks for any help you can give.
Microsoft CRM Support maybe of help with this one, try submiting a incident
> In version 1.2 I had set up several v...Installation problems #2
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
When i install office on my desktop it installs ok but when i try to open word or excel it comes up with the customer experience program everytime and launches microsoft update i then click "no, i dont want to participate at this time." and then continue, then the get started window appears and i click finish but nothing happens, then if i try to open word or excel again it does the same thing again and it doesnt ask for the product key at any time. But when i installed office on my macbook it works fine,...How to change icon for my application
Hi, I am currently developing an application on visual studio 6.0, and i
wish to change the MFC icon on my application header. Anyone can help? Thank
Raed Sawalha wrote:
> Hi, I am currently developing an application on visual studio 6.0, and i
> wish to change the MFC icon on my application header. Anyone can help? Thank
Open the icon resource for editing by double clicking. Then notice the
control just above the editing grid that lets you switch between editing
the large icon and editing the small one.
Scott McPhillips [VC++ MVP]
thanx that work...using IMAP and Outlook to share folders on 5.5 SP4?
I've got a client with 5.5 SP4 who wants to be able to drag an email from his
inbox to a shared folder that his assistant can access.
The server is outside their network, so can only use IMAP or POP3
I tried opening up port 143 for IMAP and created a new public folder using
Outlook. I can see this new folder using Exchange Administrator app.
When I drag an email from the Outlook inbox into the new public folder, I get a
Can't move the items. The server responded: REFERRAL
imap://userName:AUTH="@server.com/Public/%20Folders/Test] there is no replica
for that mailbox o...How to change newsgroup message font
Like many other ribbon based programs I sometimes struggle to find how to
make a change. This time its how to change the font just for newsgroup
"nobody" wrote in message news:EWTao.39493$GF5.7129@hurricane...
> Like many other ribbon based programs I sometimes struggle to find how to make a change. This time its how to change the font just for newsgroup messages?
Newsgroup messages are usually plain text. The font used is that selected at [no name tab] > Options > Mail > Read > Fonts for the encoding specified for the messag...Notify change of email address when changing ISP
How do I notify my entire address book of an email address when I change ISP's?
By sending a mail to everyone ?
If you do so, please use BCC for the adresses, this way you won't spread
everybody's e-mail adres to everybody.
Bob Baker wrote:
> How do I notify my entire address book of an email address when I change ISP's?
...Which one first?Install Windows Server 2003 SP1 or Exchange SP2 ?
We are running Exchange 2003 on Windows Server 2003. We planned to update
the software in terms of patches, so which one should I do first, the OS
patches (SP1 and onwards) or the Exchange patches ?
If it was me do the OS first.
"Zul J" <firstname.lastname@example.org> wrote in message
> We are running Exchange 2003 on Windows Server 2003. We planned to update
> the software in terms of patches, so which one should I do first, the OS
> patches (SP1 and onwards) or the Exchange patches ?
...CRM data migration 10-13-04
Is there an easy way to migrate data from one CRM server to another?
I have looked through the Data Migration toolkit, but it seems to be geared
more towards migrating Goldmine/Act/etc to CRM, by populating the cdf tables
> Is there an easy way to migrate data from one CRM server to another?
> I have looked through the Data Migration toolkit, but it seems to be
> more towards migrating Goldmine/Act/etc to CRM, by populating the cdf
You need to use Redeployme...Cannot open file after installing Office 2007 Service Pack 2
I cannot open the publisher files after I installed Office 2007 Service Pack 2.
Does anybody know what to do?
Luckily one of our PCs has not yet the SP2. this way I can at least work.
Thanks for help
Are you getting an error?
You may have to do a registry fix:
Error message when you try to open a publication in Publisher: "Publisher cannot
open the file" or "Publisher has detected a problem
Do you have Norton?
How to use Office programs with the Norton AntiVirus Office plug-in
...Change a formula to an acual number
I want to change the formula I have created to the number it has created
Example: Cell A1 is the number 1. Cell A2 is the formula =a1+1 creatin
the number 2. I want this to be a two not a formula. Any ideas?
Laura, copy, then paste special, valves
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Laura" <email@example.com> wrote in message
news...eConnect 7.0.4 install new company
We have Great Plains 7.0 running with eConnect v188.8.131.52. We just created a
new company database and I need to install the eConnect sprocs into it -
can't find how!
I've tried thru Add/Remove Programs but the option to install into a new
company database does not appear
Pulling this out of an old and undependable memory, but I think under 7.0
you had to uninstall and reinstall eConnect when you created a new company.
Nicely fixed in, I think, 7.5. Again, could be wrong here and would be
happily corrected by anyone that know differently.
If you do the uninstall, yo...