SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...Tr again: Modifying Calendar's "reading" view in 2003
In Outlook 2003, Calendar allows me to show the event's content in a
"Reading" pane at the right or bottom of the calendar. But the layout of
the Reading pane wastes a lot of space. Can its layout or content be
No, the content can't be modified.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...No Form Assistant in Quote Product Screen
While entering data in the QuoteProduct screen, no Form Assistant is
Is it the usual feature or I need to configure something to view the
Also is it possible to see contact hierarchy in an account in the form
of a Organisational Chart?
Is their any add-on available in relation to this?
...Microsoft Outlook 2002 #3
How can I allow Level 1 files into Outlook 2002, I keep
getting the following message "Outlook blocked access to
the following potentially unsafe attachments"
Some options here http://www.slipstick.com/outlook/esecup/getexe.htm
"spike" <email@example.com> wrote in message
> How can I allow Level 1 files into Outlook 2002, I keep
> getting the following message "Outlook blocked access to
> the following potentially unsafe attachments"
...Custom Item Movement Report
Anyone out there have a custom item movement report and item movement
history report that includes extended description that they would be willing
That was a pretty tricky request but I was able to make the change.
Download the reports here:
If you cannot download from there shoort me an email and I will send
over. Check out our RMS add-ons website in exchange..
New West Technologies
Can you do one with "Transferred To"...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <firstname.lastname@example.org> wrote in message
> I need to create a custom format for a series ...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...can't find project or library
encounter this error : can't find project or library
when try to run a code which contains Calendar1.Value
Read the info on this page
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).
Regards Ron de Bruin
"Lynn" <email@example.com> wrot...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...Custom CRect Question
I have a custom rectangle class that inherits from CRect:
class CCustomRect : public CRect
CCustomRect(RECT* source, CPoint pt, COLORREF rgb);
void Update(RECT* r);
Inheritance has worked well until I found myself needing to create the
RectBase function (above) to return the rectangle dimensions.
CRect does not seem to have any methods that can be called to return the
base class's RECT value.
I could take CRect::Size and construct a rectangle to return, but this seems
a bit much.
My...Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office
Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders
File (.pst). I understand the basic "Office Outlook Personal Folders File
(.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002
Personal Folders File (.pst) to create a new Outlook .pst file that is
compatible with earlier versions of Outlook."
When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003,
when adding PST's you can chosse either of the two file type options and
browse to chos...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
i want to use if Command in which 19 times If Function to be used for Example
of the Function is
=IF(A2="Bongaigaon", B2*40, IF(A2="Dhemaji", B2*100, IF(A2="Dhubri", B2*50,
IF(A2="Dibrugarh", B2*65, IF(A2="Golaghat", B2*50, IF(A2="Guwahati", B2*20,
IF(A2="hojai", B2*50, IF(A2="Jorhat", B2*60, If(A2="Kharupetia", B2*50,
up to 19 times
Hi - You really need to create a table with the 19 names in one column and,
in the column to the right, the vaues associated with each name. That would
...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 18.104.22.168 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...collating information from multiple sources
Apologies if this has been asked before, but I'm a bit of a newbie when
it comes to mucking around in excel, I've had a search but I don't
really know what to call what I want to do, so finding the answer is
Anyway. I have a dozen or so workbooks that are all of the same
format, 1 work sheet with a basic list of test scenarios in each, with
a unique reference for each row.
What I'd like to do is pull information from all those workbooks into a
separate workbook by the use of the unique reference. i.e If I type
in the unique reference in the master workb...how do i rotate a 3 shift 200man schedule
like 80 people on two shifts and 40 on the third. i want to move small shift to day and slide half of day into swing and half of swing into graveyard. any suggestions? thanks in advance.
First rotation: pick the first 40 people (by alphabetic order) from the
larger groups to rotate to the next shift.
Each subsequent rotation: move the group of 40 that did not move the
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <6F26D7D8-3A2F-4663-BE17-F0EF1AD26A3D@microsoft...find match then change cell value
In column A I have cells filled with text and in column B I have cells filled
with numbers. I need to check if the number in cell C1 equals any of the
numbers in column B. If a match is found then I need to change the text in
column A to CBO.
Column A Column B Column C
aep 5 7
Since the cell C1 = 7 equals the 7 from column B, I need to change the data
in column A from xle to cbo. Is this possible...How can I reset the default pie chart label "Other" to "Equity"?
I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use
the pie chart as a template that would allow me to put new data in the table
and have the pie chart adjust automaticially. How can I reset the default
pie chart label to "Equity"? or is there another solution.
I'm about to pull my hair out. I have no problem accessing system
attributes, but the second I try to get or set a value for a custom
attribute, I get an error (null or not an object). My problem is I am
checking the changed input to a field, and if it fails a certain
criteria, I need to reset the original value. The best way I could
think to do this was to store this value in a new attribute and then
restore it if needed. Any help would be greatly appreciated.
> I'm about to pull my hair out. I have no problem accessing system
> attributes, b...Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
How do I determine what is trying to refference the deleted columns?
I found the problem, the column was still referenced in the underlying query
that fed the form.
"MeSteve"...appearance of the real name in "sent"
I posted a message yesterday but nobody answered. So I try
to do it again. I cannot find the answer to this question
in help (OL 2000). I setup my contact list, with the
names, the way I want them to appear, the email address
When I want to send an email, I click on the contact I
want, action, etc... When it is sent, it appears with the
email of the person. For example, I would like "John" to
appear, and I get (and he too) say.. firstname.lastname@example.org. It
would be more friendly, and more polite and I know it can
be done, as I receive some to my name.
email@example.com..."Organizational folder": 'new' menu is not available
I am following article:
and I try to create an organization folder. I go to my "Public FOlder",
click "System folder".
I see EFORMS listed there. I right click the option and I don't see the
What's wrong ? Exch 2000SP3.
...Repeat statements "x" number of times...
I have the following code at the end of a long macro:
ActiveCell.FormulaR1C1 = "=Sum(RC[-1]-RC[-2])"
ActiveCell.NumberFormat = "0.00"
ActiveCell.Font.Bold = True
.ColorIndex = 6
What I am doing is when the word "total" appears, it will go to the cell 4
columns to the right, and then do a formula and format the cell.
Question: How can I get this to repeat itself for eac...