How to store custom data into Excel cell
I'm writing a custom add-in for Excel. I need to store some custom data
within Excel document/sheet/cell. Similar to "Web query" in Excel -
when it is put in Excel sheet, it saves information about original URL
and cells can be updated later. Similar to that, I would like to save
some other information for each of the cells I will create from my
add-in. For example: I would create 3 cells from my add-in and would
like for each of those cells to save the information about some IDs,
source of that cell (for example - file name) or anything else.
It would be enough f...unable to recognize BizUser class while customization
I'm trying edit the use the customization examples
given.I've added the Microsoft.CRM.Platform.Proxy.dll to
references.But when I use the following statement
Dim bizUser as New Microsoft.CRM.Platform.Proxy.BizUser
Dim bizUser as New Microsoft.CRM.Proxy.BizUser
The Microsoft.CRM.Proxy.BizUser part gets underlined and
hence cant move ahead.Is anyone able to move ahead from
this place.Should I be doing anything addtional to this to
get the statement working?
Suggestions or Help appreciated.
...Enabling Activity on Custom Entities after they have been created
I am enable to activate on Custom Entities after they have been created
There is no Microsoft Supported way of doing it.
PLEASE do click on Yes or No button if this post was helpful or not for our
Email for direct contact: imumar at gmail dot com
> I am enable to activate on Custom Entities after they have been created
...Zero % change to "-" custom number format
We are working with an add-on product that exports data into Excel. The product exports raw data into our spreadsheet and we do the formatting. The problem we have is that we want to replace 0% with a dash "-". I have tried a few things in Cell Format with custom numbers, but without any luck. We are looking for a custom number format not a macro to resolve our issue
Thanks for your help in advance.
"David" <firstname.lastname@example.org> wrote in message
> We ...Is there a way to use "Custom Login Page"?
I know only users from Active Directory can use CRM System.
But is there a way to let users login on Web form instead of windows prompt?
And how can we integrate it with existing system?
This may help you:
You can make Internet Explorer prompt for user names and passwords by
changing the security settings. Start Internet Explorer, then select
Tools | Internet Options. Click the security tab and click on Local
Intranet (depending on how your network is managed you may need to
choose Trusted Sites instead). Then click on Custom Level.
In the Security Settings dialog box scroll to th...Timed automatic update of chart
I am having great difficulty in doing the following and would be
grateful for any assistance.
Cell A1 is updated every few seconds using a DDE link.
I would like to create a chart within the same workbook that plots
whatever is in A1 Sheet 1 every 5 or ten minutes throughout the day.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
...Add automatic Customers Number in Great Plains Dynamics
Hello, I believe that it is due to have like an option to be able to generate
consecutive of clients in the window customers maintenance.
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 you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/def...Qty on hand vs. Balance Sheet inventory
How is balance sheet inventory calculated? When I sum up the product of qty
on hand and current cost it does not match the final Balance sheet number?
One would think it would.
How are these calculated and synched?
It depends on the method chosen to value inventory. There are 5
methods to choose from -
1. FIFO Perpetual
2. LIFO Perpetual
4. FIFO Periodic
5. LIFO Periodic
Current cost is the last cost the item was received at on a purhase
order receipt, manufacturing order receipt, or an inventory
To make your comparison to Book (balance sheet) Inven...Customization gets disabled when GP restarts
I have some code that creates menu items and a toolbar. I am storing the
triggers for that script in Startup. When I start GP, I go to 'Tools ->
Customize -> Customization Status' and enable the customization. My other
code then works fine. But the menu items and toolbar that I am creating
doesn't get created because the code for that runs when the GP starts.
Now if I turned GP off and restarted it, the code still doesn't run. I
checked the status of my customization and is disabled event though I enabled
it before restarting.
How do I save the status of my...balancing acounts # of transactions.
I upgraded my microsoft money when I bought my new computer. When balancing
statements the microsoft money use to list how many transactions had been
marked as cleared so I could compare this to my bank account. Is there
anyway to have the latest version of microsoft money show this? This was a
really nice feature because I would know how many transactions I needed to be
Yes it was. No there isn't.
"bduncan" <email@example.com> wrote in message
>I upgraded my microsoft mone...Automatic Monthly Reminders
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
How can I set up Automatic Monthly Reminders and in what program does that possibility exist.
In article <59bb35cc.-1@webcrossing.JaKIaxP2ac0>,
> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: Power PC
> How can I set up Automatic Monthly Reminders and in what program does that
> possibility exist.
Not word or office, definitely. Try iCal.
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all ...Custom Function for Pivot Table
Is it possible to attach a customized function to a field calculation in a
pivot table? For example, if instead of AVERAGE I want WTDAVG, I would write
a function for WTDAVG and it would show up as a choice in the available
I don't think Pivot tables work like that, but I could be wrong. Anyway, why
don't you do this outside of the Pivot Table. Create a helper column for
your weighted average and do the calculation there. Do a little research on
the Getpivotdata function:
If thi...Change salesperson for mutiple customers
We fired a salesperson and hired a new one, I want to do a mass change on the
customer cards to put in new salesperson. I don't want to enter each change
Unless they fit neatly in a customer class, you will probably want to use a
tool to update the records. You could use a SQL query (Update RM00101 set
slprsnid = 'new' where slprsnid = 'old' and Update RM00102 set slprsnid =
'new' where slprsnid = 'old') or MS Access or some other tool.
Charles Allen, MVP
> We fired a salesperson and hired a new on...Pivot Table Custom Subtotals
I have a pivot table that's connected to Analysis Server. For some
reason, I can't select custom subtotals (the options is greyed out)
when I try to edit the field settings. Are there some requirements
that have to be met in order to use custom subtotals?
...Customized Menu Item per user
From what I've seen of the SDK, it is impossible to add customized menu
items on a per user basis. Is that correct?
I would like to add some additional administrator menu items, which
obviously should only be shown for users with administrative rights (in a
3rd party integrated application).
Any customized menu is available and visible to all CRM users. There is
no way to setup a menu that is accessible to only certain users or
groups of users. You would need to build that security into your 3rd
party integrated application.
"Anil" <anil@ani...Update Customer email address using SQL statement
Recently we changed from Yahoo Groups to managing our own email list. Our
list went from 1400 addresses to around 3600. Of those, about 400 turned out
to be hard bounces. I would rather not have to update 400 records, one at a
Can anyone help me write a SQL statement that would update these records
from a file, list, or table containing the bad addresses. What I need to do
is blank the email address and put a statement in the Company field (e.g.
Need to Update Email).
If there is another (better) way to do this, I am totally open to suggestions.
Thanks in advance!
Keiz...How to deploy custom form in Ex 5.5
We would like to append a commom text to all outgoing
emails by users . There is way to do this for internet
mail only but we would like to do this for all emails.
Is there a way to push a default outlook mail template
for all users in the org without users intervention to
install the custom form from the Organization library ?
Microsoft MVP - Terminal Server
>We would like to append a commom text to all outgoing
>emails ...How to customize the appearance of a multiple document peoject ?
How to customize the appearance of a multiple document peoject ? I mean the
color of borders , dockbar areas, toolbar background, etc .
There is no magic trick for this. You will need to do each individually
unless you go towards themes(whatever limitations it may have).
"new" <firstname.lastname@example.org> wrote in message
> How to customize the appearance of a multiple document peoject ? I mean
> the color of borders , dockbar areas, toolbar background, etc .
Thank...Automatically insert row between groups of records
Can someone provide a suggestion for the following scenario? I have a list
like the following (or I will, once I apply a macro solution I found in
another post). I'd like to scan through the list, insert a row at each
change in value in Column1 (column headers don't actually exist in my
worksheet), and insert a lookup formula in Column 2 of the newly inserted row
which uses the value in Column 1 to lookup a corresponding value on another
Column1 Column2 Column3
1000 Requirements 40
1000 Design 5
1008 Requirements 10
1008 Design 8
Run a macro that produ...Custom View for Managers
I have been asked to create a view for the managers in my group where they
can see for just their directs the time they have posted to their tasks. Can
someone explain how i can do that.
If they are using My Tasks and submitting time to the PM's for approval and
getting those hours approved and loaded into the schedule and then
re-published back out, you could create a data analysis view using the
MSP_Portfolio_Analysis Cube that shows the resource actual hours vs. planned
hours and/or baseline hours along with any project or resource custom field
information. For exampl...Qucik Access Toolbar not showing custom controls
I'm having a problem with the QAT in access 07
I'm trying to add custom buttons via XML, and not having any luck.
I can populate the QAT with IDMSO controls, but when I use a custom id
button it doesn't show in the QAT bar.
Below is a sample code I have been working with, the Copy and Paste
buttons will show up but not the Test button.
<button id="Test1" label=&q...Importing Outlook 2003 contacts into custom desktop software
I am working on a desktop software and using dot net( C# and its a
standalone software , its not a outlook pluggin). I have to import
Outlook 2003 contacts into my software. How would i go about it?
Are outlook 2003 contacts held in a file, which file is this?
Moreover, what is a PST file and what information is held in PST file?
I have never programmed Outlook 2003 so please enlighten me...Obliged.
Any help or comments will be highly appreciated.
...automatic search and delete
Does anyone know how to search for text string and automatically delete the
row that contains that text string.
The problem is i want to search a whole worksheet for a certain word and
when it finds that word, I would like that whole row deleted and then
continue until it has deleted all the rows that contain 'the' word i was
Thanks in advance
you may try the following (an adaption of a procedure Chip Pearson
Dim RowNdx As Long
Dim LastRow As Long
Dim LastCol As Integer
Dim ColIndex As Integer...M06: Automatic Update Bug Fixed?
M05 does not update accounts when you started regardless of whether you
check the box to "Automatically update accounts when I start Money."
Instead, it would usually update every day but at seemingly random times.
Because of this bug, I am now simply clicking "update now" every day. So
much for automatic updates.
Does M06 update/fix this issue? I would prefer that M06 update once per day
the first time I run Money each day.
Please let me know.
The "automatic" update only happens if you have Passport enabled -- the
screen could be clearer -- and ...Online update adjusts beginning balance
I'm trying to update my credit card account, but each time I do, the
beginning balance is increased by several thousands of dollars (a balance
I've never come close to before). This was also happening to a lesser extent
with my checking account, but it appears that since I reconciled that
account, I'm not having that same problem. But even after I reconcile the CC
account, it still updates the beginning balance, and I get the following
"Money downloaded information from your financial institution, but was
unable to balance your account. This may be because ...