create a link between workbooks
I’d like to create a link between two different workbooks. please help
- open both workbooks
- in the target cell enter the equation sign '*=3D'
- now select with your mose the other workbook and the=20
- hit ENTER
>I=E2?Td like to create a link between two different=20
workbooks. please help
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?
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:
> How do I create a clickable link to a website?
> Ferret Mom
that is soooo sweet ---- love it
"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
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!
The settings to adjust for daylight savings time are in Windows as well in
Outlook Calendar options. Both need to be checked.
"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
Thank you for your suggestions.
...using mfc classes within a .net framework application.
I was wondering if anyone has ever tried using mfc classes within a .net
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
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.
On Fri, 26 May 2006 13:14:28 +0800, "fadics" <email@example.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
"Lori" <Lori@discussions.microsoft.com> wrote in message
> On our old computer we just had one user profile, but when openi...Run-time error 3077
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?
Syed Zeeshan Haider
-----------------------------------------...Create a Phone Call Manual Workflow
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?
Yup do able.
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
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:
Dim rs As DAO.Recordset
If Me.Parent.Dirty Then
Me.Parent.Dirty = False
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[RecID] = '" & Me.RecID & "'"
If Not rs.NoMatch Then
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.
> 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
...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,
=3D"The winner is "&A1
Hope this helps.
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?
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.
Select Cell b2 and use Windwow>Freeze Panes
Regards Ron de Bruin
"AA Arens" <firstname.lastname@example.org> wrote in message news:email@example.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.
> Excell 2003
Hi Ba...How to Make the "Look For:" Box Appear in Outlook 2003 All the Time?
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
Thanks in advance!
...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.
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
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...