gci and -include and -exclude
I am trying get a limited set of files from a directory tree. The following is what i want but it doesn't work. I get
get-childitem -LiteralPath \rm5_0_code_h\source -include *.frm,*.ctl,*.bas,*.cls,*.cs,*.cpp,*.hpp,*.sql,*.java -Recurse
I have even tried to exclude what i don't want but it doesn't seem to matter.
get-childitem -LiteralPath $path -include *.frm,*.ctl,*.bas,*.cls,*.cs,*.cpp,*.hpp,*.sql,*.java -recurse -exclude
i still get them all. what am i doing wrong?
you have to a...Datedif exclude weekends
Hello newsgroup gurus and users.
Your kind assistance please.
This question has probably been asked a millions times but
I cant find it.
Does any one have a solution to this.
I want the date difference between two dates but exclude
The NETWORKDAYS function will return the number of days, excluding weekend
and optionally holidays, between two dates. See help for NETWORKDAYS for
more information. This function is part of the Analysis Tool Pack add-in so
you must have that add-in loaded; otherwise, you'll get a #NAME error.
Chip Pe...Using '02 on '00 database
I've upgraded to '02 on my machine, but the office
standard is still '00. I know there are some features
that are only available on '02, such as new kinds of
graphs, that would be wothless to implement because
they'd be invisible to everyone else. But for very basic
editing of forms, reports, and code, will I be okay
making changes using '02. Will it cause problems for '00
or could it possibly have bad repercussions if there end
up being '02 changes on top of '00 changes on top of '02
changes and so on...?
You are OK if you do not use any 20...Requesting Data from Old Server Name
We recently switched servers in a company with over 300
workstations. Everyone can get the mail off of the new
server. Many outlook clients are requesting data from the
old server for some unknown reason.
They get that annoying box that pops up in the right
corner of the screen.
So why are some peoples outlooks requesting data from the
old server? how do i fix this?
...Large Quantity of Data, Graphed in Time Intervals
I have a very large set of data (over 20,000 points) listed in minute
intervals. I'd like to be able to create charts using different time
intervals such as 5 minutes, 15 minutes etc. by using a pull down menu to
select the interval and have the graph make itself. Is this possible?
You can use a pivot table to group times by such intervals.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Kirsten" <Kirsten@discussions.microsoft.com> wrote in message
Is it possible to export account information to another
user of a Money file and preserve all the reconciliation
and category information?
Use the file->export option and export as Loose QIF. The export file
contains the reconciled status and the category. You can then import this
into another Money file.
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email email@example.com espe...Can't see categories in Budget Planner/Won't load Monthly Budget report
In the last couple of days, Money stopped showing the
categories under the budget details. In the "Review your
current budget status" screen, under budget details, it
usually shows each income and expense category and how
I'm doing so far in the month. Now none of that shows.
I have made sure to check View all budget items and show
expense and income in the view menu, but this does not
help. In addition, Money will no longer load the monthly
budget report when I click "Other Tasks, view reports,
monthly budget." I have this problem no matter what
budget I...Exclude a cell
Any one know how I can sum all the cell values in a column except the value
of the last cell to be entered which could be say half-way down the column?
Is there a function to exclude a particular cell from "sum" ?
I know a lot of ppl are far more advanced than I am but we all start
Thanks for your help
To exclude cell A16:
Not very elegant, but effcient!
"DF2507" <firstname.lastname@example.org> a �crit dans le message de news:
> Excel 2002
&...passing some string using postmessage
How can I pass some string as WPARAM of PostMessage to another window
I can't use CString due to problem of local scope. I can use it by
allocating and passing address. But I don't want to do so.Is there any
other way to do this using TCHAR or BSTR.
>How can I pass some string as WPARAM of PostMessage to another window
>I can't use CString due to problem of local scope. I can use it by
>allocating and passing address. But I don't want to do so.
>Is there any other way to do this using TCHAR or BSTR.
There's no magic solution. The only...Error on new Data Base Query
I am tring to acces an excel Data base Query but the following error mesage
"UNEXPECTED ERROR FROM EXTERNAL DATABASE DRIVER (22)"
This is after i selected the File to be used, Database Type Excel Files *
I would try searching the MS Knowledge Base (www.support.microsoft.com) and/or
perhaps repairing or reinstalling Excel.
On Wed, 9 Feb 2005 10:05:05 -0800, "MESTRELLA29"
>I am tring to acces an excel Data base Query but the following error mesage
>"UNEXPECTED ERROR F...Data sort popup box
I am using the data/sort functionality in Excel 2007. Every time i click on
the Sort icon, the pop up box is bigger. If I maek as small as possible, and
reopen, it gets bigger each time. Any idea how to keep this as small as
...Data sort, > 3 columns
Excel has the Data sort option.
This allows you to sort 3 columns
Is it possible to sort more than 3 columns??
I would appreciate any advice.
This link explains how to do it:
Basically, you sort on the least important fields first, and then sort
on the more important fields.
Alternatively, you can combine some fields together in a helper
Hope this helps.
On Jun 4, 11:04=A0am, Clive_S <clives...@yahoo.co.uk> wrote:
> Excel has the Data sort option.
> Data>> S...Report question in Money 98
I am using Money 98 in Windows 2000 and preparing for taxes. I would like to
print a "terse" report of donations, printing Category and Sub-category and a
subtotal for each payee but not the individual transactions.
Can I do that?
In microsoft.public.money, Gualtier Malde wrote:
>I am using Money 98 in Windows 2000 and preparing for taxes. I would like to
>print a "terse" report of donations, printing Category and Sub-category and a
>subtotal for each payee but not the individual transactions.
>Can I do that?
Try Customizing...Assigning software using GPO
I am working in a windows 2003 enviornment
I tried to assign adobe acrobat reader which is in MSI format to a OU.
I created the GPO and then linked it to the respective OU.
When I log in from the client side the software does not get installed
eventhough it shows installing software while logging in before the
desktop comes (Client side)
Thanks in advance
sahasram's Profile: http://forums.techarena.in/members/161728.htm
View this thread: http://forums.techarena.in/ac...How to gather data from different excel workbooks into 1?
Suppose we have several different workbooks (not shared) containing the same
fields on a server location.Each user update his own workbook daily.I need
(the controler) to gather the data in another workbook and report the daily
updates for all the users in a table,but needs it to be automatic, and
showing these results in detail.I have a perfect background but don't know
how to connect the points.Please help,thank you.
Ron de Bruin has lots of code at:
Maybe you could steal some of it to merge the worksheets into one giant
worksheet and process you...Import Data from the Web to a SpreadSheet
Operating System: Mac OS X 10.6 (Snow Leopard)
I just want to import data from a regular web site onto my spreadsheet. I have downloaded iodbc and no luck there...can anyone help...i have just switched over from a pc and have been using ms excel 07...all i had to do was to click data-from the web and just enter the webaddress...please help im going crazy with this...thanks in advanced...
Excel for Mac isn't equipped with the Web Query features provided in the
Windows versions. You have to write them as Text Files. This article gives
you the 'how-to' but it ...Using command button to pull up form
I would like to have a command button pull up a form that is linked to the
main form. The main form displays milestones and I would like to command
button to pull the progress notes form with the record that is linked to the
The expression that I have tried (which I know is wrong) is:
I would like to eliminate the user's need to enter a parameter value to pull
the corresponding progress note record.
I was going to have a subform inserted on the main form but I was having a
hard time linking the in...How to handle lots of data
My problem is I have a graph with lots of data on it, so much that it
is hard to spot useful inofrmation in it. Short of simply expanding the
graph width, or making multiple graphs of different sections of data,
how else can I sort this out?
I have found a scroll bar object that one can add to charts that looks
promising but can only get it to add more data to the graph, so the
graph displays point1, if you move the scroll bar one unit the graph
displays point 1 and point 2, then point 1,2,3 and so on. how can you
st it up to show a max of say 10 points, such that when you move t...Pulling data from yyyyMMMMdd.xls
My file names are as follows yyyymmmmdd.xls - 2005August21.xls,2005August22.xls
Presently the data (E5:E33) then (H5:H49) is copied then pasted
(Value+Transposed) into '2005 Daily Production.xls' August! H25 then AL25
(Row 25 is the row which falls on August22 date line that's why the data is
pasted Transposed.) Is there a function that can pull the data based on a
entered date into the '2005 Daily Production.xls' worksheet?
...Problem Changing Data Source In Pivot Table
Hello all. I have a workbook with multiple pivot tables pulling from a
odbc datasource. The database has been moved to a new server and I a
finding that even when I update the SQL with the new location in an
one query, it tells me it cannot graphically represent the SQL an
cannot pull the table. I am unsure as to whether or not I am mis-typin
something (although not really sure how i could do that) or if i a
missing some other place i need to update the link. Also, is there
way to do it for all of the pivot tables at once? I have Excel 2000.
An example of the sql as it is (scr...HR data import
I recently upgraded from Dynamics 7.5 SQL with Human Resources to 8.0 SQL.
Apparently, a large swath of HR data did not come across in the upgrade (for
example: past review dates, applicants, attendance, time codes, pay codes
linked to positions, etc).
Our Payroll staff waited several business days to alert IT of this problem
(!!!). As such, "Restore from your backup and try again" is not an option
for me. Oh, how I wish it were...
I have restored the "just before upgrade" company and Dynamics backups to a
new location. I can examine tables and see the data in my...Can't use external POP3
Ok, i'm setting up Exchange2000 on Win2000SBS, the internal mail is all ok,
but i don't know at all how to configure external mail.
I've been looking everywhere on the net, but ther's nothing about this...
I heard of POP3 connector..., but in my exchange doesn't exist... There is
STMP connector, but not POP3 connector...
Please help me, and if can reply to my address too.
Much better to host your own mail & avoid having to use a POP connector.
For Exchange 2000, see http://www.msexchange...how do i learn the basics for useing excel 2003 #2
I am using a computer in community collage lab, it has excel 2003 installed I
would like to get a very basic idea of how to use it P. S. I have been out of
school 17 years would like some head start before entering class next spring.
A web site were I could print instructions would be nice –NOTHING ON
MICROSOFT OFFICE ONLINE IS PRINTER FRINDLEY TO WORD PROGRAM and there really
isn’t any helpful basic info on there site. I’ve tried for other products
DON’T SEND ME THERE IT SUCKS
...Back-Up Data & Delete Data
I am curious, is there a way to back up my current data and then go into RMS
Admin, so that I can delete it and start fresh? Would I be able to recover
my database once it's been deleted?
"Vince" <Vince@discussions.microsoft.com> ha scritto nel messaggio
>I am curious, is there a way to back up my current data and then go into
> Admin, so that I can delete it and start fresh? Would I be able to
> my database once it's been deleted?
You could backup your current da...Eliminate the Time from the Date for Pivot Table Use
When I import date and time of day information from another program into
Excel the new cell includes both the date and time of day. I would like to
eliminate the time portion of the cell and only show the date. Reformatting
the cell only changes the view in the cell. The time of day is still
maintained in the background. I subsequently am using pivot tables and want
all days with the same date to be viewed as the same even though the time of
day for that date may vary. When the time is carried along with the date
the pivot table thinks each cell is different because the time of day is