How do delete Hidden Macros and excel links
I was wondering if anybody knew of an add-in that would
delete hidden macros or excel links. I remember there
being one but forgot where to download it for free.
To remove all code from a workbook:
You need to look for the heading:
"Deleting All VBA Code In A Project "
To remove links you can use freely downloadable Addin FindLink from:
Steve Bullen hosted:
Norman Harker MVP (Excel)
Excel...service calendar in MS Dynamics 4.0
Does anyone knows how we can achieve the following requirement with MSCRM 4.0
In the service calendar in MS Dynamics 4.0 you are able to create new
appointments and service activities. Appointments and Service Activities
which are created will be present in the Service Calendar.
To see all details of such a record[Subject(default Value)] you must open
it. But by moving your mouse on the concerning appointment or service
activity, a text-box-view appears with primary information.
With appointments the content of the following fields is displayed:
'show time as', 'subject...dynamic resource
Anybody know how to load e.g. bitmap into resource dynamicaly? The bitmap
file will be downloaded by application itself , so it has to be somehow
inserted into resource and displayed.
What do you mean by "into resoure dynamically"? Do you want to load a
..bmp file and display it? If yes, take a look at GDI+, which is by far
the easiest way to achieve this.
I misspelled this, yes I'd like to load new bitmap
on the fly. But resource file looks like is static.
I use ATL/MFC applicatation.
"Ajay Kalra" <aja...Linking problem
when i try to compile my project i get the following
LINK : fatal error LNK1104: cannot open file "dsprop.lib"
Where is this file? What should i do?
> LINK : fatal error LNK1104: cannot open file "dsprop.lib"
> Where is this file? What should i do?
You need to update your platform sdk.
Kobi Ben Tzvi
"Emmanuel" <email@example.com> wrote in message
>...Dynamic sum in Chart
So I've got this pivot chart that I've created, and it's great, EXCEPT
when I select different categories to show up, I want to show a SUM of
the categories, not the values of each category. I would appreciate any
help/advice you may have.
In the pivot table you can select different thing like count and SUM
etc. If you right click in the upper left vacant square and chose field
settings, then select what you want to see in your data section.
> So I've got this pivot chart that I've created, and it's great...Folder-Link Icon in Outlook 2003
In the past (Outlook XP and before) I could distinguish between a regular
Folder and a Folder-Link (.xnk file). Their icons were different.
In Outlook 2003 a Folder-Link icon looks exactly the same as a Folder icon.
Is they any way I can influence the look of Folder Link icons ?
You can change the xnk-file icon association by going to Control Panel->
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Arie Blonk" <Arie Blonk@discussio...can i use excel to generate web links
I work for a charity - we're going through our donors at the moment and have
to search for each one individually in the charity commision website.
I was wondering if there's a way of using excel, which already has our data
in, to generate urls linking to the above site's (or any) search engine
incorporating the contents of a cell.
i'm searching for dog
the search page url is www.search.com/search=??
and want to genenerate www.search.com/search=dog
I want to generate one of each of these for each donor
any thoughts would be greatly appreciated
Maybe yo...Anti-Phishing filter blocking many legitimate links
The anti-phishing filter in Outlook SP2 is a great idea but the
implementation makes it worthless. It is blocking links in so many
legitimate messages that I find I am allowing the link to be active
Is there any information on what the criteria are for a link to be
considered unsafe? How would the writer of a newsletter get his or her
links off the verbotten list?
there is no information on it - otherwise spammers would make sure theirs
were not blocked. The only links I have blocked are ones where the hyperlink
domains are mismatched. i.e., Sears uses cheetahm...Linking to folders
Hope someone can help.
I am trying to use excel to create a shortcut to our electronically
stored files. Although I can use hyperlinks to link to specific files,
is it possible to open a folder through a hyperlink or macro?
Files are stored on a network and not on the hard drive in case this
makes a difference.
Sidnoir's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25916
View this thread: http://www.excelforum.com/showthread.php?threadid=392893
I don't h...SharePoint Alternate Access Mapping to my Dynamics GP BP site
If I have posted this question in the wrong forum please let me know!
I’m looking for some guidance on changing the Alternate Access Mapping for
my Dynamics Business Portal site. So I can implement Single Sign On via ISA
Server which is supported on one web listener.
Default Zone: http://geneva:222
I would like to add:
Internet Zone: http://dynamicsbp.proclub.com
I presently have another SharePoint Collection (The Main Portal)
http://geneva configured which listens on Port: 80. I tried to add the
Alternate Access Mapping http://dynamicsbp.proclub.com...Tab seq dynamically...
I have a button which added dynamically to a property
sheet. Now for setting the tab sequence with this new
button, Am using SetWindowPos() method. Now tab sequence
THE PROBLEM IS
Through the arrow keys, I could not navigate to the last
button for which I called SetWindowPos. where as through
tab keys I could go to the last control. I will appreciate
ur help in this.
I have three buttons (OK,Cancel, Help)on the property
sheet. I added a button "Default" to the property sheet
and positioned between Cancel and Help. I set the tab
sequence as ...dynamic charting #2
I have to update a weekly spreadsheet
With week numbers in column B x series and three y series percentages
in G,H,I columns.
Could someone please help I need these to update automatically. If
someone can explain in detail I would appreciate
39 2097 2165 68 1770.7 97 96.86 118.43
40 2443.15 2201 -242.15 1548.93 97 111.00 157.73
41 2162.83 2259 96.17 1600.78 97 95.74 135.11
42 2163.08 2241 77.92 1545.1 97 96.52 140.00
43 2137.5 2271 133.5 1664.6 97 94.12 128.41
44 2160.67 2298 137.33 1455 97 94.02 148.50
...CRM Integration with MBS/Dynamics products
Anyone know anything about the integration between CRM 3.0 and ...say....
I'm thinking sharing of customer data and such....
There is nothing available yet. You would need to build it.
MVP - Microsoft CRM
"Jeppe Jespersen" <jdj curly jdj dot dk> wrote in message
Anyone know anything about the integration between CRM 3.0 and ...say....
I'm thinking sharing of customer data and such....
...Links to Attachments
Hello. I used to use Outlook 97. We had a large office
that stored documents on a shated LAN. Instead of sending
actual attachments, you had the choice of sending the
document or just a link to it. You selected this from the
same window you used to browse to your document. It did
not require you to type an URL. It was very convenient.
Is there a similar feature in Outlook 2003? It was so
useful that I hope it is still there but I just can't
Thank You, Janice Lehman
Yes, Outlook 2003 still does this.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Dynamics GP 10 and Dynamics AX 4.0
just a half year ago, our company has started to work with Dynamics AX 4.0.
Now i am doing some programming in X++ and almost customizing reports.
Accidently, i stumpled on Dynamics GP 10.0 and i am wondering what s the
difference between AX and GP? What stands GP for? Maybe GP is to replace AX,
and our company backs to wrong horse? Does GP 10 contains AX 4.0? I have
learnt lot of X++ programming, would it be possible to using X++ in the GT 10
Great Plains (GP) is another ERP system that Microsoft acquired a few years
ago when it acquired the company of the same name. GP ...Need a method to Dynamicly change the X axis Scale on a chart. #2
I dynamically change the amount of data on a chart. This causes the X axis
Scale to either to either show too few values or too many values ( a solid
black line if too many). I would like a method to dynamically change the
scale values in relation to the data span.
Do you want to limit the number of points displayed?
Or do you want to link the axis scales to something you calculate in the sheet?
----...Dynamically populate a drop down list
I'm trying to dynamically populate a drop down list in MS CRM (1.2)
based on certain parameters. I suppose I could do it using a SQL
stored procedure, but I would prefer to use standard/supported CRM
customizations. Any assistance in this would be greatly appreciated.
You can do it in 3.0 pretty easily based upon an example in the SDK... Here
are some pretty pictures...
I have not tried it with 1.2, but it could probably work...
"Dave" <firstname.lastname@example.org> wrot...Web link to Excel file
I'm trying to link to an Excel 97 file from a ColdFusion
web page. The first time I click the link, the file opens
fine in the browser (I.E. 5.5). If I close the file and
click the link again, I get a message
stating 'filename.xls is currently being modified by "my
user name here". Open as read only?'. I can still open
the file as read only, but am wondering why I get this
message, because I'm not making any modifications. I've
had other people try this link, and they get the same
thing, except it tells them that they're the one modifying
the fi...Link to a cell and text in same cell
I want B1 to equal the value in A1 and additonal normal formatted text so it
would read "BOB's Total". I've searched all thru the help and cant find a
good example to lead me into anything like this.
Anyone have any ideas?
Have a look a this: http://cjoint.com/?cxrxFU3ubq.
"::CORY::" <email@example.com> a �crit dans le message de
> My Sheet:
> A1= BOB
> I want B1 to equal the value in A1 and additonal normal formatted text so
> would re...CRecordSet is readonly in UNICODE build
When using Visual Studio.NET 2003 to compile code that uses CRecordSet to
open a table, the recordset is opened read-only in UNICODE builds. If the
project settings are set to use MBCS, the recordset is read-write. The
recordset is opened as a snapshot, however, if it is changed to dynamic, it
The above happens when creating a new C++ project or compiling old (VC 6.0)
code. It works correctly in VC 6.0.
I have the following two dynamic ranges
Note: there will be two ranges
namecount & namelist
The formula which would be using the above range is
Big question!!!, can I join these ranges together in to one statement.
if so than how ???
If I follow what you want:
Named range: List
Refers to: =OFFSET(PBR!$A$1:$B$1,,,COUNTA(PBR!$A:$A))
I want to be able to create a hierarchy of menus under the view menu. I
don't know at design time how many items will be under each submenu.
I have been able to access and add to the view menu itself. By I have not
been able to add anything under that added menu. I know it shuold be a popup
menu. but when I make it a popup, I get an assert when I try to open the
view menu. Here's what I have so far (some experimentation still remains):
m_pWndMenu = GetMenu();
//int count = m_pWndMenu->GetMenuItemCount();
//m_pWndMenu->GetMenuString(2, string, MF_BY...VISIO Gant Chart: Link 2nd page to 1st page project timelines
I am trying to create a GANT chart in VISIO that is multiple pages. The
first line on the first page is the main project "title". I need subsets of
the project to link up to the main project line. When I move to "page 2", it
starts over again, instead of linking those tasks to the original plan.
...Building the required SQL statement
I'm having difficulty writing a query and was hoping someone could help me
I have a table 'orders' which contains numerous fields, of which 3 are of
particular interest to me 'order_status', 'clientid1' and 'clientid2'. I also
have a table 'clients' which has a primary key 'client id'. What I am trying
to do is return all the data from the 'clients' table for the associated
clientid1 and clientid2 where the order_status="conf".
I get lost because of the need to get the info for clientid1 and clientid2. ...Creating a dynamic chart
I posted here a few days ago and was given some ideas on how to do this.
However, I seem lost. I have a main worksheet which is updated from several
worksheets by using code. On this worksheet is approximately 15-20 columns
something like this.
trimester year RW RW% WIW WIW% etc
1st 2001 80 89% 79 75%
2nd 2001 90 89% 84 87%
3rd 2001 87 88% 92 89%
1st 2002 88 88% 90 88%
What I would like to do is create one chart and by selecting the title of
the column from either a combo box or by using a bu...