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 ...Excel 2003 extract repeating cells
I have successfully sorted my data to show repeating entries in
relation to two specific columns. I can't seem to figure out how to
select these repeating entries (without doing it manually, of course)
and putting them either into their own column(s) or an entirely
different spreadsheet altogether.
The goal is to save time in managing THOUSANDS of documents in this
manner so that my colleagues can easily pick up repeating entries and
take according action. Doing it manually is very time-inefficient.
You don't really describe enough of your layout or what you actually mean...Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files.
Is there a way to export the filenames of these .pdf files into an
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=547520
I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's
available free (a...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...excel spreadsheet
How do I delete columns from my spread sheet? When I right click the word
"delete" isn't highlighted, so it doesn't work.
Is the sheet protected or shared?
Please keep all correspondence within the Group, so all may benefit!
"Ang" <Ang@discussions.microsoft.com> wrote in message
How do I delete columns from my spread sheet? When I right click the word
"delete" is...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...Money 2006 file repair application error
I cannot delete an old account because I get a "file may be courrupt" error
so I am trying to repair my 2006 file.
Following the deirections, when the progress bar almost completes, I get an
application exception and send an error report to MS. My event log has 2
Event Type: Error
Event Source: Application Error
Event Category: None
Event ID: 1001
Time: 10:47:26 PM
Fault bucket 02266399.
For more information, see Help and Support Center at
0000: 42 75 63 6b 65 ...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Application hanging on file load...
Okay, I'm having the strangest problem, and I'm hoping somebody here
will be able to give me an idea of how to attack it... I have an MFC
application that does some networked communication, multi-threading,
fun stuff... I also load and save xml configuration files. Now, on
most of the computers I've run my software on, I have absolutely no
problems. On SOME boxes, however, whenever I use my menu to try to
load or save a file... before the File Dialog box even comes up... the
application hangs. All the boxes I've tried this on have been Windows
2000 boxes with Service Pack 4....can't open files
I have Microsoft Office 2003 ~ all of a sudden when I go to my documents
and try to open a file, I get this message "problem sending command to the
program". Error 0646 and dt000
See the article "How to re-register Word when problems crop up opening
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lost in Vegas" <Lo...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <firstname.lastname@example.org> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...AD/Network design question
I have a 2 sites which users come and go from. These sites have 2 different
network ip domains (192.168.1.x and 192.168.2.x). Users need to be
authenticated using the same user id and password at both sites. DC/GC is at
192.168.1.x and is a SBS 2003. Server at 192.168.2.x is Server 2003.
When the server at 192.168.2.x is connected via vpn to 192.168.1.x all is
How do I get the server at 192.168.2.x to act as a AD/DC when it’s not
connected to 192.168.1.x ?
I think you will run here into the limitations of SBS :-(
@ SBS experts : ...Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce
spreadsheet with a macro included in it. When I try opening
spreadsheet without a macro, everything works fine, but with macros, i
hangs on the opening command. I tried to go to Excel 2000 and go t
Tools->Macros->Security Level->Low but it still hangs when I try t
open the macro spreadsheet. All works fine with the spreadsheet no
containing macros, so it really is a question of macro security. But
put it to low, so I don't understand how it is still not opening!! An
help would be greatly appreciated!
Thanks and...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...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...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <email@example.com> wrote:
>Sorry if I sound real stupid b...Backup Excel file
I want to take backup of a file every time. I am using - save as - tools -
general option - always create back up. The backup file is in the same
location but I want to put it in a different folder. What should I do, kindly
Jan Karel Pieterse's has an addin called AutoSafe (note spelling).
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them...Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back.
I have tried doing everything in cell format etc.. anyone have an idea? it is
very annoying and adding loads of work to my project.
> Even when I open a brand new file. I input a number (ie 5)
> and get 0.05 back. I have tried doing everything in cell
> format etc.. anyone have an idea? it is very annoying and
> adding loads of work to my project.
...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...I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared
and I can no longer convert my Publisher files to pdf. I've even
uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but
still no luck.
The next step was to uninstall and reinstall Publisher and still no luck.
Any one know what may be the problem? Thanks.
How are you trying to convert your files? When happens when you try?
MVP Microsoft [Publisher]
"darrellm" <firstname.lastname@example.org> wrote in message
news:A78B7B52-981D-4FB7-8625-EAD9...Utility (pref. script) to catalog .EDB files
I have a client that is using an Enterprise backup tool which, whilst
able to back-up and restore, does not provide in-depth information
like traditional Exchange-aware backup products.
I have been asked to write a script to list the users in a flat .EDB
file (which has been snapped and copied and flushed using SAN
I have taken a look at the ESE API, which can only be accessed using C
+ (I only use VB). Other than EXMERGE, does anyone know of any tools
that allow you to list the basic mailbox details on a EDB file?
...Excel Histogram -- Incorrect Bins
I am using the Histogram tool in Excel 2004 for Mac -- I am finding that =
Excel is shifting all my data one bin to the right. =20
For example, with data...
and bin range selected as 0,5,10
I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in =
5 (between five and ten).
Excel is RETURNING a histogram with nothing in the zero bin, and 3 items =
each in the 5 bin and the 10 bin.
This is driving my bonkers! I can't find a solution...can somebody =
Eric Anderson -
> I am using the Histogram tool in Excel 2004 for Mac -- I am...List folders to file
Does anyone have a macro that would list all the folders (with path) and
subfolders to an excel sheet but not the files?
There's a function called CELL() that should return your filename (or
any of a number of parameters) but I can't get it to work properly on
my machine, so I can't make it work for you. The syntax is
=CELL("filename") which ought to return the path and filename of the
current file, and which you could then trim down to show just the path.
Can anyone provide some guidance here?
If it isn't working for you, it pro...