Reply:

email a worksheet
Is there a way to email, just one worksheet froma workbook, don't want to send entire workbook, right now have to do alot of copy/paste into an email with just content want. Excel 2007/Outlook 2007 on Vista enterprise HTH: http://www.rondebruin.nl/mail/folder2/mail3.htm Micky "Nadine" wrote: > Is there a way to email, just one worksheet froma workbook, don't want to > send entire workbook, > right now have to do alot of copy/paste into an email with just content want. > > Excel 2007/Outlook 2007 on Vista enterprise ...

How to know when a window is created?
I want to create a CFormview derived application. I want to call GetClientRect() when the formview is created, but I can't find the message of handling this. If I call GetClientRect() in OnInitialUpdate(), I can't get the correct size I want. Thank you. zhaoyandong wrote: > I want to create a CFormview derived application. > > I want to call GetClientRect() when the formview is created, but I can't >find the message of handling this. > > If I call GetClientRect() in OnInitialUpdate(), I can't get the correct >size I want. Whenever the window ...

create multiple scatterplot from 3 columns
Hi, Is it possible to create a scatterplot with multiple series (>2) from a dataset with 3 columns: group X Y A 1,9 9,6 B 9,9 3,6 A 8,3 8,4 B 7,7 5,8 B 6,9 0,8 C 6,8 7,3 C 8,2 8 D 6,8 4,5 D 3,1 5,3 E 3,3 5,9 The firts column defines the group (each group has a different symbol), the second and third define the X and Y coordinates. My dataset contains about 400 lines and has 15 groups, which is too much work to copy the XY from each group to different columns. I'm working in Excel 2003. many thanks, Maarten You cannot use this data to make a chart. You need to separate the X and Y...

When opening outlook a file called program is created in the C:
When I open Outlook 2000 it creates a file called program in my C: directory. If I move files from my inbasket to offline then I will notice the file size increases. The file does not have an extension, although it can be opened in notepad. I have tried deleting and renaming this file but it recreates itself once Outlook is reopened. Does anyone have any idea of what this file is or how I can resolve this problem? Thanks! ...

Query for AD to get E-mails With User Accounts & Creating New user Accounts !!
Hello everybody , i'm a newbie in Exchange Server who has it as heritage from a previous Admin. so what i need is (Maybe Simple): 1- a query (to get the output to a *.txt file) for AD to get all e-mails accounts associated with each user account .. so i can know in which OU it lives & how many E-mails it has. i've this but i don't know what parameter or where should i add to get the above details .. i just get e-mails: dsquery user "OU=Clients, DC=mydomain,DC=Com" | dsget user -email > C:\emails3.txt 2- Another query (or maybe command like dsadd) but i need to...

SMTP And X400 address not created automatically after creating new mailbox
Hi,all. We just got such problem, Currently We are using Exchange 5.5 server and today when we create a new mailbox, the SMTP and X.400 address for this mailbox not created automatically, we checked the exchange service, all run well, So what problem with exchange? Thanks ahead! ...

How do i create a template
I want to create a spreadsheet that will house and print out groups of data imported from another source. I have created a template and imported one set of data which I then printed out, but am having trouble importing the next set of data I want to print out in the same format. Basically, I have report information that isn't set up in a printer-friendly format. I want to import the data into Excel and select certain of the fields to print. Since I need to print these reports daily, I want to memorize the spreadsheet so I don't need to keep recreating it. First, I don't ...

How do I create Check list
1.I am new to excel and want to create a simple check list. I would like to have the first column check boxes and then the following columns discription and notes. Can someone give me a step by step on how to do this. I have created spread sheets but am not familiar with check boxes. 2.Also, Can someone tell me the difference between Access and Excel? Geek 1) Not sure what you're aiming to do with the checkboxes, but if you right click on the toolbar area, you will get a list of available toolbars. You want either the 'forms' toolbox or the 'controls' toolbox. Genera...

Is there a template for creating math practice sheets for add, su.
I want to create a practice sheet for specific tables (like 7's, 9's), and be able to get new problems and have answers. ...

OLE Automation server cannot create object
I am using an Accounting program called Yardi Property Management and running a report that I want to send to Excel. Office 97 Pro is installed. There is an Excel icon that you can push to send it out to Excel. It works on all other computers in the office. It has just stopped working on this computer. This computer has Excel installed on it and it is working correctly in all other areas. I get the following error message when I click on the Excel icon within Yardi. In a dialog box, the messages states. OLE Automation server cannot create object. The only other time I have ...

AD not creating Exchange 5.5 mailboxes
I have Exchange 5.5 and Active Directory 2000. We have recently implemented Active Directory. When creating users, I do not get the option of creating a mailbox for that user (which was a simple thing in an NT domain). I have searched this database, gone to Microsoft, and checked out slipstick.com to try to figure this out. What I think I am seeing is that a thing called ADC has to be installed. Am I correct or is there something simple that I am missing? Any help would be very much appreciated. "Sue" <anonymous@discussions.microsoft.com> wrote: >I have Exchange 5...

How to trace dependents across worksheets?
How can I trace dependents across worksheets? Suppose I have a cell with the name Foo in Sheet2, and I reference Foo in Sheet1. When I go to Sheet2 and select Trace Dependents under Tools / Formula Auditing), Excel shows an arrow to an icon that resembles a spreadsheet. But I have not found a way to expand the icon into a cell reference or even to identify the worksheet. Moreover, if I visit each worksheet, I do not automatically see off-sheet arrows to those dependent cells. (Note: Show All is selected under Tools / Options / View. I am using Excel 2003 rev 11.6355.6360 SP1 with Win XP ...

Vlookup autofill for multiple worksheets
Can I use autofill (drag across) to increase the column count? For example: On row U, I have the following formula =IFERROR(VLOOKUP($A10,Online!$A$1:$J $153,9,FALSE),IFERROR(VLOOKUP($A10,Allocations!$A$1:$J $153,9,FALSE),IFERROR(VLOOKUP( $A10,'Corporate Exp'!$A$1:$J $154,9,FALSE),0))) and I want to increase row X by 1 and so on (I have about 24 columns) =IFERROR(VLOOKUP($A9,Online!$A$1:$J $153,10,FALSE),IFERROR(VLOOKUP($A9,Allocations!$A$1:$J $153,10,FALSE),IFERROR(VLOOKUP( $A9,'Corporate Exp'!$A$1:$J $154,10,FALSE),0))) I will also like to expand the data - expand to K23...

Create tables from xsd
I have some xsd files and I want to create tables from them. Is there a utility to do this. I have used the xsd.exe to create the classes from the xsd files and that worked. I am new to xml programming. Thank you -- Jerry Jerry C wrote: > I have some xsd files and I want to create tables from them. Is there a > utility to do this. I have used the xsd.exe to create the classes from the > xsd files and that worked. I am new to xml programming. Do you want to create data base tables? If so which data base management system do you target? Within the .NET framework class library ...

Creating xml stream
I've inherited a classic ASP webapp that employs ADODB recordsets, commands, streams and connections in a VB.NET webservice, don't ask me why it was done this way. One piece of code creates a ADODB recordset, adds one column then populates the recordset with values read from the .config file. The recordset .Save() method is called, ie: .Save(objStream, ADODB.PersistFormatEnum.adPersistXML) and the function returns whatever is returned by objStream.ReadText(), see following xml. This seems like a waste of resources, not to mention the use of unmanaged code in the webservice. Is ...

Copying Certain Worksheets depending on certain criterion
I have an excel file that contains multiple templates that I need to copy depending on certain criterion. I have set up two columns for this purpose. The first column contains the names of the worksheet to be made and the second column will be which template to copy. I have been trying to figure out a way but stuck and would appreciate it if you guys can help. The pseudo code of what I'm trying to do is as follow: Loop if cell A is not null and cell B is null copy template 1, else if cell A is not null and cell B is "Temp 1" copy template 2 else if cell A is not nul...

How do you create a boxplot on excel?
I have Microsoft Excel 2003 and it appears that it is not possible to create a boxplot. Is there some function in excel that I am just overlooking or is it not possible to create a boxplot using excel? Jon Peltier has instructions for creating Box and Whisker plots: http://www.peltiertech.com/Excel/Charts/ComboCharts.html#BoxWhisker kah489 wrote: > I have Microsoft Excel 2003 and it appears that it is not possible to create > a boxplot. Is there some function in excel that I am just overlooking or is > it not possible to create a boxplot using excel? -- Debra Dalgleish...

Mappings
Hi All, could somebody navigate me to SDK, where is explained following case: I have created my own entity, when i use contant as lookup and i need to automatically fill different field with value from Contact related field. I don't create new record in my own entity from contacts. Is there some example how to do it? Thanks a lot Radek Radek, You cannot do this via a mapping. You will need to write a callout to retrieve the values required from contact onCreate of the custom entity record. There is a callout sample in the SDK for your reference. HTH, Niths "Radek Novak&qu...

Is there a way that I can compare two different excel worksheets?
hi try this site http://www.cpearson.com/excel/duplicat.htm#InOneNotOther >-----Original Message----- > >. > ...

create .tmp files when saving
Am having a problem with several of my dell machines running window xp professional and office xp pro. when users open an excel file, make a change and save it, then go back in the file, many times it says the file can be open in read only because the file is in use. it then creates a copy of the file using the .tmp as an extension. Why is this happening so frequently. any help would be appreicated. collin Hi Collin Try this first Reboot first and then Delete all the files and subfolders in your \Windows\Temp directory (Win95/98/ME), or your \Documents and Settings\<user>\loc...

Access unable to create an MDE
I am getting this message when I try to make an MDE: "Access unable to create an MDE database" No error mesages or any other info is displayed. I haven't had this trouble before. Then I added a form, a couple reports, an create table query, modified a toolbar and added a module. Now I am getting this message. This database is a front end of a project with several linked table to a back end. Any suggestions? Thanks Jeff G Try compiling your application (under the Debug menu when you're in the VB Editor). Often an application will have some error that doesn't m...

CrmService.Create quesion
I have just started working with CRM and have put together a test routine to add a record. It failed with an "object reference not set..." and I then discovered I was not setting the ID (Key) changing this allowed the routine to complete with no errors however:- 1 / No Guid is returned by the call (it Key.Value is Empty) 2 / On looking at the entity with CRM not only is the entity I created with working code present but there are also 5 other copies, presumably from the fialed attempts? What am I missing? relavent code below:- Dim t As New new_timesheet Dim s As New...

How do I create an arithmetic test in Excel?
I tried using RAND but each time the answer is entered by the pupil the numbers will change so it will be impossible to check the results. I then tried F9. This works well but produces just one version of the test. I need an in between stage that just changes the random numbers when the worksheet is opened. Maybe you could have a macro that inserts static random numbers in your cells each time the workbook opens? You want it to change each and every time??? If you share the cell addresses and worksheet names that need it, I'm sure you'll get a more specific suggestion. Helie...

cannot create mailboxes
Server running W2K3 and E2K3 in a 2000 domain. Was able to add a new user and mailbox until just recently. Through AD, get prompted to add mailbox and everything appears good. Exchange Tasks shows Move or Delete mailbox. When user attempts to create profile cannot resolve name so Outlook client profile is not created. Messages sent to address are NDR. Mailbox does not showe in System Manager. Can add or delete mailbox in AD without error messages. App event viewer on Exchange server gives event id: 9562, source: MSExchangeIS. Perhaps a clue....Attempted to modify or "jog" e...

How do I create new identities in outlook 2007?
Can anyone help me to create new identities in Outlook 2007? Any help would be very appreciated. Sylvia :) "Toatsy" <Toatsy@discussions.microsoft.com> wrote in message news:2B69FADB-8985-406E-802C-F887E024EAE8@microsoft.com... > Can anyone help me to create new identities in Outlook 2007? Any help > would > be very appreciated. > > Sylvia :) Outlook doesn't use "identities" it uses Profiles. (They are similar except you can't switch from one Profile to another without closing Outlook first). Go to Control Panel-Mail-Show...