Pulling data daily from a differently named report everyday
I have a spreadsheet where I use formulas to pull data from multiple
reports on a shared server everyday. What I do is to save those
reports under a certain name everyday since the formulas have to have
the static report name in them to pull data. (For example, A1 may pull
data from c:\reportfolder\reportA, B1 may pull from c:
\reportfolder2\reportB, etc). In these report folders our IT group
runs a new report in it everyday but of course they change the name of
the report every day (to reflect the date) . . so in the reportfolder
there will be "reportA-3-12-2009", and "...Question re: Inserting Rows & Columns
I know that a row will always be inserted above the active row, but it is
visually confusing to me in which direction new columns are inserted. Are
they inserted to the right or left of the active column?
You could always put a11,b1 2,c1 3 and insert to find out for yourself
same thing on rows
Microsoft MVP Excel
"sheana" <email@example.com> wrote in message
>I know that a row will always be inserted above the active row, but it is
> ...Stupid question but......
Hello can any1 tell me how i get the little new mail
envelope icon to appear on the toolbar in the right hand
corner of the screen? I have just updated to a newer
version and it no longer does it
Thanks for any help you can give
Not a stupid quesiton Sarah. Lots of people have the problem. I hope MS
changes so their installation program checks for these problems but the
answer is usually here: http://www.howto-outlook.com/faq/missingenvelope.htm
> Hello can any1 tell me how i get the little new mail
> envelope icon to appear on the toolbar in the ri...Different margins on different pages
I am setting up a template for letters at work. The first page of our
letterhead has one ste of margins and all subsequent pages will have a
different sent of margins.
I know that section breaks can be used, but if staff copy and paste text
from existing letters into this new template, the section break moves.
Is there any way of locking the section break to the page? so the pasted
text goes over the top of it?
You could setup your document with a 'different first page' layout. That allows the first page to have a different set of margins to
the rest o...theoretical MFC question
I've been debugging like a nutcase for a couple of hours trying to
get the systemtime...
I'm using unicode, and in building in RELEASE mode....
Release mode is not a problem in VB.net and I can set a watch
on my variables and look inside them any time I want.
So here I am in release mode tyring to check for correct data
in my variables and get Nothing in them ....So I think that
the code isnt working ...
--I pull out my hair for a couple of hours and then decide
to try debug mode...Crosstab Query Column Question
I am currently in the process of trying to work with a crosstab query in MS
Access. In the rows, I have a list of names, and in the columns, I have
dates. I would like the dates to be formatted as follows:
(First column for names)
Second column: Fiscal Year 2005 (July 2004 results - June 2005 results)
Third column: Fiscal Year 2006 (July 2005 results - June 2006 results)
Fourth Column: July 2006
Fifth Column: August 2006
Sixth Column: September 2006 ((and so on...))
Is there any way to do this? I would like to import this information into a
Do believe...Different values for error bars in series
In Excel 2007, how do you put in different error bar values for each data
point in a series? So far I am only able to put in one value for all in my
See Jon's blog on the subject.
On 06/04/2010 15:52, wdwind1 wrote:
> In Excel 2007, how do you put in different error bar values for each data
> point in a series? So far I am only able to put in one value for all in my
> bar chart.
Andy Pope, Microsoft MVP - Excel
...A Different CRM for GP
We are pondering the idea of implementing MS Dynamics CRM. However, I am
curious whether anyone else has had success in integrating a different CRM
product with GP 10.0. It's not that we don't like the MS product; I just
like to ensure I have covered all bases.
Our partner does not have any other recommendations as they have not worked
with any other CRM applications.
Any information would be greatly apprecaited.
GoldMine is a good product, very mature, and easier to maintain table
structures. There are links to GP but I cannot remember the fir...Questions for help
According to documentation, for a CMyDialog : public CDialog,
CMyDialog::OnInitDialog calls CDialog::OnInitDialog, and then
CWnd::UpdateData() is called.
From which function specifically is the CWnd::UpdateData() called?
Is there any chance that I have to explicitly call UpdateData() in
My other questions are about worker thread:
Worker thread lacks a message pump. If adding something like, PeekMessage()
inside such thread, does this make worker thread become an UI thread?
Is UI thread a general term on Win32 programming, or it just related to MFC
programming? ...2 users access calendar online with different rights
user A wants to give user B permission to see, add and edit entries in
user B is able to see, but not to add or edit entries at the moment
in outlook itself its working. user B can open the folder calendar of user A
and make entries and change entries
what have to be done that this is possible also with web access exchange ?
On Thu, 26 Oct 2006 14:09:29 +0200, "Mike Schwarz" <firstname.lastname@example.org>
>user A wants to give user B permission to see, add and edit entries in
&...Same column, different cell width at different row
I have tried inserting a break and split, didn't work. I just want to
separate the top half of a page with the bottom half so I can apply different
cell width on the same column. Or how would I be able to do this? Same
column but different cell width.
You can't do that.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Glenn Chung" <GlennChung@discussions.microsoft.com> wrote in
>I have tried inserting a break and split, di...Fixed Assets
When using the Fixed Asset module, I am finding some small differences when
compared to the Depreciation calculated by the External Accountants for tax
purposes. Client would like to match exactly to the amounts calculated by
external accounts. What is the best way to fix this issue?
Need more info Patti. What are the depreciation methods/settings that
are creating the differences? Does this occur on every asset or just
MCP-GP, MCT, MVP
East Coast Dynamics
get your gptip42today at www.gp2themax.blogs...Dates Difference
I need to get the difference between 2 dates (in number of days), how
do i get that in vc++? I have used the DateDiff function in asp but
couldn't find anything like that.
Also, how can i convert string to a date?
thanks in advance
>I need to get the difference between 2 dates (in number of days), how
>do i get that in vc++?
Convert (if the dates aren't already in this format) the dates/times
to FILETIME and subtract the values.
>Also, how can i convert string to a date?
Try COleDateTime::ParseDateTime or VarDateFromStr.
MVP VC++ FAQ: http://ww...Question about Maximizing a FormView
I have a control on a CFormView with a fixed height but a variable width,
depending on the current size of the form view.
I used this in CFormView::OnSize
void CNegocioView::OnSize(UINT nType, int cx, int cy)
CFormView::OnSize(nType, cx, cy);
if( ::IsWindow(m_ctrlTitle.GetSafeHwnd()) )
m_ctrlTitle.MoveWindow(0, 0, cx, m_ctrlTitle.GetHeaderHeight());
The problem is that the control isn't sized to the full width, but it seems
it left space for the future vertical scrollbar.
To solve the problem, I used OnActivateView to resize the control initially.
It worked, bu...Want to display value and difference on one chart
I am trying to create a chart that displays x and 10-x on the same chart. I
want the chart to show a meaured value and the difference of that value to 10
in a different color.
On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
JMH <JMH@discussions.microsoft.com> said:
>I am trying to create a chart that displays x and 10-x on the same chart. I
>want the chart to show a meaured value and the difference of that value to 10
>in a different color.
Use your spreadsheet to calculate the values, then use the chart to
graph them. Never try to use a chart for calculation.
I have an index formula I am using that I want to know if there is something
I could add to have it answer $0. Here is what my spreadsheet looks like,
and the formula I am using.
> > Load# Destination-----Desc.----Charges
> > 12345 Columbus, OH----Fuel------$100
> > 12345 Columbus, OH----Stop------$50
> > 12345 Columbus, OH----Linehaul--$150
> > --H-----------I-----------J--------K----...Is this the right news group for Outlook Web Access questions?
I am trying to find a way to add search folders in Web Access for 'For
Follow up' and for 'unread' as I have int he real client.
No, an Exchange group would be better suited as OWA is a part of Exchange,
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Robin Jackson asked:
| I am trying to find a way to add search folders in Web Access for 'For
| Follow up' and for 'unread&...xmlNodeReader question
I am trying to parse through a large file in pieces using the xmlNodeReader.
I only need it to be forward only and performance is the key but I am having
a problem trying to get all the information out of my xml file.
For arguments sake my sample xml file looks like this
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<errorcol e_w_flag="e" value="10003" col="5"/>
<cd>M.A. Weatherbie & Co., Inc. - Spec Growth 2</c...Sending from 2 different computers
I have Outlook 2003 on my desktop at home and 2002 on my laptop while
traveling. My server is Comcast. I would strongly prefer to use
Outlook (rather than Comcast's webmail) on both computers.
I have configured Outlook on both computers to receive email. I can
also leave a copy on the server so it can be downloaded again later on
the other computer, assuring that I always have copies of all emails
no matter which computer I'm using.
Problem is I can't send from my laptop. I've tried Comcast's
instructions for configuring Outlook 2002 for use while traveling, but
it doesn&...Different shape width in different views in Excel 2007??
In Excel 2007, I create a shape in "Normal" view and set its width to
any value (e.g. to 15cm). Now I change to "Page Layout" view and guess
what... the width now shows up as something more than 16cm??!
(The width property as points in VBA changes accordingly.)
Switching to "Page Break View" will result in one more different width
Is this "just" a big bug in Excel 2007 or did I miss something??
I know that the selected default printer or the chosen zoom factor may
have an influence on the shown size of a shape, but these discrepancies
are ...Why doesn't this question get answered?
Where I work we have a computer that wants to install the Japanese
language pack when a specific email is opened in Outlook 2002. This is
only happening with one email, on one computer. If this same email is
sent to another person, the Japanese language pack installation prompt
does not appear when the email is opened. I have checked the Regional
and Language settings, but see nothing that indicates why Japanese is
trying to be installed. I have found several topics posted by people
with the same problem, but only one answer has been given, and the
answer did not solve the problem.
I would like to create a bar graph for say 7 days showing hotel occupancy
For each day I have this data:
A) budget room nights first 5 days at 50 rooms each night, last 2 days
75 rooms each
B) Actual room nights (and this is where it gets tricky.)
The actual room nights comes from 2 sources: the actual reserved guests
who arrived + the "walk-ins" (who didnt have a reservation)
Results for the week:
Monday 40 5...appointment prints different time
My client uses a french CRM with date format dd/mm/yyyy. when he creates an
appointment with the SFO client from e.g. 11 o'clock until 16 o'clock it is
saved like correctly. but when he prints it out, the starttime is 8 o'clock
and end time 13 o'clock.
it is like that for every appointment. it always prints out 3 hours earlier.
Anybody had this too?
You can check if both the server and the user are in the same time zone.
Open Control Panel, Date and Time, Timezone
On the laptop open Control Panel, Date and Time, Timezone
Open CRM vi...Different Columns on different pages
Hi - think this will be easily resolved but I am stuck!
In publisher 2000 how do you create a multipaged, two page
spread that has different columns on some pages.
I keep bringing myself back to "ignore background" and
trying to use "arrange" - "layout Guides" - but this isnt
Am I thinking too deep? Is the whole point that the
layout guides are simply guides and stay the same thorugh
the whole document regardless.... you just use ruler
guides to make the changes through the different pages?
What is the difference between CRM standard and professional?
> What is the difference between CRM standard and professional?
Does it have anything to do with Outlook integration?
I am Johnny!
Your Internet penpal.
I have a scooter, how about you?
"Johnny" <email@example.com> wrote in message
> Johnny wrote:
> > What is the difference between CRM standard and professional?
> > -Johnny
> Does it have anything to do with Outlook inte...