finding specific day in range
I am OK with some Adv Beg excel techniques. But I am not sure how to get the
next step done.
I do a monthly schedule in grid format in excel, names down the left
(A-column), and Dates across the top(row-2).
I have set up a template to auto fill the date each time I enter the new
date for the month in the cell A1
range "DAY" is C2 to AG2. This starts at C2 with "=A1" then in C3 "=(c2+1)".
This is formated to show text days of the week "ddd". In the lower rows for
each person a letter is used to indicate where they are to work for this
Some letters ar...Copy Specific Values from Table to Report
I don't know if this is the proper group to post this message into, but I'll
start here and see what happens. To try and "simply" explain my request......
I know this can be done, as I've seen the results, but I can't figure out how
to do it. I want to use the Report function of Access to create printed forms.
I would have different reports, named A, B, C, D, and E for this example. The
information I want to have printed on the report(s) comes from one specific
table. On report "A" I want to have the values printed that are in rows 2,3,
and 5 of "col...Receiving Error when logging into FRX after 9.0 Upgrade
We just upgraded from GP 7.5 to 9.0 this weekend. When trying to login to
FRX, after the Upgrade we are receving the following error:
8900: FRx is unable to open a connection to the general ledger database
because the login or password is incorrect. Verify your login and password,
and then try again.
I have checked the FRX ODBC connection and it is successful.
Any help would be appreciated.
We ran across a similar issue during out v9 upgrade. This may be related.
I discovered that some of the company names changed during the upgrade and
...Exporting resources in Visual Studio 6.0
I'm going to rebuild an Dialog based VC++ project into another. I would like
to export and import some dialog resources between the two projects. Any
idea how to do that except for cut and past in the .rc file manually.
"Anders Pettersson" <firstname.lastname@example.org> wrote in message
> I'm going to rebuild an Dialog based VC++ project into another. I would
> like to export and import some dialog resources between the two projects.
> Any idea how to do that except for cut and past in the .rc fil...Migrate AFA report to FRx
I was trying to migrating a AFA(Advanced Financial Analysis) P&L report into
FRx. A Row type was designated as Net Profit. How to achieve the same in
Thanks in Advance,
There is no automatic net profit calculation row available in FRx like AFA
you need to obtain it by formula calculation in FRx last row.
All the best.
> I was trying to migrating a AFA(Advanced Financial Analysis) P&L report into
> FRx. A Row type was designated as Net Profit. How to achieve the sa...Setting up Units & Products
Does anyone have suggestions for setting up products such
as user licenses that are monthly fees?
...Folders not set to AutoArchive default.
All the Outlook folders on my system are set to "Do not
archive items in this folder". Since I have hundreds of
folders it is a tedious process going to each folder and
changing the AutoArchive setting to "Archive items in
this folder using the default settings". Is there a way
to set all the folders to "Archive items in this folder
using the default settings" without having to do each one
Also, is there a way to set up Outlook so all new folders
are created with the AutoArchive set to "Archive items in
this folder using the default sett...IE 7 Won't Export a .csv File...
I access a website that gives me the option to export a report to a csv
file. Clicking on the link brings up a dialog box asking me to confirm
my choice of using excel - I click OK and, the box goes away and the
request just dies - excel does not launch. I have disabled pop up
blocking so that should not be an issue.
This always worked in FireFox 2 and never in in IE7. It does not work
in Firefox 3.
...FRx and pdf
It appears that FRx does not support Adobe pdf print drivers. Does
anyone have a work around (besides buyng the web product)?
mark h wrote:
> It appears that FRx does not support Adobe pdf print drivers. Does
> anyone have a work around (besides buyng the web product)?
Acrobat 5 works but you need to make Distiller your default printer
before you generate the report. Same thing happens with Winfax.
You might want to check out defprint which allows switching the default
printer from the command line.
...No IE 8 specific download for Windows 7
Had to uninstall Windows 8 to get rid of some unwanted toolbars. There is NO
specific download option for IE8 for Windows 7.
My PC did not come with a CD. Microsoft tech support can't help me. What a
Google seems to be the future, not Microsoft.
Does "Windows 8" mean "Internet Explorer 8"? There is no Windows 8.
Internet Explorer 8 is part of the Windows operating system. It can't be
removed; you can only hide its interface.
You can't re-install Internet Explorer 8 on Windows 7 because it's
What specific &qu...D.W. Export/Import
A few years ago I did an Export/Import (loose .qif) of my money file.
At the time, I compiled a little cheat sheet concearning Investment accounts
and their associated Cash accounts.
I just wanted to touch base with you and compare notes regarding this
The way I understand it is:
When exporting brokerage accounts to .QIF files, put an underscore in front
the name of the brokerage account so you can associate the corresponding
account to it.
Although I thought I once read this in your UMPMFAQ's I couldn't find i...Excel updating from XML file
I'm having a littl edifficulty getting Excel to dynamically update from an
XML file. The XML file is generated from a program and I would like the Excel
file to dynamically update.
Problem is that the location of the XML and Excel file can change, that is
they can be anywhere on a hard drive but both are in the same directory. The
mapping of the XML file in Excel appears to be a complete file path
C:/data/report/.... but the location could change. They could be in
C:/data/report/run1 or run2, I don't want to have to re-map each time a
report is generated.
Ideally I would like t...Setting up royalty payments
I need to figure out how to get an excel sheet showing calculated royalty
dues to artists (and put into a letter). I know how to mail merge, but I
have to calculate some stuff first. The excel db that our (crappy) database
exports to me is like:
ITEM# Qty QtySold Price
T0897 50 1 $25
T0897 100 1 $40
T0992 50 2 $50
T0992 100 1 $40
Then I need it to calculate for EACH product (not every qty) into a letter.
Also, for some items, the artist is paid per qtysold, other times it is per
price....Setting the default properties for cells in all new spreadsheets
How can I set the default properties of spreadsheet cells (e.g.- always
vertically centred, word wrap, Aerial 10point) so that the cells in all new
spreadsheets are created with these attributes?
The basic answer is to save the workbook as Sheet.xlt and Book.xlt (or
Sheet.xltx and Book.xltx in Excel 2007) in the XLSTART folder.
More details at
This is for Excel2000 but the ideas are the same fro all versions
Microsoft Excel MVP
"Bon Bon" <Bo...Sets of numbers
Need your help, one again.
Have a set of numbers, that meets one specific condition (acosh or other
Need to compare with other sets, and if equal, need to
extract the set which is on the following row.
Can anyone help, is there any formula(s)
Tks in adv
could you post some example data 8plain text - no attachments please)
"Antonio" <Antonio@discussions.microsoft.com> schrieb im Newsbeitrag
> Need your help, one again.
> Hav...Line break in Visio 2003 / HTML export
I have a big problem trying to get a line break into Visio 2003 shape
properties. First of all, I cannot enter one "the normal way" because it
is only ONE line to enter text, so Alt+Enter or something like that
won't work. Secondly, when I try to enter e.g. '<BR>' or '\n' it will
display them unchanged and not interpret them correctly in the HTML export.
in the data.xml file but the big question is - HOW can I insert a line
break that'll actually display in th...Retrieving/Exporting cached email address in outlook express
A client of mine is trying to export all of their contacts from outlook
express to whatever format. She can export all of her contact info, but
she also wants all of the emails that she has cached in her system that
are NOT contacts. Is there any way to do this?
Tom Machado <email@example.com> wrote:
> A client of mine is trying to export all of their contacts from
> outlook express to whatever format. She can export all of her contact
> info, but she also wants all of the emails that she has cached in her
> system that are NOT contacts. Is ther...FRx DAX Table
The company that we are handling is using FRX 6.5 (no service packs were
installed)and have a problem with its FRx Currency Translator.Everytime we
generate report the report doesn't use the historical rates that was defined
in the DAX Table.
I greatly appreciate your help on this matter.
Infosoft International Solutions Inc.
...How do I set a Publisher worksheet as wallpaper?
How do I set a Publisher worksheet as wallpaper?
It's always a good idea to include your question
in the body of your newsgroup message.
If you save your Publisher project in an image
format like .jpg or .bmp you can use it as wallpaper.
Just open the saved picture in Windows Picture
and Fax Viewer...right click it and choose..."Set as
MS Picture It! -
Digital Image MVP
Highlights and FAQs
...SVG export without SVGExtensions
Is there a way to export SVG without MS SvgExtensions?
Id like to use my visio diagrams inside a docbook document, that is
rendered to PDF. problem is: no renderer can handle the extensions...
thx in advance,
...Setting up an appointments book?
I'm wanting to set-up an appointments book for my business.
This book is to record appointments made to make a call to peoples houses. I
have several phone operators who will need access to this appointments book
(currently we have to print off 3 copies of an excel spread sheet that must
be printed out daily, the problem is we sometimes have conflicting
Is it possible to set-up a multi user envioment where I can have several
users all input data to the same appointments book (calander in outlook) and
see when other users have inputed an appointment (so as not to...Pre-set headers and footers for new worksheets
how do I have a new excel spreadsheet always open with pre-set headers and
footers? There must be a way to do this. I am tired of going into each
spreadsheet I open and re-entering my preffered set up; headers and footers,
row height, etc.
Look in Excel HELP for Template
Microsoft MVP - Excel
"robertwesley" <firstname.lastname@example.org> wrote in message
> how do I have a new excel spreadsheet always open with pre-set headers and
> footers? There must be a way to...Setting default Profile
Have only one profile. Yet, when over I open Outlook I am asked which
profile to open. I have selected Options and selected 'Always use this
profile' (or whatever it says) numerous times. How do I get Outlook to
quit asking me for a profile selection?
if you have only one profile and outlook ever ask you which profile you
wanted to use, then i think you have more than one.
So please delete the unused profile.
Maybe it could solve your problem.
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravesta...Test failed when setting up Juno webmail in Microsoft Outlook.
Following directions to use Microsoft Outlook to view my Juno webmail. Test
settings failed. No instructions on what to do next. Anybody have this
Juno mail is not supported in Outlook AFAIR - check with Juno.
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, Linda Gannon asked:
| Following directions to use Microsoft Outlook to view my Juno
| webmail. Test settings failed. No instructions on what to do next.=2...exporting a list of email addresses
I have had a request for all of the email addresses of our faculty. I have a
distribution group for faculty. However, I have not been successful in
finding a way to export the members of that group to a text file or another
other type of list.
Director of Computer Services
Northeast Texas Community College
try IMI GAL Exporter
The URL is:
We uses it without any problems more that 6 years....
"KennyG" <KennyG@discussions.microsoft.com> wrote in message