Converting a publisher file to adobe, with editable text
I prepare publisher files, such as postcards, to send to people in my group.
I want them to be able to insert their information when applicable. Is there
a way to do that in Publisher, or will I neet a different program?
Acrobat Pro can create fill-in documents. Word can too. Not so Publisher.
Mary Sauer MSFT MVP
"Linda" <Linda@discussions.microsoft.com> wrote in message
>I prepare publisher files, such as postcards, to send ...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
...lost data when opening excel workbooks ; text import wizard popup
When opening many of my excel files ,which all have the same modification
date, I come across the text import wizard which states that my text in these
files is 'delimited'. All of the files ,including a few word doc.s have had
their data changed to show all " y " with two dots above the letter for as
far as the eye can see. No import or export has been done with the files and
no modifications were done on that date, as far as I know.
Is this a corruption problem or is their some 'fix' that I am overlooking.
Thanks for any ideas.
...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...Wrapping text in a cell
In a single cell, suppose I want text to appear on two lines. Viz:
How do I do that so that I specify the wrap point?
If you are typing the data into the cell use Alt-Enter between each
string to indicate where you want a line break to occur.
Case One<Alt-Enter>Case Two
Alt + Enter
Lilliabeth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27741
View this thread: http://www.excelforum.com/showthread.php?threadid=476428
If you...How do I display two excel pages at the same time?
I want to have two excel pages displayed on my computer at the same
time, but when I open both pages it uses the same master excel and when
I toggle between the two it won't open both of them up. I'm using office
2003. Thanks for the help.
snowtime's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25982
View this thread: http://www.excelforum.com/showthread.php?threadid=393499
Open both and then do windows>arrange and vertical (or any of the other
choices, I usuall...Is it possible to highlight text?
I'd like to highlight just some of the text in a cell - not the entire
Select the cell and in the edit bar you can then select (highlight)
some of the text with the mouse and format how you wish, eg bold,
different colour, different background colour, different font/font size
Hope this helps.
This will NOT work in a formula. Works only if all text.
"Pete_UK" <email@example.com> wrote in message
> Select the cell ...Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a
pivot table thus displaying a charted image of the detail item selected. Any
...How do I get excel files to open automatically from directories?
When I try to open excel files from the directory or from desktop I only get
a blank worksheet not the file. I have to then go through File Open to get
the file I want.
There must be a way to have them open automatically.
On Mon, 2 Jan 2006 21:22:01 -0800, Damian
>When I try to open excel files from the directory or from desktop I only get
>a blank worksheet not the file. I have to then go through File Open to get
>the file I want.
>There must be a way to have them open automatically.
Go to Tools -> Options -> Gen...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Time Zone / Incorrect Dates Displayed to User
When a user in the Central Time zone closes an opportunity and someone in the
Mountain Time zone views it, the Actual Close Date is 1 day before the date
the person in the Central Time zone selected.
If someone in the Central Time zone closes an opportunity and selects the
Actual Close Date as 6/2/2007:
-- Users in the Central Time zone see: 6/2/2007
-- But users in the Mountain Time zone see: 6/1/2007
This is a big issue when running monthly reports as it makes some
opportunities show in the wrong month... and will put that revenue in the
It would make mo...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any...Outlook 2002 multiple file opening
In Outlook 2000, CTRL A would select all attached picture
files, then Open would, in my case, open the files in
With the 2002 version I cannot find a way to do this.
..."File: send to mail recipient" not working
When users (on WinXP) select file, "send to mail
recipient", no response from Outlook 2002. This occurs
either when Outlook is open or closed. Problem happens
when rt. clicking on .doc, .xls, .pdf's....all files.
...Create incident on website : localhost ok
when i open a new case in
it creates the "incident" normally
but when i open a new case in
Operation failed due to a SQL integrity violation.
System.Web.Services.Protocols.SoapException: Server was unable to process
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response,
Stream responseStream, Boolean asyncCall)
at System.W...Creating a Check Box
I would like to learn how to create a check box. Is there
a way to do that?
The simplest checkbox (I think) is from the Forms toolbar.
So View|tool bars and show that Forms toolbar.
Click on the checkbox and then click on the topleft corner where it should be
placed. Then draw to the opposite lowerright corner.
When you've placed it correctly, right click on it and select "Format Control"
On the Control Tab, you can assign a cell link that you can use to determine if
the checkbox is checked or not.
=if(A1=True,"It's checked","It's not checked")
...Cannot get my CImageList to display images?
Ok i am successfully diplaying images in my tree controls but not my list
I am using the following but not image is being displayed???
int nIndex = mListCtrl.InsertItem(LVIF_IMAGE | LVIF_TEXT,0,"hello", 0,0,7,0L);
Where 7 is a valid index into my image list!
That really doesn't help much. Since you got the tree control working I'm
assuming that you are calling the list control's SetImageIist. Also for
debugging purposes call GetImageCount on your image list to see how many
images it loaded.
Let me also point out that you can call this ...owa logout show the page cannot be display
The event 36 was triggered when Outlook Web Access (2003) users clicked the
"Log Off" shortcut. The OWA user would receive the following message when
logging off: "The page cannot be displayed.
I try to search on google, some of newsgroup report follow microsoft article
Q318239 can fix the issue. but this article can not found on
support.microsoft.com. anyone have experience about event 36 OWA logout
issue. Please help
...Sheet display vrs. Print Preview
Why would a sheet display differently than when it is printed. I have an
excel file that looks like it prints on my bosses computer but on my pc the
page breaks are different the word warps are different. This makes it
difficult to work with because it will not print the same on my pc and his.
We are both using Excel 2003. Thanks for helping.
This could have a great deal to do with the printer drivers. Are you
printing to the same printer?
"Byron" <Byron@discussions.microsoft.com> wrote in mes...is there a way of using a second monitor as a customer display
This is a multi-part message in MIME format.
Does anyone know if rms works with 2 monitors. What I mean can you use a
second monitor as customer display or something similar.
A lot of pos systems out there use a second monitor as customer display,
I m not sure if rms supports that option or not but any help would be
Content-Transfer-...Creating Charts for Use in Powerpoint
I have a series of charts that I need to create for a Powerpoin
I thought it would be easy to just create the charts/graphs in Exce
and then just cut and paste to the PP-Slides. I'm finding that it isn'
quite that easy.
Here are some of my problems that I hope someone might be able to she
some light on and give me some direction.
1. In Excel how do you control the size of the chart?
- When I create a chart 1 and define the data ranges I get a goo
looking chart then I thouht, why reinvent the wheel so I just copy th
chart to create chart 2 and change the data range, but...odd files created
Every time I open and edit an excel spreadsheet on a
network share, small odd files get created. They are
usually no larger than 25-40k and don't have any
extensions to them. Looking at the properties page for
any file, the file description says File. Anyone know
what this is from or how to get rid of them? Permissions
are setup correctly for me, Word files don't have this
Excel 2000 SP3
A file the same size as the workbook would be created
in the same directory as the workbook. The filename
would be nonsensical (or appear to be random) character...Create Calendar mtg invite template to avoid retyp'g conf no's?
I want to create a calendar template so that I can avoid retyping my
conference call details in the location field everytime I create a new
invite. How do I do this?
In what version of OUtlook?
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
> I want to create a calendar template so that I can avoid retyping my
> conference call details in the location field everytime I create a new
> invite. How do I do this?...vba to prevent display of default series in doughnut chart
I am generating a doughnut chart using VBA and am having two immediat
1) I am using the following line to ensure that the default chart tha
is generated when I invoke the Charts.Add method is a doughnut chart:
Is there a more elegant approach to ensuring that any chart create
ends up being a doughnut chart, maybe when invoking the Charts.Ad
method? I have tried to specify ChartType = xlDoughnut after th
Charts.Add method but this does not do the trick every time (see cod
2) When the doughnut chart is added (immediat...Create Login with T-SQL
I am creating, using T-SQL, a database with its file groups, tables,
Can I also create, using T-SQL, a Login with Username and Password to
access that database?
Usually, I go to Security > Logins of SSMS to manually create the
However, if I could do the same using T-SQL I would have it all made
EVERYTHING that the GUI does winds up as tsql executions on the server. :-)
Most of them you can generate a script for using the Script menu in the
upper left of the current dialog window. This is a great way to ...