Can you insert a picture into a specific cell?
Or do they only "float" on the page.
They float over the worksheet, but you can adjust the size so that it seems to
fit a cell exactly.
If you insert a picture, you can hold the alt-key down while you move/resize the
picture. When it gets close to the edge of a cell, it'll snap-to that edge.
> Or do they only "float" on the page.
...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...Can E-mail recipient policy be linked to the OU membership?
Running Exchange 2003 (mixed mode) and Windows 2003 server (Windows 2000
I'd like to create a e-mail recipient policy that is linked to the different
OU's that are created on the system.
Is it possible to link the policy to a specific OU or do I need to create
groups on the AD to control which recipients a policy applies to?
Yes, you can create a recipient policy that looks to just a specific OU. It
is done through LDAP queries. Here are some references to articles and
whitepapers that discuss how to work with recipient policies.
HO...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap....pdf save as settings
Hi, In Office 2007 Pro is there a way to change the settings such as
preventing content copying etc. when saving a file to pdf? I have been
trialling Open Office, alongside Office 2007 Pro (full version not a trial),
which allows access to these settings but I can't see a way to do it in MS
MS Office doesn't do that.
> Hi, In Office 2007 Pro is there a way to change the settings such as
> preventing content copying etc. when saving a file to pdf? I have been
> trialling Open Office, alongside Office 2007 Pro (full version not...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...can i download lxce serv.exe
want to open message lxce serv.exe using windows xp
...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Renaming Partial File Names
Is it possible to rename part of a file name? (almost like a find and
replace) My database pulls in the excel file names from a directory, with
it's subfolders and contents as well. Every file begins with "Kay Form".
Kay no longer works in our department, and I'd like to run a loop that
replaces "Kay Form" with "Featured Track". I don't know how to do a partial
Thank you in advance!
Message posted via AccessMonster.com
Checkout the Replace function. I...how many receivers i can add
i want to use outlook send 2000 thousands emails to 2000 peoples at the same
can i put them all in the recivers and send them at one time?
thank you for you help
...I would like to know how to set up a 'fill in the blanks' form?
I would like to set up a templet of sorts to fill in the blanks for
...Shortcut for inserting names?
I am building many formulas, each with many named cells as part of it.
Currently I have to go to Insert | Name | Paste with the mouse each time I
want to insert a name. I looked in Walkenbach's Excel Bible but couldn't
find any mention of a keyboard shortcut or other shortcut. Is there one I
could take advantage of?
I've got Excel 2002.
...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...With and import tool can you change only item description?
Is there a way to change only the item description on a large quanity of
items. What about the extended description? Thanks for your help.
Use the MS SQL Data Import Tool by EMS. $65.00. The QSImport Tool available
to download from Microsoft will probably work but is not supported by
Kinnard L. Kohler
Business Machines Systems
6101 South Shackleford Road
Little Rock, AR 72204-8606
> Is there a way to change only the item description on a large quanity of
>...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...sort by day of the week?
I have 10 years of grain prices...one price for each trading day of th
year. In 'A' we have the date, in 'B' the price. What I need to do i
get a list of prices for Mondays, Tuesdays, Wednesdays, etc...
Possible? (I really, really don't want to do this manually)
Message posted from http://www.ExcelForum.com
add a column = weekday(a1,1) etc and do a sort on this colum
Message posted from http://www.ExcelForum.com
Thank you. You saved me 3 or 4 hours of excruciating data entry. Thi
was the last step of a vital report. Now I can do my char...Can't configure Outlook Express
I had Outlook express set up for the Money newsgroup, but
somehow I lost it. Now I even forgot how to set it up
again. I always get the error message saying "server
cannot be found". The server name I typed in was
microsoft.public.money, and I am not sure what should I
type in here
Thanks for help
In microsoft.public.money, wj wrote:
>I had Outlook express set up for the Money newsgroup, but
>somehow I lost it. Now I even forgot how to set it up
>again. I always get the error message saying "server
>cannot be found". The server name I typed in was
&g...Symbol Updating Only Every Few Days (if at all)
Using Money 2006, and have a symbol "VLO" that is only updating every few
days. This stock was a duplicate (downloaded transaction created a new
version of the same stock - my fault not clicking correct choice when asked).
I've removed the symbol from the stock entry that was downloaded, renamed
this entry to something bogus, deleting this renamed stock "from all
accounts", then added the symbol back to the original VLO stock that I've
been tracking for years.
Now the stock just says "unch" in the portfolio view, and the price history
is only updat...Indirect Method for Name Box Variable? #2
The reason I want to do this is that I have to collect data on a dail
basis but I have to display it on a graph on a weekly basis.
I select the entire week of cells and give it a name like week52.
The following week I have to select the entire week and name i
Everything is set up that I can just copy and the numbers will progres
for whatever length of time I need to graph (months, years, etc) excep
Maybe I'll just go back to using the range of cell numbers.
Chris Bre...Macro to change default setting on startup
I am in need of a macro that can change a default setting in excel and for it
to run on startup
The task is:
uncheck Update links on save
Below is the recording of the macro:
..RelyOnCSS = True
..OrganizeInFolder = True
..UseLongFileNames = True
..DownloadComponents = False
..RelyOnVML = False
..AllowPNG = False
..ScreenSize = msoScreenSize800x600
..PixelsPerInch = 96
..Encoding = msoEncodingWestern
..SaveHiddenData = True
..LoadPictures = True
....what printers can run Vista
just purchased a dell which came with Vista on it. now my printer (HP 5550
deskjet) won't print. I need to find a new printer that i can hook up to the
This is an Access newsgroup. We help with questions related to Microsoft
Access - the database application that is part of MS Office Professional.
"monroe" <email@example.com> wrote in message
> just purchased a dell which came with Vista on it. now my printer (HP
> deskjet) won't print. I need to...Recommendations Please: Software That Can Backup Outlook While It is Open/Running
As the subject says. There are lots of packages that will backup the pst,
etc. once Outloook is closed, but some products claim to do it while Outlook
is open. Any suggestions on products that actually do this and do it
properly? If the product can safely backup over the network to a server and
can do incremental/update backups throughout the day, I'd really like to
hear about it.
...If a worksheet name is = to test then a msgbox appears
I'm looking for a macro that will display a msgbox if a worksheet is = to test.
For example, if the name of a sheet in a workbook is equal to test then
display msgbox saying sheet already exists.
dim ws as worksheet
set ws = nothing
on error resume next
set ws = worksheets("test")
on error goto 0
if ws is nothing then
msgbox "doesn't exist"
msgbox "already exists"
> I'm looking for a macro that will display a msgbox if a worksheet is = to test.
> For example, if the name of a sheet in a w...Can not open PDFs
I'm using Outlook Express,when I receive e-mail with pdf
attachments I can not open or save the PDF files I can
see that the file is there but nothing happen.
Open the message in question. Is there a informational bar across the top
that states Outlook Express blocked access to the file? If yes, select Tool
> Options > Security tab and uncheck the second box from the top concerning
"Cesar Calderon" <firstname.lastname@example.org> wrote in message
> I'm using Outlook Express,...How can I sum only amounts that are in BOLD format within a column
I need to get a total from a worksheet that has hundreds of amounts in it.
However, I only need the total of the amounts that were marked with have BOLD
font. Please help me I don't have much experience with EXCEL.
Thank you very much!
W a n d a
try this for column D
x = Cells(Rows.Count, "d").End(xlUp).Row
For Each c In Range(Cells(2, 4), Cells(x, 4))
If c.Font.Bold Then mysum = mysum + c
"Wanda" <Wanda@discussions.microsoft.com> wrote in message