Reply:

create a link between workbooks
I’d like to create a link between two different workbooks. please help Hi one way: - open both workbooks - in the target cell enter the equation sign '*=3D' - now select with your mose the other workbook and the=20 source cell - hit ENTER >-----Original Message----- >I=E2?Td like to create a link between two different=20 workbooks. please help >. > Hi What kind of link? Link to cell in another workbook - several ways: 1. Enter the formula directly into cell, like ='C:\My Documents\My Excel Files\[SourceFile.xls]SourceSheet'!A1 2. Open both files. Into target s...

How to create website link (Blue Clicky)
How do I create a clickable link to a website? -- Ferret Mom Select the cell that should hold that hyperlink insert|hyperlink (in xl2003 menus) or ctrl-k in any version type in that address that you want to go to. I like this worksheet formula, too: =hyperlink("http://www.microsoft.com","Click Me!") PK wrote: > > How do I create a clickable link to a website? > -- > Ferret Mom -- Dave Peterson that is soooo sweet ---- love it -- grizz "Dave Peterson" wrote: > Select the cell that should hold that hyperl...

Summing Time #2
I wish to calculate the time the machine has actually run. D1 = 22:00 (Start Time) F1= Time Run E1 = 00:15 (Finish Time) D2 = 00:15 (Start) F2= Time Run E2 = 02:30 (Finish) D9 = 22:20 (Breakdown) E9 = 22:30 (Restart) D10 = 23:15 (Breakdown) E10 = 23:30 (Restart) D11 = 00:30 (Breakdown) E11 = 02:00 (Restart) Is there a formula that can scan a range (D9:E11) and give me tha answer in F1 of the time run between the Start & Finish times any help would be appreciated Pete Try: =SUM(E1:E2-D1:D2,-(E9:E11-D9:D11),--(E1:E2<D1:D2),-- (E9:E11<D9:D11)) Array-entered (press ctr...

Apointment time Changes
I have a group of users that when they send apointments or receive apointments they time changes by an hour.. for example they send me a 3:00PM apointment ill get it for a 4:pm apointment.. they are on the same network as i am.. same exchange server... no one else has this problem.. has anyone come across this problem?.. any help would be great! Thanks Chris The settings to adjust for daylight savings time are in Windows as well in Outlook Calendar options. Both need to be checked. -- Bharat Suneja MCSE, MCT -------------------------------- "Chris" <Chris@discussions.m...

ask for overtime with time restriction
Hi I would like to know how I could set up an overtime list to where the cell would turn red if you don't ask by a certain time. Example for saturday overtime you must be asked by end of shift thursday so if you are asked on friday it would go red and the same for sunday where you have to be asked by friday. Thanks Karl Lungmus ...

Creating 'single-view' instance of all corporate meeting room calendars
Is there a way I can create a folder or view within Exchange's public folders, where I can show the status of all our corporate conference rooms (we only have six), from a single view? Basically, I'm trying to get the same view that you can have by viewing multiple people's calendar's within Outlook 2003, but doing this for our conference rooms and in a single location that everyone can reference instead of having each user manually open each calendar for viewing it's availability. ...

How to use database table as an Outlook Contact List?
We have an existing database which we work with and maintain daily. It contains email addresses. Is there a simple way for Outlook to use it as an address book while allowing us to continue using the database normally? I found a tool that can make an Outlook Contact List available as a Database Table, but I need to make a Database Table available as an Outlook Contact List. Thank you for your suggestions. ...

using mfc classes within a .net framework application.
Hi, I was wondering if anyone has ever tried using mfc classes within a .net framework application. Here's my problem... I've been given a library written as an mfc library. Some of the functions require that I pass as parameters MFC Class objects such as CString objects. For me to create an object of say CString I'll need to load the mfc*.dll and include all the proper headers. I've tried setting "Use MFC as a shared dll" from the project property page. The compilation works fine, but as soon as I add the headers for mfc I get numerous error during compile...

Daylight Savings Time
Since the daylight saving time change. We are having trouble with users calender appointments being 1 hour off. We are using Exchange 5.5/Outlook 2000. In Outlook we had them check the box indicating adjustment for daylight saving time. After 2 days the time changed back an hour again. This seems to be only happening with our XP users only. Any ideas what is causing this. Thanks in advance. My guess is the time zone is wrong on their computer. Make sure the checkbox for "automatically adjust the clock" is set. I usually have users that like to manually change their clocks. ;...

How to use out of bound data?
I used CAsyncSocket to send out of bound data. But the data only can be received by original data method. Has any one used this class to send and receive out of bound data? That's out of BAND data. Out of bound data means you have a memory overwrite. According to the documentation, this should be received by the OnOutOfBandData handler. joe On Fri, 26 May 2006 13:14:28 +0800, "fadics" <fadics@sohu.com> wrote: >I used CAsyncSocket to send out of bound data. But the data only can be >received by original data method. Has any one used this class to send and &g...

Creating Two Email Accounts On One User Profile
On our old computer we just had one user profile, but when opening outlook we could either chose "MAIN" or "Lori"..... any thoughts on how to? That sounds like you had seperate Outlook Profiles (not windows users) You can either create a new outlook profile & use the other mail account, or set up both email accounts in the current profile - the mail wont be seperate "Lori" <Lori@discussions.microsoft.com> wrote in message news:BF58C8EB-3629-4ED9-9F84-5435CFCD5C9B@microsoft.com... > On our old computer we just had one user profile, but when openi...

Run-time error 3077
Hello Everybody, In Access 2003, I am using VBA to find a string in a table. Every time I try to execute following line: anRST.FindFirst "John Smith" I get "Run-time error '3077':" which says: Syntax error (missing operator) in expression. Same is true for FindNext, FindLast and FindPrevious. anRST was defined using following code: Set anRST = CurrentDb.OpenRecordset("Test", dbOpenDynaset) Where "Test" is the name of the table. Any ideas what I am missing? Thank you, -- Syed Zeeshan Haider -----------------------------------------...

Create a Phone Call Manual Workflow
Hi, I am having problems creating a manual workflow for phone calls. I wrote the .NET assembly and created and activated the workflow logic using the Workflow Manager. There isn't much logic anyway. No if statements. Just a call to the assembly. So after activating it I went to CRM and Clicked Activities. Then from the Type drop down list I selected Phone Call expecting to get a "More Actions" button next to the delete one but nothing happened. I am guessing it is some kind of setting that I would need to turn on, but which one is it? Any suggestions will be appreciated. T...

Migrate SBS2K3 (45 mailboxes) to SBS2K8, not using either MS or Swing, feasible?
I may have to migrate a SBS2K3 to SBS2K8 soon. I would like to create new accounts on new server rather than move the old AD to it. Is it feasible to migrate all 45 mailboxes thru PST files? I am wondering how many people have done this? Thanks jack Yup do able. "EXMERGE" I put the .PST's into each of the Users Folder Don't forget to Login as Administrator on a PC and Export the Public Folders So you can move them Also Russ -- Russell Grover - SBITS.Biz Microsoft Gold Certified Partner Microsoft Certified Small Business Specialist World Wide 24hr SBS R...

Run-time error '424'
Can anyone advise why I am getting a run-time error with this line (and what I need to do to get it working?): Me.Parent!Form.Bookmark = rst.Bookmark 'reposition the form Here is the code I am trying to run: Sub Form_Click() Dim rs As DAO.Recordset If Me.Parent.Dirty Then Me.Parent.Dirty = False End If 'Search in the clone set. Set rs = Me.RecordsetClone rs.FindFirst "[RecID] = '" & Me.RecID & "'" If Not rs.NoMatch Then Me.P...

Query Problem
I have linked to an older table to which I need to add new records. My problem is that one of the fields is named S&H (honest!), and Access won't run the query if this field is in a query column. I do not have the authorization to change the field name. How can I operate on this field? I should have said I am using Access 2002/XL and the database table in question appears to be Access 2000. "VC" wrote: > I have linked to an older table to which I need to add new records. My > problem is that one of the fields is named S&H (honest!),...

Is their a tutorial on using connectors--yellow control handles?
...

launching e-mails from Excel using Safari
Problem. Does anyone know how to launch the Macintosh mail application, Safari, using VBA? I have a spreadsheet of e-mail addresses that I'd like use to launch an e-mail with all addresses captured in the "to:" line Art ...

Is a simple macro possible for this useful idea (Excel 2000)?
Need a shortcut-key combo that does the following while Editing a character in ANY particular cell: to CHANGE THAT HIGHLIGHTED character or characters to Superscript.Thus, with only a simple shortcut-key, I'd more easily make the 'squared' or 'cubed' characters (a 2 and/or 3), RATHER THAN BE Forced to repeatedly Hunt around the formatting menus repeatedly. Please note, I unsuccessfully tried to create this by using the MacroRecorder, but that created a 'hard-wired' code that only applied to the text in a particular cell and Copied THAT SAME CELL'S content...

Can't create relationship to Order Product
I wanted to create a custom entity named Serial Number and build a relationship between it and the Order Product. But it seems I can't. Am I doing something wrong? We ship products that have serial numbers and require registration. My intention was to create a new Serial Number entity to track this information and have one related to each Order Product. This way our users couold see this information but could also search for a Serial Number find the originating order. I thought about just adding attributes for Serial Number, etc to the Order Product entity but then I don't know ho...

What is "&" used for??
What is the "&" symbol used for in a function?? It is the concatenation operator - used for joining text together, like: =3D"The winner is "&A1 Hope this helps. Pete On Feb 16, 4:50=A0pm, GEM <G...@discussions.microsoft.com> wrote: > What is the "&" symbol used for in a function?? On Feb 16, 8:50=A0am, GEM <G...@discussions.microsoft.com> wrote: > What is the "&" symbol used for in a function? String concatenation. You can get a description of operators by entering "operator" in the search field for Ex...

Freezing both horizontally and vertically
I can freeze a pane horizonally and also vertically, but not both of them. I once have seen it on an excell sheet, so it should be possible. Bart Excell 2003 Hi Bart Select Cell b2 and use Windwow>Freeze Panes -- Regards Ron de Bruin http://www.rondebruin.nl "AA Arens" <bartvandongen@gmail.com> wrote in message news:1156595839.436192.287790@i3g2000cwc.googlegroups.com... >I can freeze a pane horizonally and also vertically, but not both of > them. I once have seen it on an excell sheet, so it should be possible. > > Bart > Excell 2003 > Hi Ba...

How to Make the "Look For:" Box Appear in Outlook 2003 All the Time?
Hello: My Look For box doesn't stay open all the time. Whenever I close Outlook and log back it I have to do the Cntrl+E to get it to appear. How do I set it to stay open all the time? I'm using Outlook 2003 on WinXP Pro. Thanks in advance! Spudy ...

Help using the LARGE function "WITHOUT" using an array
Can someone show me how to accomplish the following by using the LARGE function "WITHOUT" using an array ? I'm trying to rank each product (most, second most, etc.) by weight. Data worksheet A B C 1 Product Type Pounds 2 Orange Fruit 600 3 Tomato Vegetable 500 4 Apple Fruit 700 5 Potato Vegetable 1,000 Using the LARGE function, the goal is to get the following result on another worksheet: Order worksheet A B C 1 Product 1 2 2 Fruit Apple Orange 3 Vegetable Potato Tomato On the Order workshee...

I am unable to use some of the Quick Publications
I am using XP and Publisher 2000. When I try to open some of the Quick Publications and use the wizard I can see the selected item flash on the screen then it defaults to a blank sheet and the following message appears. Publisher cannot complete the operation I have tried the detect and repair procedure several times now and still cannot get to the available publications. The following article addresses the Clip Gallery, it also has information about the Pubwiz Folder. It wouldn't hurt to replace the Pubwiz, follow the instructions in the article. PUB2000: Error Messa...