Macro problem #3
I have a exel file which always asks me whether I want to disable macro
during start up. I don't need any macro in it at all and I checked from menu
Tool->Macro->Macros. But there is nothing in the list. How can I find it and
delete it please?
You could take a look here...
Microsoft MVP - Excel
"JL" <email@example.com> wrote in message
>I have a exel file which a...Copy contents of cells if cell contains information
I have a column of cells, say A1:A30 in a few different spreadsheets. Some
of these spreadsheets contain information within these cells (not formulae,
but just typed info) and some don't contain information.
Now, in a new spreadsheet, I would like to copy the contents of these cells
(columns) if there is information in them.
So for example, in spreadsheet 1, i have information, speadsheet 2 i don't,
spreadsheet 3 I do, i would like my information to be copied into a new cell
Test this on sample (or backed-up) work...Outlook Client install problem
Client did the following:
1. Accidentally tried installing the "full" Outlook client on a desktop.
Somehow the install failed.
2. Did a correct install of the "light" client. But received the "can not
connect to CRM" error when opening Outlook.
3. Uninstalled and tried to reinstall the Outlook desktop client and
received this error:
"Action Microsoft.Crm.Setup.Common.Analyzer+CollectAction failed. Fatal
error during installation"
We can not get it past this error. Any help on this would be appreciated.
I think th...Store Credit multi Store
Can someone give advice about how to set up Store Credits for a multi
store enterprise. Currently the client use store credits/vouchers at store
location only and can only redeem a Store Credit where it was issued. We
would like to set it up so that they can redeem a store credit at any store
location no matter where it was issued. Three stores connected via HQ. Thanks
I believe you can set up an account type and call it 'store credit' or
something, then when you enter the new customer information for the person
receiving store credit you simply assig...Problem with Excel 2007
Hi Everyone, It is my first time working on Excel 2007. I was working on a
project which I started on Excel 2003, I opened another project for reference
and when I returned to the first project all sheets disappeared. The only
accessible buttons on the toolbar are the Macro buttons. All macros are
still there and sheet names in the VBA are still there. Did I loose my work?
Thanks to all
Hi Everyone, It is my first time working on Excel 2007. I was working
> project which I started on Excel 2003, I opened another project for
referen...can't authenticate to Exchange
I can't authenticate to Exchange with Outlook but I can
access mail through Outlook web access.
I am running Microsoft Exchange Server 2003 on Windows
Server 2003. All of the clients accessing the Exchange
Server work from home and use Outlook not Outlook Express.
ON THE EXCHANGE SERVER SIDE:
In the Exchange System Manager in POP3 Virtual Servers
Properties dialog box, under the Access tab, under Access
control \ under the Authentication button. I have Basic
Authentication checked and Requires SSL/TLS encryption
In the System Manager in SMTP Virtual Servers Properties ...having a problem installing MSCRM 1.2!
I am having a problem installing MSCRM 1.2.
My configuration consists of a Domain Controller running Win 2000
Server SP4 . I am trying to install MSCRM on a member of the domain running
Windows 2000 Server SP4. There is a DNS Server on the DC which is integrated
with AD, and a SQL Server 2000 running on the Win 2K machine.
The install errors out when CRM creates the root business with the message:
Setup was unable to install Microsoft CRM Server.
Setup was unable to provision your organization.
Setup was unable to create the root business.
The configuration of ASP.NET seems to be ok, the pr...Error c0070005 when trying to run Exchange System Manager
Keep getting the c0070005 Exchange System Manager error message when I try
to open System Manager, as a reslult I can't manage anything.
Can anyone please help?
Is this is?
thogarr's Profile: http://www.msusenet.com/member.php?userid=185
View this thread: http://www.msusenet.com/t-187051570
Thanks for the post, but I tried that and it still doesn't work
> Is this is?
> http:...IWebBrowser2 + Get Container Problem
I need to run a 32bit activex into a 64 bit application,I use
IWebBrowser2 as Ole container.
I create the IWebBrowser2 and add my activex with navigate2() ,but
then I can't get a pointer to the Activex.
the function Get_Container always returns NULL, although the activex
is correctly embeded inside
Here is my code:
//create an internet ole explorer
oWnd.CreateControl( CLSID_WebBrowser, _T(""), WS...Problems Closing Billing Cycle
0000175: has a balance discrepancy. Accounts Receivable indicates a balance
of $725.03. The last closing balance indicates a balance of $722.24 as of
How do I rectify this. Do I void the invoice in ? Adjust the account or what.
...Money 2007; Encountered a problem and needs to close
After entering my password, I get "Microsoft Money has encountered a problem
and needs to close. We are sorry for the inconvenience"
AppName: msmoney.exe AppVer: 188.8.131.523 ModName: unknown
ModVer: 0.0.0.0 Offset: 00000000
Can anyone help?
Quicken. Less headache's
> After entering my password, I get "Microsoft Money has encountered a problem
> and needs to close. We are sorry for the inconvenience"
> AppName: msmoney.exe AppVer: 184.108.40.2063 ModName: unknown
> ModVer: 0.0.0.0 Offset: 00000000
> Can anyone help?
>...How can I keep the copy of my email on the exchange server
the company Lan: win2003+exchangeserver2003
I use outlook on my desktop to access my email accounts and it can read all
the emails on the exchange server. Then I want to use the outlook with the
same setting on my laptop to access the same account on this exchange server
but find there is no email. I think, maybe the outlook automatically deletes
my emails on the server after downloads them to outlook.
So how can I read all the eamils on both computers? Thanks
No, it doesn't as long as you do not connect to it by using POP3 or have a
pst-file set as your default delivery location.
T...Network Check before Moving from Exchange 5.5 to Exchange 2003
I'm going to be moving from Exchange 5.5 to Exchange 2003 shortly, and
already have a Windows Server 2003 AD environment in place, with a seemingly
happy ADC connecting to Exchange 5.5.
I'd like to make sure that my Windows 2003 environment is optimised before
making the move to Exchange 2003, specifically I want to look at AD
replication, FSMO roles, DC/GC placement and anything else that you can
Does anyone have some tools/scripts/checklists that I could use for my
project. If I have to go through my environment manually I can, but I'm
hoping that there is ...Exchange 2003
How do you access the IMS mailbox and System Attendant
mailbox in Exchange 2003? I am noticing a number of mail
items sitting in them that need to be deleted.
Thanks in advance!
If you're talking about the system mailboxes on Exchange 2003, then I'd
leave them alone. AFAIK, there's nothing in them that *needs* to be
For Exchange news, links and tips, check:
"Kit Adams" <firstname.lastname@example.org> wrote in message
> How do you ac...Getting email on Microsoft Outlook
I would like to know how to switch my email over to
Microsoft outlook 2003 from Outlook Express. I have
tried and it won't change.
Go to Internet Explorer, Tools | Internet Options | Programs and set the
e-mail program there.
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Karen" <email@example.com> wrote in message
> I would like...Question: sharing exchange calendars
Sharing exchange calendars outside of the local domain
Is it possible (and if so how) to share calendars in exchange from one
local.domain to another remote domain? I have a domain abc.local and I
would like to share calendars with people in a domain from another company
called xyz.local. I was thinking that they had to be part of the same
organization somehow but what if that isn't possible. Is there a way to do
Can someone email me or reply to this post as i need help with this ASAP.
My Email: backup (at) yahoo (dot) com.
My first thougt is Public Fo...Exchange enterprise 2003 to exchange sbs 2003
Hi, i currently running exchange Enterprise 2003. Because i don't have exchange 2003 enterprise license but only have exchange 2003 sbs, so recently i need to do migration from exchange enterprise 2003 to exchange sbs 2003. But what i concern about is sbs exchange have limitation with their database. I'm not sure whether is it a possible way to doing this so call "downgrade " migration?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Using Attributes with Enums
http://www.eggheadcafe.com/tutorials/aspnet/abbb43b9-a667-4930-9588-542844a32d71/using-attri...Intervoice IVR integrated with Microsoft CRM
I need help learning how Intervoice IVR (Interactive Voice Response) can be
integrated with Microsoft CRM. Anybody have experience with this?
...Microsoft Word Error
Does any body knows how to fix this? I tried Google and Microsoft KB, but
can't find anything.
When I try to write a document in Word, after I write a few lines, I get
Run Time Error
Program: C/Program Files/Microsoft Office/Office 10/Windword.exe
Abnormal Program Termination
Then there is an X to click out. When I click it all my document is deleted
The problem started about 2 weeks ago.
Windows XP/SP3, IE7, AOL 9.0 Security Edition. AVG Free 9.0
See http://word.mvps.org/FAQs/AppErrors/ProblemsStartingWord.htm for some
i keep getting gaps when i press enter once and was wondering how to get rid
By gaps you means spacing between lines, if yes then check your paragraph
space before and after, set it to auto or 0, as per your need.
I hope I understood your problem, if not do let me know, I shall tey to help
> i keep getting gaps when i press enter once and was wondering how to get rid
> of them
Do not use the First Style (in the Style box), use the one next to it which
says "No spacing" underneath. The Default ...Groupmail and Microsoft CRM
I would like to integrate Groupmail tool I use with MIcrosoft CRM. WHy? Our
mass mailings are html based(so they generally link to graphics, charts and
graphs) and we we deliver to 1000 + clients on a weekly basis. Is this
functionality available in CRM without utilizing Groupmail. Ideally, I would
like to be able to continue using Groupmail and then somehow track the
delivery of certain marketing material.
...Strange import problem -- dropping letters
Win7, Pub 2010 (but it also happened under XP/20007; I don't remember if it
happened with 2003)
When I import a Word file with some text that is "xxx.org" or .com or
similar, Publisher drops that last letter (it comes out .or or .co)
This also happened with a list of URLs -- dropped the last letter of each
address (which was a / or two & some words beyond the .com)
Sometimes but not always the last letter before a paragraph or new-line
Any idea why this happens?
I have learned to remember to proofread for these missing bits of web/email
addresses, but still....
...MSCRM Deployment manager domain list problem
I was trying to add users to MSCRM using Deployment Manage User Manager
but the wizards cannot list the available domain controller from the AD,
thus no users
can be displayed in the list.
What causes this problem?
We are getting the same thing.
There is an article on this but I do not have a customer loging yet:
KB 917946 CRM 3.0 Administration 06/23/06 User Manager Wizard does not
display the Active Directory User list in Microsoft Dynamics CRM 3.0
Maybe you do?
"Benjamin Fallar III" wrote:
> I was trying to add users to MSCRM using Deployment Manage...Exchange 2003
Could anyone tell me if Exchange 2003 has a POP3
connector built into it? If not, could third party POP3
connectors be used with it?
> Could anyone tell me if Exchange 2003 has a POP3
> connector built into it? If not, could third party POP3
> connectors be used with it?
Only the SMB version has a built-in pop-connector.
There are several third party connectors that work fine. I've tried
PopBeamer and GFI MailEssentials with no trouble.
No it doesn't but I believe the SBS version does. There are plenty of 3rd
party ones available that Google will...Auditing Public Folders in Exchange 2003
Is there a way to setup auditing for Public Folders in Exchange 2003?
I want to be able to receive events in the eventlogs whenever a change
has been made to Client, Directory or Administrative permissions.