Excel 2007 VBA
I have a number of scenarios that I need to perform some calculations on.
I am trying to keep the code short by having a for - next loop running
through all the scenarios.
I am not having much luck getting that to work, though.
Shouldn't the following work?
For intLooping = 1 To 20
The following, on the other hand, does work (but doesn't do any good).
For intScenNr = 1 To 20
arrScenarios(intScenNr - 1) = Scenarios(intScenNr).Name
MsgBox Scenarios(1).Name & " - to - " &...how to create a template for decal or tatoo in text
I want to use publisher to creat an iron transfer decal but the text comes
This is usually a printer function, take a look at your print options.
"diamond" <firstname.lastname@example.org> wrote in message
>I want to use publisher to creat an iron transfer decal but the text comes
> out backwards
"diamond" <email@example.com> wrote in message
>I want to us...A bug in GUI of creating query with more outer joins between two tables
in GUI of Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6521.5000) is
generally very simple to make a select query between two tables joined with
two or more outer joins (of the same kind normally).
But you should be careful. If you build first join clicking on a field of
the first table, drag then the connection to the field of the second table
and choose the right outer join, then you have to make the next outer join
between the same two tables on the same way. If you begin but with the
second table first and although you choose the same type of outer join (the
arrow...Outlook Connector causes Outlook 2007 to not shutdown
I have had this problem with Outlook 2007 not shutting down for a long time,
but recently, through the process of elimination, I have found that it is
being caused by one of my Hotmail accounts, through the Outlook Connector.
The actual problem is that Outlook does not exit properly. If I close it,
the process can still be seen in Task Manager. When I try to shut down the
machine, I get a message saying that Outlook will not shut down, and I need
to force it to close. This means that sometimes Outlook needs to check the
message store when I start it up again.
This does not happen wh...Exhchange 2007 Outlook 2007 cached mode
Running Exchange 2007 and client is running Outlook 2007, in cached mode. My
question is cached mode faster when using Exchange 2007 and Outlook 2007 as
compared to Exchange 2003 and Outlook 2003?
Also i have a windows 2003 sharepoint server on the network, and in outlook
2007 i see that there is an option to add in sharepoint sites, but all the
options to add are grayed out in Outlook. How can i integragte sharepoint so
i can add in a sharepoint site into Outlook 2007?
thanks very much
On Tue, 20 Feb 2007 17:23:05 -0800, skip
<firstname.lastname@example.org> wrote:...easiest way to create gridlines in an Access 2003 report
Does anyone know an easy way to create gridlines in an Access 2003 report so
that it resembles a spreadsheet, other than manually drawing vertical and
You can use the Line method of the report in its Page event.
Use a loop to repeat at whatever grid size you want.
Measurements are in twips, where 1440 twips = 1 inch
This is how the Line method works:
Me.Line (Me.ScaleTop, Me.ScaleLeft)-(Me.ScaleTop, Me.ScaleHeight), vbRed
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rathe...Outlook 2007 and Windows 7 64 bit SLOW download of mail
I've read most of the posts I can find related to the slowness of Outlook
retrieving mail and I still can't resolve this.
I have a POP account at Roadrunner. My normal downloads are very fast.
Sending mail is fast. Receiving mail - I can watch the count of BYTES going
up about 30 at a time... BYTES not KB not MB. THe typical fix I see doesn't
appear to be valid in Win7 only Vista (the Autosize window or something like
that). I thought I'd take a chance and try the Beta of Outlook 2010 and
guess what? It;s still slow.
Any thoughts? This is really a dog.
I need to create a formula where I add a set number of Networkdays to a
start date. Example:
Start Date = 1/2/07
Number of Networkdays = 21
End Date = Is calculated
If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
I can only find example of Networkdays where I would be providing the
Start and End Dates, and it will calculate the Networkdays. I can't
find example where End Date is calculated based on the number of
networkdays from start date.
Can anyone help with a valid formula for this?
...Outlook 2007 collapsed folders
Its minor but annoying. For some reasons my folders (e.g. inbox,
unread, etc.) have an initial collapsed view requiring me to always
have to click the '+' sign.
If new mail comes in I cant see the header right away until I
uncollasped the folder. Did I change the default view somewhere?
email@example.com <firstname.lastname@example.org> wrote:
> Its minor but annoying. For some reasons my folders (e.g. inbox,
> unread, etc.) have an initial collapsed view requiring me to always
> have to click the '+' sign.
What tye of account?
On Thu, 9 Aug 200...SCCM 2007 Reimage issue
I am unable to reimage pc's from SCCM 2007. I am getting error message when
enter the password "failed to run task sequence".
If any one help it wolud be appreaciate.
...Converting Pub to JPeg
Have MS Small Bus. Office 2007. I quite often create marketing flyers in
Publisher to be emailed to business prospects. I recently started savings
these as JPeg's. First of all, which resolution should I use: Web (96dpi);
Standard (150 dpi) or High Quality (300 dpi)?? Next question: Then I create
an (Outlook 2007) email and insert the particular Jpeg marketing flyer in the
"body" of the email. Is this the best way to achieve my desire to send
marketing info to business prospects via email? OR, should I simply have the
marketing piece as a attachment? Any other sug...Exchange 2007 OWA Signatures
Will Exchange 2007 OWA have the option to attach a SIGNATURE? We have GIF,
JPG files for our users and we would like to have this through OWA. Thanks.
I don't see an option to attach any kind of files into your signature, at
least with the build I have.
It doesn't appear that the signature options have changed much over what is
offered in Exchange 2003.
Of course, that could change once Beta2 comes out - don't know for sure.
You can pre-register for Exchange 2007 Beta2, which I believe should be out
in a few more weeks.
http://www.microsoft.com/technet/prodtechnol/beta...Outlook 2007 signature not showing up in colour
I have setup a signature with a logo in Outlook 2007 and it will not
show with colour or a logo. Any ideas??? It works fine an other
On Tue, 5 Oct 2010 10:02:26 -0700 (PDT), samdev
>I have setup a signature with a logo in Outlook 2007 and it will not
>show with colour or a logo. Any ideas??? It works fine an other
are you sure its set to html and not text
On Oct 5, 10:27=A0pm, Ant T <nos...@nospam.com> wrote:
> On Tue, 5 Oct 2010 10:02:26 -0700 (PDT), samdev
> <la...@noblesoftwaresolutions....Excel 2007: Return rownumber when text data on 3 columns match exa
Using: Excel 2007
I want to document Windows Group Policy settings side by side on a single
sheet. To accomplish this task I want to return the row number of the current
sheet where the data of the row that has an exact match. The data I want to
lookup is in three colums.
Column B | Column C | Column D
Policy | Control Panel | Load a specific visual style
Policy | Desktop | Do not add shares
Policy | Desktop | Hide Network Location...Creating Mailbox but not an AD account
Is it possible to create just an Exchange Mailbox and not an account on AD.
We have a situation where mobile staff don't login to the domain but just
access Email using Webmail. We are using Windows Server 2003 and Exchange
Not possible that I am aware of since a mailbox is considered a property of
the AD user account.
"David Harris" <DavidHarris@discussions.microsoft.com> wrote in message
> Is it possible to create just an Exchange Mailbox and not an account on
> We have a situat...Outlook 2007 Insert Options grayed out
In the New Mail Window in Outlook 2007, the options in the "Insert" tab are
all grayed out.
How do I enable them?
"Gordon" <email@example.com> wrote in message
> In the New Mail Window in Outlook 2007, the options in the "Insert" tab
> are all grayed out.
> How do I enable them?
Please ignore - I hadn't clicked in the body of the message!
...Word 2007 macros
I used to make macros in 2003 with the suffix of .MAIN. This allowed me to
copy individual macros from one template to another, one computer to another.
If I failed to use the .MAIN, I was given only the choice of NEWMACROS to
copy. Of course, if the destination also had NEWMACROS, they'd be
Now I am trying to do the same with 2007. I created 4 macros with .MAIN
suffix and put them on the Quick Access Toolbar (with a view to putting the
same macros on three different computers). However, whichever macro I click
on, they are all the same macro. If I run...how do i convert a pub to pdf
please help in helping me convert my pub file to pdf. i am using Pub 2002.
> please help in helping me convert my pub file to pdf. i am using Pub
Download and install the following free PDF Creator.
With your new program installed...open your project
in Publisher and go to...File / Print.
On your Print screen...open the drop window and
select PrimoPDF as your printer.
Click...OK...now you will see the PrimoPDF screen
and you can ...Money 2007 not downloading statements automatically.
The update schedule is set to "Every Day" for all of my updateable
accounts, but it simply will not update unless I manually click "Update
Now...". No automatic updates.
I have money open almost continuously and it still doesn't work.
According to help, "To use automatic online updates, you must do both of the
a.. Save your bank sign-in information in Money. Otherwise, you will need
to enter an account's sign-in information every time you want to update the
account. (Some banks will automatically save your sign-in information.)
b.. Sign in t...Calendar reminders aren't operative in Outlook 2007
I am running Outlook 2007 on Windows 7 OS on a new PC. My PST file has
legacy data in it from Outlook 2003, but with historical calendar data
completely erased. Outlook 2007 has only newly entered appointments, both
one-time and recurring, starting this week. All the calendar data currently
in Outlook was entered in Outlook then sync'd to my Treo755p via Bluetooth
with perfect results, including reminders, which alert properly on the
handheld, but not at all in Outlook. I know that reminders in Outlook 2007
have been changed to be less noticable (you've got to be kiddi...How do I create charts having non absolute reference values?
Not sure what you're asking. If you want to change an axis so it doesn't
begin at zero, double click on it and enter your own scaling parameters. If
that's not it, try using TWO sentences to explain what you need.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"rvboxel" <firstname.lastname@example.org> wrote in message
...Re: Pub file to PDF (prior posts were re pdf995)
I want to thank the folks who reccommended primopdf.
I worked with pdf995 for almost 3 months & finally gave
up. Had to manually delete 14 files and 2 folders with
Windows Explorer and clean up my registry with EasyCleaner
after using Windows Control Panel 'Restore'.
I now have primopdf downloaded and installed and my
system looks clean.
The primopdf writer did NOT replace my HP writer as
pdf995 did. Maybe this one will work. I'm going to test
it out now. Thanks, again.
I really like PrimoPDF for ease of use. I use Acrobat to create my files but
have tested Primo for ot...How can save a stationery created using a Publisher design set to.
How can save a stationery created using a Publisher design set to be used as
my Outlook stationery?
What version Publisher?
Select all, right-click, click save as a picture.
In older versions, select all, copy and paste to a Paint program.
Mary Sauer MS MVP
"Mike" <Mike@discussions.microsoft.com> wrote in message
> How can save a stationery created using a Publisher design set to be used as
> my Outlook stationery?
...Pub '03 file size half in revisions
We made a 15 page booklet and the first time it was 10mb when saved. As it
was changed 2 or 3 times it gradually became a 5mb file. e added some text
and it appears to be intact but the filw size dropping in half doesn't seem
right. Is it?
If the file is opening okay and all the objects are intact, I'd think it would
be great it is a smaller file.
The question here is how are you making a 15 page booklet? Publisher works in
groups of four in booklet setup.
Mary Sauer MSFT MVP
"Sam ...Hotmail POP3 access in Outlook 2007
Since POP access has been made available to Hotmail users, I decided to
ditch Outlook Connector for downloading emailing and connect direct to my
Initially, I found that when Hotmail messages were downloaded into Outlook
the original message was removed from the server and therefore could not be
accessed by visiting hotmail.com. After adjusting the appropriate setting in
Account Options I was able to leave a copy of an email on the server, but
there is still one small gripe I'm hoping someone can help me with.
I have Windows Live Messenger running and this informs me when a ...