Copy cell contents, then paste into the same cell with other text.
I tried a search first and couldn't find anything like this. My spreadsheet
has a column for shipping that takes a series like this for each product:
Following the question mark is the handling charge (0.0 in this example).
This is followed by an * and then the weight of the item (0.13.2 in this
example which is 13.2 ounces)
I have a list of product weights in a colum with just pounds and ounces. I
need to copy that information, then paste it into the weight area of the
string above and then paste those modified contents back into t...If Functin within Access query
I am new to if functins and wondered if anybody can tell me what I am doing
I am using Access 2003 and and trying to use the if function in a query
It is one query based on another, can anyone tell me what I am doing wrong
The first 2 parts of the function will...How to set include files in wince subproject 6.0
I am creating application in wince 6.0, while build the source code I
received build error.
C:\WINCE600\public\common\sdk\inc\fsdmgr.h(35) : fatal error C1083:
Cannot open include file: 'diskio.h': No such file or directory
Since i include the following path C:\WINCE600\PUBLIC\COMMON\OAK\INC
Still i got the same error. Pls any one advise me how to add the
include file in the root.
Set your include path in the following dialog
Project-->Properties-->Configuration Properties-->...Publisher documents have 'X's where images should be
Just this morning, Publisher documents have 'X's where Images are supposed
to be. The images do not appear.
I can click on the 'X', where the image is supposed to be, and the image can
be viewed, but otherwise it is not seen or printed out.
Was wondering if there is some setting that I should check or look at
changing, or what other possibilities might be causing this issue.
Thank you in advance for your help.
Brian Stevens wrote:
> Just this morning, Publisher documents have 'X's where Images are
> supposed to be. The images do not appear.
&g...How can I open files from a prev. version of Publisher in Pub 2000 #2
Is there a way to open files from an earlier version of Publisher in
Publisher 2000? I have a file that I cannot access, that I believe was
created in Publisher 97 or 98, that I need to access, but I get an error
message that says it cannot be opened.
You should be able to open it. Maybe it is a 2002 or 03 document. Do you have Norton?
Disable script blocking and in Norton Options Office Plug ins. If that doesn't work
send the files to me and I will convert them for you.
Remove "my" to reply.
Mary Sauer MS MVP
news:...CSV Files #3
I am collecting data via a webpage. Is there a way of
when the CSV file is imported into Excel (that if the user
has pressed return/enter when completing the form) that
this could be automatically deleted.
Automatically deleted from the webserver or from a local folder ?
The webserver is easy, make a script to delete it after you have
downloaded. (that could be bad if you manage to delete or change the
The local folder...delete it manually.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages direc...Office pro 2003
Office pro 2003 - Works 2004, Publisher 2003, Plus! Digital Media Ed
OFFICE SYSTEM PROFESSIONAL V2003 (c) MICROSOFT [5 CDs]
CD1=OFFICE 11 CD2=FRONTPAGE 2003 CD3=VISIO 2003 PRO
CD4=PROJECT 2003 PRO CD5=ONENOTE 2003
SN: OFFICE11: GWH28-DGCMP-P6RC4-6J4MT-3HFDY
SN: for REST: WFDWY-XQXJF-RHRYG-BG7RQ-BBDHM
Microsoft Office Publisher 2003
Microsoft Works Suite 2004 [5 cdS]
Plus! Digital Media Edition (c) Microsoft 12 337
we will help You to find any software which need Yo....accdt file reading
i would like to read the data\content of a .accdt file...
i've tried using teh oledbconnection.....with the below connection string..
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Microsoft
Office\Templates\1033\Access\Core.acctb;Persist Security Info=False;";
OleDbConnection conn = new OleDbConnection();
but it failed...
how can read .accdt file? any other alternative..please help out
...site in publisher
free pics and movies.
...Access 2007 Special Effect Text Box Won't show Sunken with Window XP
I am just getting to grips with Access 2007 and one of the quirks I
have found is that when I design using Windows in XP Windows-Classic
colors and set the text boxes on forms' special effect property to
"sunken" They appear as sunken in the correct manner.
However, when I change to the Windows XP color scheme the forms text
boxes appear flat even though the special effect property has not
Any ideas or is it a new quirk we have to live with. I haven't tried
it with Vista yet. That should be interesting
"bobdydd" <reallyuseful2004...separate file attachment from text body
One of my users running outlook 2007 replies to a recipient; upon attaching
a file, the attachment shows up in the text body. I notice this when
replying to messages vs. starting new ones. Any thoughts or help would be
much appreciated. Thank you.
Check their format. Rich Text usually does this. Plain text and HTML insert
the attachment into it's own field.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
> Hi All,
> One of my users running outlook 2007 replies to a ...publisher 2007 #29
before i buy publisher 2007 does it work with FIREFOX and other browers??
joe mahurter wrote:
> before i buy publisher 2007 does it work with FIREFOX and other
Apparently you are thinking of creating a website.
Try posting your question in the following newsgroup:
"Publisher Web Design"
John Inzer MS-MVP
Digital Media Experience
This is not ...Exporting to a unicode text file
I'm trying to export my worksheet to a unicode text file
and everytime I have a cell with a comma in it the
exported file has double quotes around the text in that
cell. Does anyone know how to disable this annoyance?
...How to use an Excel 1997 files with line chart that have date & ti
I have many old Excel 1997 files with line graphs that show up the x axis
date and time values. The old Excel 97 show about ever 10 or 20th date/time
stamp in the x axis, but the new 2003 show only black spots at the bottom of
the line graphs.
How do I get Excel 2003 to produce a line graph to show time/scale data that
has dates and times like the old Excel 97 did?
...populate Keywords with a batch file?
I'd like to know how to create a batch file that can store a key word
(including a trailing comma). I'd open an appropriate word.doc, run the
batch file, and that keyword and comma would be inserted in the Keywords
panel, either preceding any existing keywords there, or appended to any
existing keywords there.
So if I had multiple batch files, each embedded with their own unique
keyword and comma, I could invoke certain ones as desired, one after another,
progressively populating my document's keywords panel with multiple keywords
all strung together with comma d...Formatting a .txt file / fixed width
I have a text file that I need to edit. The fields in the text fil
are all fixed length (not tabbed). For example:
tzwaaaaaa lcust 000001waaaaaa lcust 7903
waaaaaa lcust 0078442040592
I would like to import a table of records like the one above in Exce
and be able to add additional rows. The paramaters being:
1) where 000001 is, I will have to increment each row by one.
2) where 0078442040592 is will be a totally different number, but wit
the same exact # of digits.
When I save this "modified" file the field lengths must be exactly th
sam...Outlook 2003 Distribution list from a file?
Please could someone tell me how I can build a Distribution List in Outlook
2003 using either a .txt a .csv or a .xls file.
I have a list of 50 email addresses that I need to build into a distribution
list, and I'm pulling my hair out trying to find a way of doing it.
You cannot import directly into a DL. If your addresses are formatted
correctly, you can use the method outlined here:
"Stu" <Stu@discussions.microsoft.com> wrote in message
news:443A0F24-0...Privet file corrupted on Exchange Server
I have an Exchange Server 5.5! Suddenly I see that its work very slow! Restarting the server ... and when server booting its show me that there are some errors on the HDD. Press F1 to continue... The problem was on the HDD on which public folder stored! First error indicates that the folder f:\exchsrvr corrupted! Restarting the server second time ... on windows booting scan disk started.. Its show that 4 bad sectors on storage HDD!
Now exchange service stopped! Trying to restore from backup! I have the same result! Services cannot start. How can I solve this problem! Help please!
Excha...Import/publish customizations programmatically (for picklist updating, e.g.)?
While you can query picklist values with CRMCustomization's
RetrievePicklist method, there is no corresponding "setter" method or
any other supported way to update those values programmatically.
Mainly, I think, this is because picklists are contained in form XSL and
thus must be published before taking effect. I can deal with that. I'm
still seeking a programmatic solution, unsupported though it may be.
The idea actually applies more generally than to just picklists:
programmatically publishing customizations. But my immediate need is to
periodically -- and aut...conditional formatting on text string
I have an Access 2003 db that has a report in it. I am trying to do a
conditional format on one of the fields so that if the text in the
text box has the string "GCA" (w/out quotes) in it, that it will fill
back color with blue, and the fore color (or the text) white. The
field is named "Club Position"
Looks like it can't be done using the "Field Value Is" condition, but
perhaps there is an "expression Is" that I can use.
Any help is much appreciated.
Conditional formatting using "Field Value Is" should work perfectly. ...how does one publish/link together a multi page site?
the text box on my first page first stated: "The Wizard has automatically set
up hyperlinks to the pages you selected. Simply fill the pages with your own
content and your site is ready to post to the World Wide Web."
when i try publishing the pages, only the first appears. the others can't be
how does one link them all? do i have to enter addresses into "the wizard"
Don't use Publisher for websites...
> the text box on my first page first stated: "The Wizard has automatically set
> up hyperlinks to the ...clicking on an MP3 file requires confirmation
Excel (2003) is offering a confirmation dialog whenever an
url pointing to an MP3 file is clicked?
Can this be (easily) disabled?
....or what is an approach to it for files on one's own hard drive.
I am linking a list of vocabulary words in one field/column with an
MP3 file name in another field/column with a formula using:
All MP3 files are local.
...recalculates formulas when opening files last saved by an earlier.
Get message: recalculates formulas when opening files last saved by an
earlier version of excel.
How do I find out what and where the formulas are?
all formulas are re-calculated :-)
"Robert" <Robert@discussions.microsoft.com> schrieb im Newsbeitrag
> Get message: recalculates formulas when opening files last saved by
> earlier version of excel.
> How do I find out what and where the formulas are?
and to find out what and where the formulas are do this...Dates posted within a standard column chart
I have a regular column chart with dates at the bottom, and the columns are
the # of cases made per week. I'm trying to include the dates the Case
specifications were changed within the chart. I only want to have a point
within the chart showing the date it was created within the dates already
showing. For example, I have the dates of 10/1, 10/6, 10/13, and 10/20 on
the X-axis. There are four columns per date. The dates of the specification
changes are 10/9, 10/14, and 10/15. I'd like points showing on those dates
with Version 1, Version 2, and Version 3 marked. Any ideas...Outlook 2003
Is there a way to force all incoming email to be received as plain text in
How about: "Tools | Options | E-Mail Options | Read all standard mail in
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Howard Cross" <no-spam@No-Spam.com> wrote in message