Display a pix from a URL in a Excel cell
I have a CSV exported from a ecommerce web site that has the URL for the
thumbnail pix of the products. I have this in Excel. It is a full qualified
URL, i.e., http://www.something.com/images/products/image.jpg . I just want
to display the thumbnail in an excel cell, to product a printed output that
has a pic of the product so my minimum wage inventory clerks can ID the
product and do the count.
Ought to be easy, but I can't figure out how to do it.
see your other post. Excel is probably not the right tool for this :-)
P...How can I rearrange the toolbars?
I've just now installed IE8 and I've checked the help files but am unable to
find out how I can change to order of the toolbars. I am using RoboForm and
I would really like to have it as the lowest toolbar. Any help greatly
Customization in IE8:
Customize IE8...to fit your needs
Many third-party toolbars have their own, ...Is there a way I can only print the reply instead of the entire email message
I wonder if there is a way I can only print the reply to an email message,
instead of printing the entire message? My choice for selection only seem to
be gone with Outlook 2003 printing options. Any help is
...Old servers showing up in "Create an exchange mailbox" wizard.
I have a customer who removed some Exchange 5.5 servers in an usual
fashion, and as such I removed them from the ORG by using ADSIEDIT to
delete them. The problem is these mailbox servers are still showing up
as target options in the create a new mailbox selection wizard.
How can I clear these dead and gone servers from this list? The SRS
databases and ADC are long gone, and the enviornment is native mode
Also I thought at one point making a server a front-end server made it
not show up in this list. I see all their front-end servers in this
list, so I am guess my recollectio...How can I access a public calendar from a custom form
I am trying to create a custom form that would allow a
employee to request a vactation time frame. This form
would then be mailed to a supervisor who could approve or
disapprove the request. I am having difficulty getting
the response posted to a public calendar vs. the managers
private calendar. Help! -Jeff
...Can a macro open another worksheet?
I've got a macro that I need to run on about 200 spreadsheets. Is there
a way to get it to select and open all 200 spreadsheets?
Are they all in the same folder?
In fact, do you need to open all the workbooks in a folder?
Or all the workbooks in multiple known folders?
If you have files in one folder--but you want to choose (click on the first and
ctrl-click on subsequent in the file|open dialog), you can do something like:
Dim myFileNames As Variant
Dim iCtr As Long
Dim wkbk As Workbook
myFileNames = Ap...How do I use excel names with INDIRECT with charts
I want to create a Chart that does not directly reference cell-ranges (i.e.
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.
Problem: This works fine in cells but not in charts
Excel name definition:
Any idea about this?
Thanks in advance,
You have to include the sheet name in the final formula that you want XL to
www.tushar-mehta.co...Can i display an Icon on a toolbar?
I'm building a toolbar but i do not want to manualy draw the buttons.
Instead i want to
be able to display prebuilt ICONs there. Can this be done?
How do i proceed?
You should be able to do it by simply adding a CStatic on the toolbar
and placing bitmap/icon on it. Following article shows how to add
controls to the toolbar:
"Bredal Jensen" <Bredal.Jensen@mimosa.com> wrote in message news:<eMRs7FziEHA.636@TK...can someone explain what the icons mean
I have a question about the icons next to the email headings. for instance
what does the little "i" mean next to the envelope
that means it has tracking info attached.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this newsgroup by visit...Line Chart #13
The following is my data and I need to chart this. Is it possible to have a
range in one cell?
Thanks for your help in advance
Experience (Years) Large Medium Small
1 $90,000-$100,000 $75,000-90,000 $65,000-78,000
2 $92,000-100,000 $80,000-95,000 $75,000-85,000
3 $105,000-130,000 $90,000-100,000 $85,000-95,000
4 $117,000-150,000 $100,000-115,000 $90,000-110,000
5 $140,000-170,000 $115,000-130,000 $100,000+
6 $140,000-190,000 $135,000+ $100,000+
7 $170,000-250,000 $135,000+ $110,000+
...Refresh pivot chart when info in a cell changes
I am looking for help with a Macro. What I ultimately want to do is refresh
a pivot chart when the user makes a selection from a list (in a data
validation cell). For example, I am an end user that selects my territory
from a "drop down". The pivot chart will update to the information that is
directly related to my territory. Thanks in advance for your help.
Excel 2007, PivotTable
With Table dependent drop-downs
instead of data validation drop-downs.
With non-event-driven macros.
...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...Any suggestions on how to create a simple monogram?
I'm trying to create a simple monogram, and was hoping for some suggestions.
Any hints would be appreciated. Thanks.
Probably WordArt if you are using Publisher. There are lots of alphabets on the
ClipArt site. You can ungroup them and manipulate the letters into a monogram. What
initials are you using?
Mary Sauer MS MVP
"cmarnett" <email@example.com> wrote in message
news:91315A55-2E5A-4151-8D3D-54F94785A3E4@...Display value of cell
Using Excel 2000
In a cell the formula shows instead of the value/result,
how do I correct this? I want to see the formula.
Reply to firstname.lastname@example.org
Are all formulas cells show the formulas or just one?
Maybe you have a space before the = (Excel think it is text now)
Or your cell is format as text
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Kenya" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Using Excel 2000
> In a cell the formula shows instead of the value/resul...data labels in charts
This is a probably one of the simplest questions but I'm just starting to
I have entered a category title "year" in cell A1 and entered from 1995 to
2000 from A2 to A7 that I want to appear on the horizontal axis. I have
entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When
I choose a "column" chart my vertical axis appears correctly but the
horizontal axis does not include the years as labels. The labels that appear
are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick
up the data labels from colu...Creating a basic phone followup
I am very new to this CRM product. I have set up a letter campaign to a
small group of potential customers and I'd like to create a phone call
tracking list for my phone follow ups. What is the quickest/best way to
...Can I switch axes in a Worksheet?
Can I switch axes in a Worksheet? It was easier to enter
data in the current setup but now it may be easier to
analyze the data if I can switch the axes. Can it be
done?? Again, I would just like to switch the x and y
axes in the worksheet...
> Can I switch axes in a Worksheet? It was easier to enter
> data in the current setup but now it may be easier to
> analyze the data if I can switch the axes. ...
Select the data and use
Edit >> Copy
Then go to another worksheet and select a cell (like A:1).
Edit >> Paste special >> Tra...Can't activate trial version
I just bought the trial version of Publisher 2003 and I can't get it to
activate. I've uninstalled it and reinstalled it twice, double checking the
Product Key on the folder, but it keeps telling me that it's an invalid
number. And, of course, there's no "support" provided by Microsoft. This is
Any suggestions? By the way, the "activate by telephone" option isn't
available on the trial, so I can't even call them.
I'm unsure what the exact issue is.
Are you unable to complete the installation
because the program...Can't get out of selection? Assistance would be most appreciated...
Perhaps I have done something inadvertently.
I am in an Excel workbook and I appear to be in the middle of selecting
a block of cells. Everytime I move the cursor, the cell selection area
changes. I can't Esc out, or use the Enter key. Mousing over the
menu, the menu does not respond.
Rather silly really, but I desperately need to use this workbook and
nothing seems to function. Even when the cursor is moving over the
menu items, the cells selected in the workbook area still seems to be
changing. I can't use the menu - the arrow keys don't work.
Does anyone know how to &quo...Excel 2007 chart color change based on the label.
I have 12 charts 1 for each person and the data changes every week and
some of the values have 0 so are filtered out. On the chart I want
0-15 to be blue, 16-30 to be light purple, 31-60 to be a cream color,
61-90 to be light blue, and 90+ to be dark purple. With the code
below I can change the color if I take the if statement out but I
would like to change the color based on the label. I have tried
several things like .text, .name, and .label. I just can't fine the
For i = 1 To A...Combing Text with Ex. Field Name to Create A New Field Name....I Think?
I have a query that will return data from a table, and another query.
Here is my question. This is an existing fuel database. It runs on a
keylock system so there are keys numbered A1 to C10. The table returns
a sum of fuel based on a key (for example A1). I have a set of fields
from another existing query labelled DIFFA1, DIFFA2, etc. What I
would like to do is return the value for "DIFFA1" when I am returning
the information from Key A1. I would like to set up an expression
something to the effect of:
Expr1: "DIFF" & [Key]
I did this and it returns the ...Create field from append query based on linked table name
Here's the setup:
Two linked tables called 'PHD' and 'XANS' bring in daily data from two
A union table-query puts the common data in both into the same name
fields. This table-query is called 'SOLS_DATA_MERGE'. I then created a
new table called 'SOLS_MAIN' and I ran an append query called
'SOLS_DATA_APPEND' to append the data in the table-query,
'SOLS_DATA_MERGE' into the new table, 'SOLS_MAIN'. The main reason for
this was so that I could assign my data a primary key.
Even though I have achieved my goal of merging the da...can't apply Office 2008 1224 update
I regrettably was talked into reinstalling Office 2008 for the Mac
on my Intel Mac running OS 10.6.2.
Everything is fine except that I can't get Office 2008-1224
Update to apply. My HD appears with a yellow triangle over it, saying
the update is inapplicable. I've tried trashing the product ID as
Microsoft's web page suggests; no luck. No trial copies of Office
anywhere on my HD. Would appreciate any advice; thanks in advance.
- Mark Pavlick
This is identical to the problem I reported on 25 March (Installing Office 2008). In my case the prob...Boxplot and Whisker Chart
I use the chart wizard\custom chart\Line on 2 axes to
draw boxplot and whisker chart with percentage on the
left y axes and quality on the right y axes but it
doesn't show right like the others chart.
Anyone know how to draw the Line on 2 axes or Line-column
on 2 axes for Boxplot and Whisker Chart?
...Display No. of Rows in Status Bar
I'm using Excel 2003. Up until recently, whenever I apply an autofilter, my
status bar would display the number of rows returned, e.g.: "25 of 100
records found". For some reason it has stopped doing that, and now just says
I right clicked on the status bar, and chose "Count". It didn't help.
Right now I have it on "None", which is what it was on when the row count was
I don't believe I turned anything off, but I'd sure like to have that
OBTW: I had this problem a mont...