Save Pub file as .jpg
In order to have captioned photos to insert into a manuscript written in MS
Word, I am saving pages from Publisher as .jpg files. Each page or new .jpg
has a few photos with captions on it. When I save them, though, the new .jpg
somehow has a vertical line on the left margin that I can't seem to remove.
NoCal Publisher User
...Excel open file as text
is there a way to tell excel when opening new file, treat is as text?
i.e. even if there is a 00000 value leave it the way it is
New workbooks don't have values.
Do you mean open a *.txt file in Excel and have values treated as Text.
Open the *.txt file and the Text Import Wizard will pop up.
In Step 3 select all columns(Shift + click).......Column Data Format>Text.
Gord Dibben MS Excel MVP
On Fri, 11 Dec 2009 11:52:38 -0800 (PST), "email@example.com"
>is there a way to tell excel when opening new fil...Unable open file with SP-3 but can open with Excel SP-1
I am having issues opening a file using Excel Sp-3 that was created with
Excel SP-1. I can open it in Excel SP-1. Any ideas what could be causing
what happens exactly?
>I am having issues opening a file using Excel Sp-3 that
was created with
>Excel SP-1. I can open it in Excel SP-1. Any ideas what
could be causing
Basically it crashes and ask is you want to send an error report to
"Frank Kabel" <frank.kabel@freenet...date of JPG photo file which is taken
i am using a lot of photos taken at a construction cite,and i have to write
the date of JPG file which is taken
to excel sheet.
how can i get the date VBA property of which is taken at cite.
I mean the date of taking photo
Download the (zipped) source code - extract the "cls" file and import to
your VBA project (it's for VB6 but seems to work fine in Excel VBA).
Dim exif As New ExifReader
Debug.Print...Opening file question
When opening a file direct from my documents excel opens
but the sheet does not get displayed. Although if you then
click print preview the content of the sheet is there.
Tried opening excel and then opening file and this works
fine. Not a major problem but annoying.
Any one shed any light?
I think xl is trying to help you.
Excel wants to keep the window settings the same way as they were previously.
If you saved your workbook in less than a full window, then the next time you
open it (via double clicking with no existing xl instance running), it will open
it the same win...Line Feed XML File
I am using SqlXmlCommandType component to generate an XML file in a VB.net
Console Application. Everything ran perfect except one thing. I need to know
if there is anyway to make this XML file Line feed file. In other words, I
need to put each tag in one line instead of mixing them up.
Do I have to create an XSL file to do this transformation, or there is
another way on the .net framework to do it?
Nader Shahin wrote:
> I am using SqlXmlCommandType component to generate an XML file in a VB.net
> Console Application. Everything ran perfect except one thing. I need to know
> if ...ask help for DLL Export Library Definition File
I got a problem when I build an MFC App which call a MFC
Extension DLL that has implemented some API, but I don't
know where is the problem, in DLL, in dll def file or in
the API like this:
extern "C" AFX_EXT_API long WINAPI PassThruConnect
unsigned long ProtocolID,
unsigned long Flags,
unsigned long *pChannelID
extern "C" long WINAPI PassThruConnect
unsigned long ProtocolID,
unsigned long Flags,
unsigned long *pChannelID
and its def file like this:
__...Display Logged-in User Picture?
Does anyone know if and how I can automatically display the My Site profile
picture of the currently logged in user? Is it possible to display this
picture in a Content Editor Web Part?
Not that I have an answer, and I'm not trying to be snarky. I often see
questions like this, and I'm just wondering... why do you want to do this?
Daniel A. Galant
Imagine what we could be... if we could just imagine.
"hedbeb" <firstname.lastname@example.org> wrote in message
When sending large (file)size pictures I notice that Outlook splits the
E-Mail into a number of seperate pieces. They are then sent seperately and
then Outlook puts them back together at the other end.
Does anybody know what's the maximum size is before they are split up? I'm
asking as there are often long gaps before the first and last piece is
recieved at the other end.
I believe this is a user defined option. (Look on the advanced tab of your
POP3 account setup)
Neo [MVP Outlook]
Due to recent events in spam and malicious programs, all e-mails sent to
this acco...overwritten file
I have accidently overwritten a very important excel 2003 file.
Is there anyway to recover the file?
Regretfully, no. It is gone!
You will need to restore it from your backup disc (you do have a backup
disc, don't you?)
Bernard V Liengme
remove caps from email
"jap786" <email@example.com> wrote in message
>I have accidently overwritten a very important excel 2003 file.
> Is there anyway to recover the file?
...Zip files using makeDirZip.exe
I need to zip subfolders which resides under the parent folders which
are 201003,201004,201005(for each month).
Under the parent folder.example 201003->Titles->then many sub folders
for each day of the month,I need to use MakeDirZip.exe to only zip sub
folders for each day under the root folder(201003) which is 2 months
old from this month.
Please shed some light on it.
I am trying to use,
C:\test>makeDirZip.exe i=\\<filer>\c$\cdc dubug='yes' purge='no'
which is zipping every single date folder no matter whether this month
or 2 months ol...How do I merge two files in Excel?
How do I merge two Excel files, each with a different name and different
you may provide some more details:
- data layout
- HOW you want to merge them
"Chem303" <Chem303@discussions.microsoft.com> schrieb im Newsbeitrag
> How do I merge two Excel files, each with a different name and different
> data? Thanks...Mike
...Sharing a money file on a server
I have my Money file on a shared folder on a server. I have two client
computers that I wish to be able to access this file from. I have Money 2004
installed on both clients. The trouble seams to be that if one computer is
running the Money fike is locked even if Money 2004 is not running on that
computer. Thus the second computer cannot acces the file.
Is there a fix for this?
You're lucky you haven't corrupted the file outright. Money was not designed
for simultaneous access to the data file from two apps. It can get ugly.
Consider yoursel...What happened to the functionality of the ObjModel header files?
I'm porting a MFC application from MSVC 6.0 to MSVC 7.1. In our older
version, our code makes use of several header files from the ObjModel
directory. These directories have been eliminated in the 7.1 version. Where
can we find the functionality that was part of these files?
...trying to open .CHM help file
Can anyone help me please? i am trying to open a .CHM help file via a
command button on my form.
I have tried using SHELL but that doesnt work, presumably because it
is not a .EXE.
any help greatly appreciated
Already answered in another newsgroup to which you posted the same question.
If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, ...Regular data file imports
We have a General Ledger file that is beining imported by Users on
dialy basis into excel from a text file.
The column widths are identical every day.
Currently the Import wizard is used on a daily basis to split the dat
into the selected columns.
How can I have the file automatically complete the format when the fil
is opened or after the file is opened.
The file will have a different name each day.
Is there an easy way or will a macro have to be written.
Message posted from http://www.ExcelForum.com
I receive a 4,000+ line bank statement each month in text format and h...File size limitations of .pst file?
Is there a limitation within Outlook as to how large
a .pst file can be? Has anyone found problems once the
file achieves a certain size?
I have read that a file size greater than 2 gig will cause
problems. My problems begin around 1.5 gig. Yes I have
plenty of room on my computer
>Is there a limitation within Outlook as to how large
>a .pst file can be? Has anyone found problems once the
>file achieves a certain size?
For pre OL2003, using 2003 format, the limit is 2gb, however problems can
occur if greater than 1.6gb
You can endup ...Compacted .dbx files in Outlook Express 6
I was attempting to move my folders from OE 6 unto
another computer. After reading the MS Help, it
suggested to compact the file to copy onto a disk and
onto other pc. This was successfull, but I am now unable
to read these .dbx files from either pc's from Outlook
Express 6.0. I don't want to lose these emails! Does
this have something to do with identities? Is there a
Any help would be immenseley appreciated
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one...Help, how do I import a CSV file when Negatives are in Parenthesis
I am attempting to import a Comma Separated Value (CSV) file into an MS
Access 2007 mdb table. The table consists of text and numeric (defined as
Unfortunately, negative amounts are NOT enclosed by double quotes in the CSV
file, instead the are enclosed with parenthesis signs.
Currently, when I import the CSV file, the negative amounts are NOT imported.
I need assistance with how to import these negative amounts.
Thanks in advance.
"ND Pard" <NDPard@discussions....How to Change File Extension
I am new to VC++.NET. I have a stuck with a problem. I am
creating a temporary file in C:\Windows\Temp directory. The file name
would be <filename>.tmp. Now if I want to change the extension to some
other extension like ".doc" or ".xml" , how can I do it? Is it possible
In one of the post, I saw we have to invoke IDR_MAINFRAME.
But I am not finding any such thing in VC++.NET.
"yesh" <firstname.lastname@example.org> wrote in message
news:email@example.com...Moving Public Folder Database Files
We have exchange 2003 SP2 on a Windows 2003 Enterprise server.
All I want to do is move the Public Folders database files to a new drive on
the same server. Is it as simple as dismounting the Public Folder Store,
copying the database files and pasting them to the new drive, pointing the
Public Store to the database file locations on the new drive, and then
mounting the store? The Transaction logs are remaining in their current
location - they are not being moved.
Would there be anything more to it then that, anything I'm missing?
On Mon, 8 Mar 2010 08:15:01 -0800, raz4183
&...How to open a large excel file?
I have a large excel(66MB), but when i try to open it I find that Excel can
onle open no more than 65000 row data.I also try to load the excel file from
Access,but it also cann't run.So how can I load the data in the file without
65000 row data?
Die Tastatur von alex lee wurde wie folgt gedr�ckt:
> I have a large excel(66MB), but when i try to open it I find that
> Excel can onle open no more than 65000 row data.I also try to load
> the excel file from Access,but it also cann't run.So how can I load
> the data in the file without 65000 row data?
What you describe is...Corrupt MNY file Corrupt Backups
After a system crash and a reinstall I can not open any
MNY or backup files. I have run Salvage.exe and was told
irrepairable. I can not open the file to do
and "import/export" I have ensured they are not read only.
I read the public forums but most fixes assume you can
open the file or the backup to repair it. Is there anyway
other ways to repair my data?
Not sounding good here. See http://www.bollar.org/msmoney/#Q104. But it
sounds like you have exhausted most of your options.
But I am kinda mystified why a "system crash" would mung a Money file. Are
you sure you h...File Format Incorrect???
I am trying to add an expense category to microsoft deluxe
2003 in the buinsess account.
When I get to the creating a withdrawal and chose a
category a message pops up saying:
"The format of the tax deduction eligibility criteria
table file (TaxDC.tbl) is incorrect."
"The file has somehow been changed so that Money cannot
read it correctly. You should either set up Money again,
or download a new version of this file through the
When I do the update, nothing is fixed . When I search for
this file on my computer I don't find it.
What can I do ...? Message Maps in HPP Files
I'm trying to simplify my reusable code by putting everything for some stuff into self-contained, single files. For example if I
wrote a a couple of simple classes that I can use in lots of programs, I put all the code for each class in single HPP files instead
of splitting them among separate CPP and H files.
This works for some of my things but I am having trouble with one of them. I have a class that adds some custom functionality to
the CListCtrl. It works fine if I have it split, but if I use a single file I get "already defined in the OBJ file" errors for the