I have a UDF that takes an argument:
Function func( Optional s1 As String )
If s1 = "A" Then
func = 10
func = 20
In a workbook,
1 A =ROUND(func(A1)/10, 2)
The value in B1 is 1.00. I saved the workbook, and re-opened in automatic
calculation mode. As soon as I changed the content of A1 to B, value in B1
was changed to #NAME.
Anyone knows why?
Excel looks for functions were it expects them so it takes
a while to recognise the function in a workbook. You can
always press F9 to calculate the wo...Adding Blank Rows after the last Detail of the Report
I've used this code from Dwayne:
Private Sub Report_Page()
Dim intNumLines As Integer
Dim intLineNumber As Integer
Dim intTopMargin As Integer
Dim ctl As Control
Dim intLineHeight As Integer
intNumLines = 12
intTopMargin = Me.Section(3).Height
intLineHeight = Me.Section(0).Height
For Each ctl In Me.Section(0).Controls
For intLineNumber = 0 To intNumLines - 1
Me.Line (ctl.Left, intTopMargin + _
(intLineNumber * intLineHeight)) - _
Step(ctl.Width, intLineHeight), , B
My report needs to print blank rows (at least...Adding hyperlinks with parameters
I have a batch file which needs to be run from an excel sheet with a
parameter, like this:
But when i try to run the Hyperlink, the Excel shows an error message
saying it can't open the specified file (probably because the is a
space between the file and the parameter)
is there any known way to run the link from the excel?
On Mar 2, 12:45=A0pm, Pasha <pavel_v...@mailto.mod.gov.il> wrote:
> Hey everybody
> I have a batch file which needs to be run from an excel sheet with a
> parameter, like this:
> c:\1.bat myParameter
> But when i ...Contacts
Is there a way to create a household contact
For example, I have one common home phone number, email address, and street address for a couple in my contact list. I would like to enter individual names and birthday dates but only one anniversary date and have all dates show up on my calendar
If possible, can this idea be expanded to childrens names and birthdays fo rthe same household?
...outlook vcard, ad integration user properties
my boss is trying to get hix fax# in his vcard.
he is using his address from the global address list
I have modified his profile in active directory users and computers: I go
into AD users and computers, double click on his user, go to the telephones
tab, and enter his fax #. but when I did this his fax # is still not being
pulled up in his outlook vcard. Does anyone know where outlook is trying to
get this field from / how i can get this field into his vcard?
...rename invalid sheet name from access 97 report to Excel 2002
When I export a file from Access 97, my only choice is to
export to Excel 97. I then open that file, with excel
2002, and I get an error message the the sheet had an
invalid name and had to be renamed, but there is no
apparent difference in the the name "Sheet1" in excel 97
or "sheet1" in Excel 2002.
(I can find NO conversion sw, or find any way to "add to"
my file types list. I am forced to use Access 97 with the
office 2002 suite for now)
Any Ideas on what is causing this?
Can you open the file in xl97 to see what the sheet name is/was?
Or do ...ADDING A NUMBER
how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them
Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.
"Helpme" <Helpme@discussions.microsoft.com> wrote in message
> how do i add a number to a range of cells? I need to add 11.27 to a
> of different cells e...View to show Cases not assigned to Queues
I would like to create a View under the Case module to show which Cases
are not Assigned to any Queue. Is there a way I can accomplish that ?
There does not seem to be something in the Case record to identify if
it is linked to a Queue or not.
Suggestions are welcome
yeah i need this also. Just posting so if someone helps i'll be notified.
> I would like to create a View under the Case module to show which Cases
> are not Assigned to any Queue. Is there a way I can accomplish that ?
> There does not seem...adding new records
I am totally new to CRM, so I hope this is really easy question:
This concerns permissions.. I have a "sales" group, and with one of those
people i need to be able to let them add new records on behalf of other
"sales" people. Is there like a standard permission setting for it?
(obviously every "sales" person can add new records if they select them selfs
as the owner)
By default the person who creates the record will be the owner. After record
creation the person could reassign the record (manually) to another user.
If all rec...Position screen at end of macro
2nd attempt - sorry if it has already shown up somewhere. I've searched &
So far, at the end of a macro I've been sending the cursor across to various
columns and back to position the screen. Its a bit clumsy, and of course when
you work between different sized computer monitors it doesn't work the same.
Is there a quick way to position a particular cell at top left of screen -
and perhaps on a separate occasion a particular cell at bottom right?
...When adding attachments...
....in Outlook the following errors comes up:
"Out of memory or system resources, please close some
programs and try again"
Quotas are fine. I have deinstalled/reinstalled Office,
cleaned 'temp' areas, and many other tidbits. Any other
This might help as i had this problem with Outlook 98.
Is the file you are trying to copy to attach nested in sub folders? if so try and copy the attachment to a root drive like c:\
Ignore previous email. wrong spellin
if the attachment is nested in sub folders(this means you have to open different folders to get to ...windows xp file name convertion question
I have windows xp and office xp professonal. I have several folders
with many many files in them. Is there anyway I can import the file
names, not the files themselves into excel.
You can use code like this
Here is a macro example from Dave Peterson
Try it in a new workbook
Change the folder
myPath = "c:\data"
Dim myFiles() As String
Dim fCtr As Long
Dim myFile As String
Dim myPath As String
'change to point at the folder to check
myPath = "c:\data"
If Right(myPath, 1) <> "\" Then
myPath = myPath &am...Sorting in the leads screen
I really need to make the sorting come from a different
primary key in the dbase. Looks like in the leads screen
it comes from the primary key LeadID.
Can I change it to company name ?
Right now you cannot change this core functionality. The best thing would be
to create a custom lead view page using the SDK
Microsoft CRM MVP
"debbie" <email@example.com> wrote in message
> I really need to make the sorting come from a different
> primary key in the dbase. Looks like in the leads s...Picture Disappears When Added To Contact In Outlook 2003
Can someone help please.
When I try to attach a picture to a contact in outlook 2003 immediately
I double click the picture to be attached it disappears out of the
outlook contact along with the placement holder in the form. Only when
I right click the mouse and go remove picture do I get the placement
I have looked at all the help menus but they offer no clues.
...showing several sheet names at once
hi everybody there,
I have a workbook containing multibple worksheet said 35 sheet. I want
to see all of them at a timem so dont bother myself scrolling across
thanks in advance
You would have to create a new window for each sheet in the workbook and
then tile the windows. I'm not sure that is very practical but if you want
to see what it looks like run this macro:
Dim WS As Worksheet
For Each WS In Worksheets
End Sub...Sort by: Site ID/Item Number/Bin for Stock Count Entry Screen
Would like an additional sort selection in the Stock Count Entry Screen.
Sort by: Site ID/Item Number/Bin
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/default.mspx?mid=7e69d84a-032e-4f61...Adding ActiveX to dialog with wrapper
When I add an ActiveX object to a dialog using the dialog editor -
right click - insert activeX object, the help on the resulting activex
selection tool states that a wrapper will not be added by using this
If you need a wrapper, it suggests using the class view.
This is using Visual Studio 2005.
I'm having some problems with this on an existing project.
To make sure I understand the process, I created a new MFC project,
added a dialog, created a class for that dialog and added a Flexgrid
object using the right click method in the dialog. I then added a
variable for the flexgrid...Association an Activity to an Account AND a Contact.
Is there a way to configure CRM to associate an activitiy to both a Contact
and an Account?
Yes, except for tasks.
With the others you can use Regarding for the Account and the Contact would
be in the Recipient field.
If there is a
"JMC" <JMC@discussions.microsoft.com> wrote in message
> Is there a way to configure CRM to associate an activitiy to both a
> and an Account?
...Cases and IncidentEntryActivity ?
In the Deployment manager, I see a schema called IncidentEntryActivity,
but I cant find how this schema is related to cases (incidents) or
activities. Looking at the attributes it seems to be exactely what I
was trying to create with custom fields in Incidents.
Does anyone know, if this is a form and where it is linked to?
You will find a lot of tables in Deplyment Manager that are not present in the
app or accessible via the SDK. most of these are holdovers from features that
were de-scoped late in the dev cycle.
MVP - Microsoft CRM
--...Adding alternate columns
I work on a schedule where I record ticket count and ticket sales for
each show, listed chronologically.
Column A = week ending date
Column B = # Tickets sold for April 5 show
Column C = Ticket Revenue for April 5 show
Column D = # Tickets sold for April 9 show
Column E = Ticket Revenue for April 9 show
Column F = # Tickets sold for April 12 show
Column G = Ticket Revenue for April 12 show
Column H = Total # Tickets sold for all shows
Column I = Total Ticket Revenue for all shows
In the Totals columns, the Total Tickets formula is "+B4+D4+F4", and
the Total Revenue f...Contacts are missing when I click To, CC, or BCC buttons
My Outlook worked fine until I switched computers. My contacts are in Outlook
and when I start to type the address, my choices come up. But when I click
To, CC, or Bcc, it's blank.
"Pyrate63" <Pyrate63@discussions.microsoft.com> wrote in message
> My Outlook worked fine until I switched computers. My contacts are in
> and when I start to type the address, my choices come up. But when I
> To, CC, or Bcc, it's blank.
Version of Outlook?
How did you transfer y...Adding fields from a different query
I have a form built based on a main query. How do I add more fields on that
form that come from a different query?
A couple possibilities...
Change your first query to include the extra fields.
Use your second query to "feed" a form, then embed that form as a subform on
your main form.
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudoco...Adding more than three Conditions to 'Conditional Formatting'
Can i add more than three conditions to the conditional formatting
presets using code?
Rizitsu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15840
View this thread: http://www.excelforum.com/showthread.php?threadid=320382
Riz, as you have found out, only 3 conditions with conditional formatting.
But yes you can use some code to get more than 3, try this it will change
the cell color in column A when you put in one ,two, three, or four, right
click on the she...Contacts list, what is the best way?
I have a customer whom is running SBS 2003. They would like to setup a global
contacts list that all authenticated users can add to and modify.
This list must be available to everyone;
Using Outlook 2003 internally.
Using Outlook 2003 RPC over HTTP.
What is the best solution here?
Should I create a new global list under all users?
Should I create a contacts list in public folders?
Thanks in advance,
You'll probably need to look into this tool:
"Tony" <Tony@discussions.microsoft.com> wrote in...How do I get two sets of contacts in Outlook
I want to dump all my Act! contacts into a seperate database of contacts that is different from my current contacts in Outlook 2003. How do I do this??
Thanks in advance!
You can create a separate folder for for the new contacts, or you put them
in the main Contacts folder and use categories or some other criteria to
group or filter the Act contacts when needed.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***