How to copy a special toolbar to MS Word on another computerI created a special toolbar on my desktop with specific macros and characters
which I use often. I recently bought a new netbook and would like to install
this toolbar (using MS Word 2003 on both computers).
I thought I could just copy across Normal.dot but while Normal.dot on my
desktop shows it includes this toolbar it has disappeared in the copy on the
netbook.
I am scratching my head !!
Make a copy of normal.dot on your desktop computer, giving the file a
different name (such as mycustomtemplate.dot), and transfer it to your
netbook. Then you should be able to copy the ...
Click, Double-Click and Run Time Error 2115The following code works fine when executed as a double-click event. When I change it to
a click event I get run-time error 2115 when in BannerUpdate (last routine in the code
snippit). The text displays in the banner and I get the error.
comboQuads is a combo box which is populated through the not in list event.
What is happening, and how can I fix the problem?
Private Sub comboQuads_Click()
'Having selected a descriptor, make the link and add the text to the banner display.
Call MakeLinkRecord(rsProjects, comboQuads, rsQuadLinks, strQuadBanner)
Call BannerUpdate(txtQuadBann...
matching a column of numbers to another in another spreadsheetI have a spreadsheet of shortpayment amounts and their invoice numbers on one
spreadsheet with a column of credit amounts with their invoice numbers on
another spreadsheet. I need to match the credits written with the
shortpayments.
kinda like this
spreadsheet 1 spreadsheet 2
inv # amount date Credit #
Amount Date
122334 15.00 11-25-09 675555 15.00
12-10-09
223345 22.00 10-20-09 754444 22.00
111-25-09
naturally...
Unable to change default e-mail program to Outlook 2003HI,
Everywhere I've checked on my computer the default e-mail program is listed
as Outlook 2003.
The default e-mail in Internet Explorer is Outlook. The URL:MailTo Protocol
in Folder Options/File Types is Outlook. However when I use the "sent to,
mail recipient" feature, or Choose "e-mail this file" in File and Folder
tasks in My Computer it automatically goes to Outlook Express. Mail To
Hyperlinks use Outlook.
Operating system is XP Home SP2 - updated regularly.
Outlook Version is 2003 SP1 (part of office pro 2003)
Does anyone know what the problem may be...
a monthly running totalI have a worksheet with the months running along the top,
under each month is a value.
Currently i have a running total thats works by summin up
all the months, but this only works because i never enter
values ahead of their time eg i can only enter values up
until the month that it currently is.
If i want to be able to enter future values, i.e. for june
or july 2004 - BUT FOR THEM NOT TO AFFECT THE RUNNING
TOTAL UNTIL THAT TIME - how would i go about achieving
this?
Regards
carol
If your column headers are a valid date then you could use this idea
=IF(MON...
Relative reference to another file
Hi-
I am trying to create a formula with a relative reference to a cel
that is in another workbook. I can only find information on relativ
referencing within a workbook.
I am trying to use the ..\ concept to go up one level to find the fil
works in Excel, but keep getting formula errors.
Any input is greatly appreciated
--
annabe
-----------------------------------------------------------------------
annabel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2652
View this thread: http://www.excelforum.com/showthread.php?threadid=50661
If all workbooks in questi...
Lookup a particular cell in another excel workbookI want to be able to type in a workbook name in cell A1, example "05-03-10
Sales", and in cell B1 pull in cell A3 under the tab SALES in that workbook
automatically. That way the date can be changed randomly and it
automatically looks for that workbook. example change "05-03-10 SALES" to
"05-04-10 SALES" and cell B1 changes.
is there a way to write a formula in cell B1 that depending on the name in
cell A1 it looks up that workbook, please help!!
Thank you
The function you'd want to use is =indirect().
But =indirect() won't work if t...
Can I insert a picture depending on the contents of another cell?I have a list of data and each individual piece of data has a small logo in
the adjacent cell. Can I make Excel insert the picture in various places in
the worksheet, depending on which data is in the cell next to it? (It is
flags for each individual country and I want the flag to be inserted
automatically depending on which country is in the cell next to it).
Thanks.
Check out the below
http://www.mcgimpsey.com/excel/lookuppics.html
--
Jacob (MVP - Excel)
"JP" wrote:
> I have a list of data and each individual piece of data has a small logo in
> ...
Using data drom one cell as part of a formula in another.I am trying to use the data from one cell as part of a formula i
another.
For example:
I have a three sheet workbook.
The first sheet contains lists of data to be used in the followin
sheets.
i.e. Column 1 is List 1, Column 2 is List 2 etc
The rows contain values.
i.e. Row I contains Value 1, Row 2 contains Value 2 etc.
The following sheets, named ListData1, ListData2 etc must contain dat
from these lists laid out differently.
I can achieve this by entering the formulae to refer back to Sheet1.
e.g. For ListData1 ... =Sheet1!A1, =Sheet1!A2 etc
For ListData2 ... =Sheet1!B1, =Sheet1!B2 etc
F...
Microsoft publisher and other office programsIn publisher how do I add the file name automatically to page
...
Master Program Schedule and Critical PathHi,
We are working on large program with Master Program Schedule that has
different stream of work inserted projects. Most of the tasks/activities are
linked within their phases and have no external links. The Phases are also
not linked as most of them have different starting dates and there is no
sequencing in them.
I need to draw Network diagram and generate a Program Critical Path. When i
do so, it appears with very weird diagram that doesn't depict reality and
skip few streams of work all together.
When i choose the option, show multiple critical paths, it comes up...
Pivot TableHi,
In Excel 2007, how do I source a pivot table from another pivot table in the
same workbook? In Excel 2003 it had a function in the wizard to do this but
in 2007 it doesn't seem to.
Thanks, David.
Hi David
I think you probably mean creating another PT based upon the same source
data - which reduces file size.
It depends on the route you take to create a PT.
If you choose Insert tab>Pivot Table than it will treat the source as being
different each time.
If you choose Insert tab>Table than form Table Tools>Summarise with Pivot
Table, you can create a number of PT's al...
'Macro' cross program setupI am often input my excel data to plot powerpoint chart, by copying the raw
data from Excel into the powerpoint charts datasheet. Glad to know that Macro
is the big helper in this.....
Can I setup macro within Powerpoint for this (involve copy data from Excel
into Powerpoint)?
or there is any other better solutions?
Help,
Chan
...
Macro running slowHi,
I'm self taught so my coding is very inefficient. Up until now this
hasn't been a problem but my latest effort is taking far too long to
run. Can anyone advice on where the bottleneck is and how I can speed
it up?
Thanks
Mike
CODE BELOW (sorry for the amount)
--------------------
ActiveSheet.Unprotect Password:="XXXXXXX" ' Unprotects the
worksheet
Application.ScreenUpdating = False ' Stops the screen
refreshing while the macro is running
UserForm2.Show
' Reprotect the worksheet and end macro
Range("I4").Select
...
why is my machine running slower?Whenever I am working in a spreadsheet in Excel 2003 on my
Dell 800, it seems to be reaaaaaaaaaly slow. Any
suggestions?
Hi tommy boy!
Maybe you could find something at Charles Williams' site:
http://www.decisionmodels.com
And David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/slowresp.htm
I'd go for shutting down and re-starting followed by deleting all
files in Windows Temp plus taking a look at the xlb file and deleting
or re-naming if it is much over 50KB
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
"tommy boy...
Allow Excel to retain HTML hypertex done from another editor.When creating an html file using Microsoft Excel 2002 (10.6501.6735) SP3
to compare the first ever printed English books side by side as posted at:
http://pcministry.com/PentJona/index.htm
Then editing the HTML files manually with another text editor in order to
include hypertext for going directly to a passage:
1:1</td>
to
1:1<A NAME="1:1"></A></td>
And later trying to update the file in Excel again, after saving it, found
out that Excel removes the hypertext: 1:1<A NAME="1:1"></A>
Thus all the hypertext development I had done was lost...
How to run Visual Basic from Excel sheetHow do I run a Visual Basic routine from a normal Excel cell. I would
like to do something like this:
=IF(RunIt=TRUE, Run my Visual Basic routine, Do nothing)
So if some calculations results in the variable "RunIt" is set equal to
TRUE, the Visual Basic routine must run.
Kristian
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
...
Can't get Money 2002 to runI have been using Money 2002 for the last two years. about
a week ago I backed up my file to a floppy. Several days
ago I turned on the computer, initiated the Money Icon on
my desktop and a window come up telling me to re-install
the program to accept the end user agreement. Well, I
can't even open the program so I removed it through the
control panel add/remove programs and re-installed it.
Still I get the same message. Any Ideas
In microsoft.public.money, Mark wrote:
>I have been using Money 2002 for the last two years. about
>a week ago I backed up my file to a floppy. ...
Is there away to link something on one page to another?Hello i was wondering if anyone could help me.
Im doing a project for my NVQ4 course and before i can start i would like to
know if there is anyway that using excel you can type one thing say on sheet
1 but link it so it comes on automacially on say sheet 4?
Many thanks for all replies!
Nickle
3 methods to choose from.
1. On sheet 4 select a cell and enter an = sign.
Switch to sheet 1 and select the cell to link.
Hit ENTER key.
2. In cell on sheet 4 enter =sheet1!cellref
3. Select a cell on sheet 1 and copy then switch to sheet 4 and select
a cell then Paste Special>...
Move account from one computer to anotherHello,
How can I move my account including everything (old e-
mails, address etc.) from my old computer to my new one ?
where is the data hiding ?
Take a look here, it may help:
http://www.slipstick.com/config/backup.htm
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Amir asked:
| Hello,
|
| How can I move my account including everything (old e-
| mails, address et...
Outlook 2003 running on Windows 2003 (as client) breaks after SP1Have Exchange 2003 running on SBS2003 and has been running great for over a
year. Many users use Outlook 2003 remotely using RPC over HTTPS with no
problem. Then one user running Windows Server 2003 STD on a laptop (a client
machine) applied the new SP1 and Outlook connection over HTTPS is now
broken.
The Outlook authentication request appears again and again - it is never
satisfied. Tried running it as "outlook /rpcdiag" and don't get any
additional information that is helpful. Just simply does not authenticate.
Had Virtual PC running on the Windows 2003 machine so we tried usi...
OWA causes Office installer to run when trying to reply to a messageOWA 2003 causes the installer to look for a "missing"
feature whenever I try to reply to a message.
XP with office 2k on client
This happens because owa 2003 uses some features from office to work.. it intergrates thin into internet explorer witch why it ask for the disk... you can avoid this by doing a full install of office instead of just the default install....
When deploying Office use an administrative installation point. You will not
have to install entire office and if clients need to install something they
will be able to pull it from the installation point.
Dejan Foro...
Validate criteria in another workbookI am running excel 2003 XP. I am unable to validate criteria from on
workbook or worksheet to another. I get an error message "unable t
validate criteria from one workbook to another" At home I am able t
do this no problem. (office 97) I am able to validate criteria withi
the same worksheet only. I am trying to create drop down boxes using
common workbook. Please Help
--
Message posted from http://www.ExcelForum.com
Hi
have a look at
http://www.contextures.com/xlDataVal05.html
--
Regards
Frank Kabel
Frankfurt, Germany
"ERuane >" <<ERuane.14edt9@excelfor...
Link information in one table to another tableI have a Patient form / table for basic information. Name, Birthdate ect.
I also have another table I call Health Records. This table is for the
specifics of a Doctor visit for all patients.
I want to be able to click on a record date on the Patient form and open
another form to see or add the specifics of a particular Doctor Visit for
that patient.
What is the best way to go about this? I have tried to put a subform on the
original Patient form displaying all the visits for that patient. I end up
seeing all the visits for all the patients. Or I get the Parameter ...
How to -> Start Excel from command line and run a macroI have an Excel spreadsheet with a macro. What I want to do is to be able to
start this spreadsheet via a BAT file(mainly to schedule the running). But
the kicker is to run the Macro. I realize I may have to disable the security
to get passed the ENABLE/DISABLE prompt..or is there another way to handle
that too?
I have gotten close by getting EXCEL to load my spreadsheet but I am stuck
on the "right way" to handle the prompt and autostart the macro.
Any help will be appreciated.
--
Mickey A
Assuming that you have Microsoft Excel 2003, this might help:
Assistance > E...