Hyperlinking to Many Pictures
I am using Microsoft Office 2000
I have a workbook that contains approximately 10 columns, 240 rows of
Each row has to reference an external file, which will be a hyperlink to
an external picture.
I know how to manually create the hyperlinks, but I was only wondering
if there was possibly an easier way?
I was envisioning the possibility of dragging and dropping to create the
hyperlinks, or something easy like that.
Could anyone provide assistance?
No matter how complex, I'll attempt it, and no matter how simple,
I will not be ashamed to hear it.
---...Help!! importing a text file into access with vba
I need to import (append) a daily text file into a table. The txt
file is tab delemited and I can't seem to get a schema file to import
starting at row 5.
The needed data doesn't start until line 5 in the txt file (line 5-8
Ex (parenthesis are line number for ref, not in file):
(1) Date: 20070601
(2) Total calculaions ###
(3) Failed calculations ###
(4) Successful Calculations ###
(5) BusID (data is text)
(6) BusName (data is text)
(7) Level assigned (data is text)
(8) Result (data is numeric)
The needed data in rows 5-8 is tab delimited and ...How do I make a water mark for an existing text page in publisher
When I insert a picture on my document then properties for watermark and
arange to send to background the water mark disappears. and if I try other
ways then my text on my original document dissappears.
Put your watermark on the Master Page (ctrl+m). Any picture can become a
watermark if you use the wash out feature.
"jimmyy" <firstname.lastname@example.org> wrote in message
> When I insert a picture on my document then properties for watermark and
> arange to send ...Oval Picture Frame
I am using Microsoft Publisher 2000. Is there a way I can add a Picture
Frame to a publication that is in the shape of an Oval instead of a
Use Autoshapes instead. Once you have the oval the way you want it, right-click it,
click format autoshape, expand the color dialogue, click fill effects, picture tab,
use your image as a fill. You may have to do some adjusting.
Mary Sauer MS MVP
"Wayne" <email@example.com> wrote in message
news:jpdlb.426876$Lnr1.283350@news01....protecting a text box in spreadshhet
This is defeating me I have a text box in an excel sheet, I can protect the
sheet ok but the text box always remains unprotected (ie the user could
change the text)
How do I protect it?
Un-protect the sheet
Right-click on edge of TextBox and Format TextBox>Protection
Protect the sheet.
Gord Dibben MS Excel MVP
On Fri, 22 Oct 2010 16:42:21 +0100, "SS" <firstname.lastname@example.org> wrote:
>This is defeating me I have a text box in an excel sheet, I can protect the
>sheet ok but the text box always remains unprotected (ie the user could
>ch...text to excel
I have 15 different text file which i want to import in one excel fil
at one go
can ewe do it with the help of a macro
Message posted from http://www.ExcelForum.com
You can do it with a macro, but perhaps easier is to combine the text files
in DOS and then import to Excel. To combine in DOS, have all the files in
the same folder, open a DOS prompt and type something like the following:
COPY C:\MyDocuments\TextFiles\*.txt AllFiles.txt
"vikram >" <<email@example.com> wrote in message
news:firstname.lastname@example.org...Is there a way to make a staircase text effect?
Is there a way to create a string of letters that will remain erect
when the object they are part of is rotated?
I want to create a staircase effect where the letters look like they
are sitting on the steps of a staircase and be able to alter how steep
the staircase is and have the letters remain vertical.
Email: Usenet-20031220 at spamex.com
Nothing built-in per se.
You'd have to create separate shapes that belong to a group, and do some
The shape's could then "anti-rotate" relative to the group (Angle = -
GroupSheet!Angle...Make Userform Caption equal textbox contents
How does one make a Userform title bar caption Equal the contents of Textbox1?
Can anyone help?
You can try
Private Sub TextBox1_Change()
UserForm1.Caption = TextBox1.Text
or you can use Textbox1_Exit event...
"Roger on Excel" wrote:
> How does one make a Userform title bar caption Equal the contents of Textbox1?
> Can anyone help?
Thanks Jacob - works nicely
"Jacob Skaria" wrote:
> You can try
> Private Sub TextBox1_Change()
...how to keep text with next paragraph
"Church Mouse" wrote:
What is the problem? Version?
...Help creating a recital program book/several pages w/pictures and
I am creating a recital program book. It will be a 8 1/2 x 11 book with
pictures, text and advertising and it will be in color. Over the years
others who have created this book have just simply used the "publications for
print" and other sources and the book hasn't been all that great (only the
pub for print pages were good). Since I will be working on it, I want it to
I was assuming when I began this project that there was something already
set up to help me create a multi-page book, but I am not finding it. I need
something that I can create simil...space between text strings with concatenate
I'm using the concatenate function to join two bits of text - but I want a
space between, and the function joins them together without a space. How
can I insert a space into the resulting text please? (It seems to me that
we would want such a space in ANY two text strings which we join together
with concatenate - wouldn't we?? Why doesn't it put one in by default?!)
Microsoft MVP - Excel
"Jeff" <no_em@ilplease> wrote in message news:email@example.com...
> I...Outlook converts my HTML email to text
But only occasionally, and I have to click on the message bar and
choose Display as HTML to see it as it was meant to be seen. How can I
stop Outlook from arbitrarily displaying HTML email as text?
Email goes to denajo2 at the dot com variation of the Yahoo domain.
Plonk the bastards: http://www.panix.com/~mwsm/trolls.html
Why would you want to view mail in HTML? That is dangerous. All mail should
be read and replied to in plain text for security reasons.
"Dena Jo" <firstname.lastname@example.org> wrote in message
> But only o...2003: scanning, & picking partial picture, how do I insert?
On old publisher 98, after scanning a picture, I could the outline the part I
wanted to save and just click on "insert". with publisher 2003, I can scan,
but do not find a way to insert picture on my page. Is there something I am
I'd recommend scanning your photo first and crop out the unwanted parts with
your favorite photo editing program. Then insert it in your Pub document.
Proper tool for the proper job.
MVP Microsoft [Publisher]
"Bill B" <Bill B@discussions.microsoft.com> wrote in message
news:3AD4B496-16BC-49AE-A406...Text boxes when mouse goes over the cell.
In a document i have recieved from a client, in excell, when i put my mouse
over certain color coded cells, text boxes come out with lengthy
descriptions. This sems highly usefull, and i would like to know how to do
this. Anyone know? It seems all cells with a colored corner have these
Select the cell of interest, then:
Please keep all correspondence within the Group, so all may benefit!
"Karl" <Karl@discussions.microsoft.c...Return a number in one cell to long hand text in another.
Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html
"CP" <CP@discussions.microsoft.com> wrote in message
> Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
Go to Google and search the newsgroups for "spell number"
On Wed, 20 Oct 2004 15:07:02 -0700, "CP" <CP@discussions.microsoft.com> wrote:
>Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
...Convert File text box appears
I have the capability to to open resumes that have been submitted by
potential future employees so that I can assign them to the correct
department manager. Just recently I've started having a problem in that some
of the resumes, after I launch them, I get a Convert File text window. I've
tried every option in this list but I either get an error and nothing opens
up or I get the boxes and other strange characters.
I believe that the ones that I'm having problems with most likely were
created in something other than Word, such as Works, Wordpad, Notepad, etc.
I hav...How to enter informational help text?
I have a number of column headers that I would like to define for users. Is
there a way to enter text in the background so that when someone hovers over
the column with the mouse, then will get the definition of that field? These
are customized column fields. For example- One column is Method of Delivery.
I want to enter a definition when one hovers over "method of delivery" to
state, " Way in which the data is received. ie.e internet, feed, etc.
On Feb 18, 12:03=A0pm, amcb <a...@discussions.microsoft.com> wrote:
>...=A0Is there a way to enter text in t...empty text box
I am brand new to Access (a Paradox user) and am bewildered by the Text Box
issue. I have a report in which I want to add a page footer that states the
report is confidential. When I try to go to print view, it asks me to enter
a parameter value. this is so frustrating, please help. Thanks!
That would not be the problem. It is asking for parameters for the query
that is the report's record source.
Dave Hargis, Microsoft Access MVP
> I am brand new to Access (a Paradox user) and am bewildered by the Text Box
> issue. I have a report in whi...Unbound text box calculation
Thanks in advance for the assist. My mind went numb...
What must I do to have an unbound field only perform the calculation for the
current open record that I am working in and not show data in a new records
same unbound field when I go to the next record entry?
I have an unbound text box on a form - call it Box C. In it's properties
control source I have a calculation (i.e. =text box A input / text box B
input) that I wish to show within the form prior to moving to the next
record. I then wish this field to recalculate or return null (if box A and/or
B are empty). Box C ...Is there a way to group text so it stays together?
I am editing a document, and it is a pain going through and re-editing page
breaks after making changes to it. If i could simply select a paragraph or
small section that I want to stay together and mark or group it somehow to
stay together so that if it gets pushed down from other text above, it will
stay together, either at the end of a page if it fits, or all of it would be
pushed to the next page. Is there a feature like this?
Go to the Line and Page Breaks tab of the Format Paragraph dialog and check
the box for "Keep lines together" ...convert text to formula using VLookup
I've seen somewhere that you can convert a text string into a formula using
the INDIRECT Function.
What I am constructing is a maintenance Schedule where some items need to be
serviced on a weekly basis, others monthly, quarterly, bi-annually, and
yearly. (Those are the only five rotations I require at the moment.) Once
constructed the format will take on the appearance of a calendar with
conditional formatting to highlight the dates the service falls on.
Each of the rotations require (I think) different formulas, so what I want
to do is have a list of the f...Text duplicating itself in text boxes on subform.
I've googled this one high and low, but can't find a similar hit.
Client opens employee record with Address subform embedded.
The screen shot they sent me shows the data corrupted as follows,
with an diminished copy of the text tacked onto the end. Imagine
the following, but without the spaces, which I added for clarity.
City: Madisonville adisonville disonvi
Zip: 42431 2431 431 31 1
You can view the actual screen shot here ...
Has anybody ever seen anything like this? If I told you it happens
on an Access ...How To Import Text File With No Delimiters?
I have a text file with over 2,000 names that look like the following:
Mr. Benoit Smith
120 Adam Street
Dorchester, MA 02124
1553 Blue Hill Avenue
Boston, MA 02126
American Public Health Initiatives
10 Fairway Street
Mattapan, MA 02126
Most consist of 3 lines some as many as 5. The text file has no
delimiters so that when I import/open it in Excel it becomes just one
very long column. I need to convert it or parse it into any other
database friendly importable format i.e., .dbf, .xls, .csv etc. What I
need is to convert it into a table with up to five header rows:
head1 he...Would like to have local graphic files displayed by Windows Picture Viewer instead of Internet Explorer
My spreadsheet contains a bunch of the so-called hyperlinks which,
when clicked, start an external program that takes care of the actual
displaying of the image file.
Is there any way to select the external program (file viewer)?
All the graphics files (PNG format) reside in my hard disk, not on the
Internet. This case is handled very nicely by Open Office, with the
images being handled by the Windows Picture and Fax Viewer which loads
Excel, on the other hand, prefers to use Internet Explorer, which is a
Can I tell Excel NOT to execute IE for some hyperlinks?
-Ramo...Text Missing From Ribbon Items
Four some reason today when I'm in a form's design view and multi-select
the Position tab is missing the text that were associated with it's items.
For instance the Equal Horizontal and Equal vertical, among other text is
only the icons is present.
The text was present this morning.
Any ideas on this?