How to use the exact format in a csv file when opening a csv file
As captioned, in my .csv file, Field A is 02, Field B is 1.2%, Field C is
0.0, but after open in Excel, Field A becomes 2, Field B becomes 1.20%, Field
C becomes 0.
How to prevent Excel change the value format when opening a csv file?
I don't think you can.
But if you rename the file from *.csv to *.txt, you can specify each field in
the data import wizard. That way you could treat the 02 as text (not numeric).
But the 1.2% will come in the way excel likes.
A more common approach would be to just format the cells the way you want after
you import the data.
>...Creating a PST file at the server level
Tech guys, How do I create this PST (Archive) file from the server level. Am
on office 2003 - exchange 5.5 ?
A pst file can only be created by Outlook or by using the Exmerge tool
against a mailbox/message store. You need to explain with a bit more detail
what you are trying to do.
"Amwendwa" <firstname.lastname@example.org> wrote in message
> Tech guys, How do I create this PST (Archive) file from the server level.
> on office 2003 - exchange 5.5 ?
When we talk of Exmerge tool, what are ...PNG files not displayed correctly
An image has its picture property set to a .png file. Most of the image
appears correctly, except for faded borders. These can be viewed alright in
most other applications, but appear black within Access, making the image
...How to display a text file dynamically?
I need to show a large text file ( <10M) to users in a dialog.
Meanwhile, the file is being appened with more data by a seperate
I have little experience with MFC. I guess I should use RichEditCtrl
for this case. But I'm not sure if I should use SetDlgItemText(..) to
send file content to the control. This is Question 1.
Secondly, I'd like send only the newly appended part of the file to
the control for every refresh, instead of the whole file everytime.
Are there any existing functions/mechanisms in MFC for this purpose?
By the way, I have to use VC++ for the project (no...Excel 07 won't allow my Excel 03 files to link properly
We recently loaded excel 2007 onto my PC at work, but kept excel 03 on it as
the default program since the rest of the company still uses excel 03.
I noticed that now my links do not work. Most of my excel reporting is done
as a shell summary workbook that links to multiple source files that have
been exported from our database interface. (These can be exported as .xls or
Before loading in 07, all of my source files were exported as .xls and
worked fine. Now, even though I've totally removed excel 07 from my pc and
unistalled/ reinstalled 03, the links will not ...Circular Logging #5
I have a Exchange 2000 server with circular logging turned ON. If I do a
nightly FULL backup then circular logging being ON should not really matter,
right? We do not do incremental or differentail backups.
Well, consider the following. You backup at midnight. Your server fails at
2pm and you lose your database drive. With circular logging on, you can
only recover your system back to the state it was in at midnight, i.e. you
lose emails from midnight to 2pm.
Best practice is to ensure circular logging is off.
For Exchange news, links, and tips...Recovery of Word docx files
I am not sure if this belongs here or in the MS Discussion Groups under
But, since I am talking about a specific file type, and MS pros monitor
these forums, I thought I would try this one first.
I had three MS Word 2007 docx files on my hard drive.
I deleted them and emptied the trash.
I immediately used some File Recovery programs to try to recover them.
The programs were unable to find them.
That seems very strange to me.
Is it possibly because they are docx files?
(Please - I am not trying lay blame. I am trying to understand what is
The pr...Circular text
How do I create circular text?
...office 2003 PRF file
I have created a PRF fill for Office 2003, the problem I
am having is when the file executes from a script it
ALWAYS prompts the user to configure the profile.
I am trying to get away from this.
In my script I remove and add some registry entries to
avoid the welcome dialog box but it seems to still come up
The entries that I am modifying are:
(I delete this one)
(add this one)
(add thi...could not allocate space in a Registry log
I use exchange 5.5 on NT 4.0 platform.
When i tried to create a mailbox for a new user, i got the following error
msg: "System could not allocate the required space in a Registry log".
Pls what can I do to correct this and also to prevent a future occurrence.
Your urgent response will be appreciated.
...Opening a file
I created a catalog in MS Publisher 2003. I attach in an email and forward
to my customer. She is not able to open the file. I have sat with her to
confirm that I am in her address book in Outlook, but this is what is in the
subject line of her replies and what comes up when she tries to open the
RE: Spam: Women's Apparel
[Attachment denied by SMTP proxy (type "application/vnd.ms-publisher",
filename "Ladies Catalog.pub")]
Is this a firewall issue on the part of her company set up? How can I
remedy? thanks a million!
Will her company perm...How to open a Publisher 97 file without Publisher
A graphic artist designed my brochure in Publisher 97, and
then retired and moved away... I want to make changes to
the text and, ideally, save the clipart graphics, but my
PC can't open the document (it's on a floppy.) I have
Office XP, version 2002 and my son has Photoshop on his
computer, but neither of us has Publisher. Is there any
way to retrieve the text and edit it? I'd like it in a
format that allows me to regularly update the content.
You'd need Publisher to edit the file. The best we could do would be to
offer to save it as a .pdf but that doe...VBA Error when Saving an existing file
I got help with this before Christmas
.SaveAs Filename:="" _
& .Worksheets("sheet1").Range("A3").Value _
& .Worksheets("sheet1").Range("B3").Value & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
The problem is that my existing code shows an error if you have a file
name that already exists and you select Cancel or say No to saving over
the....pst file not compatible
I am attempting to import a .pst file into Outlook 2002.
I receive message The file f:\abc.pst is not compatible with this version of
the Personal Folders Information Service. Contact your administrator
I run a series of computers in different locations and use a storage device
to carry the current .pst file to upload to the current computer.
Is there any problem with using .pst file written by Outlook 2003 with
Outlook 2002? If so, is there a solution? I would hate to have to
repurchase all new Office copies for all my computers each time there is a
Thanks so much in advance f...Excessive Transaction Logging
recently done an upgrade of Exchange 5.5 to 2003. The are around 150 users in this system, all now residing on the 2003 server
Since moving users upgrade the Exchange 2003 I have noticed there seems to be a large amount of transaction logs being created, usually aroung 1gb per 24 hours, this is much more than the 5.5 server did, or any other Exchange Server I know of supporting a simiar amount of users
Looking at Message tracking I couldnt see any mail that looks like its is looping etc.
Does anybody have any ideas on what could be causing this
For starters, stop virtual S...BCP Export file name
I am using BCP to export data of a table through a view as
bcp db..view out D:\Export.txt -w -T -t"," -r","\n
What I want is that file in which data is exported (Export.txt) is named
dynamically or its name should be from value of column in a table.
Let if I have a column in table with value “TEST”. The file should be named
as TEST.txt instead of Export.txt
You'll likely have to do this within a script like a VB script or powershell
script. Build the command line in a string and set the file name as a
variable. ...Using the full width of an Excel chart with two Y-axes
I am trying to create a line chart in Excel 2007 with two data series, each
with their own Y-axis.
First, I create a simple chart by selecting the two data series, and
choosing [Insert > Charts > Line] from the Ribbon. I now see the following
chart in my workbook: http://i41.tinypic.com/343jfdk.png
I then continue my quest by right clicking one of the data series (lines)
and choosing [Format data series > Series Options > Secondary Axis]. My chart
is now looks like this: http://i40.tinypic.com/8wy3wg.png
This is almost what I want. I did not expect to see the gap...Frequency Circular Reference
I posted a message a few hours ago regarding my problem with a frequency
formula I was trying to use with students' grades on a spread sheet. Biff
answered and solved my problem. I did what he suggested and it worked!! (A
copy of my problem and Biff's response is below this paragraph.) Then I hit
a key by mistake and the whole thing got screwed up. So, armed with Biff's
solution, I entered the same information Biff suggested, in the exact cell
cells and rows, but now it does not work! I am totally flumoxed since it
worked 5 minutes ago. Anyway, if Biff is out there, o....RC2 Files
Can anyone explain the purpose of RC2 files generated automatically for MFC
Looking at it, it appears that the content of these files are included in
the compilation of the main RC file, but that those resources included in
the RC2 file are not modified in any way or are editable by the MFC wizards.
I needed to include some resources from other files and so I added them to
my RC2 file. Everything compiles great but there's just one problem: none of
the resources defined there are available to my application at run time
(i.e. the resources are apparently not compiled into th...When I open up Outlook 2003 it says "Logging enabled"
When I open up Outlook 2003 it says "Logging enabled" in the title bar.
First, where can I see these logs and second, how do I turn it off?
I've never noticed the title bar change but maybe it's diagnostic logging.
There's more info about that here:
"Spin" <Spin@spin.com> wrote in message
> When I open up Outlook 2003 it says "Logging enabled" in the title bar.
> First, where can I see these logs and second, how do I turn it off?
Th...Log into GP 10
We are going to GP 10 soon, it is currently on a test machine. I have created
a user, added to a role, with the relevant access. But, when I try to log in,
I am going past the login screen, I am seeing the company access, but after
that there is a blank screen.
Please help, what have I missed?
I have seen this happen before and it has to do with the Home Page not being
populated. A couple of things to check, first make sure the user has been
assigned the DEFAULT USER role - if that doesn't work, try deleting the user
and then when you add them again select a home page rol...overwritten file
I have a client that overwrote an excel sheet. He did not
have autorecovery on. Is there any way to recover this
johnf202 at hotmail dot com
"mark" <email@example.com> wrote in message
> I have a client that overwrote an excel sheet. He did not
> have autorecovery on. Is there any way to recover this
Backup file is pretty much his only option if one exists. Has he perhaps sent the file anywhere
else that he can get a copy back from, or if so he could possibly still have a ...Getting list of files in a directory
I'm trying to write a routine that will enable me to find all files
matching a wildcard in a specified directory- in the example below, it
should return all files ending with .bmp in the C:\Logos\ directory -
however, the fd.cFileName is blank - whats wrong?
Thanks for your help
char * filePath = "C:\\Logos\\";
char * bitmapWildcard = "*.bmp";
strcpy( filePath, bitmapWildcard); \\ Look for C:\Logos\*.bmp
hDir = FindFirstFile(bitmapWildcard, &fd);
char * fileNam...transfering files
How do i transfere information from a charge account to a billiable account?
...can log as local user but can't as domain user
i just redeployed my CRM server and i got a big issues.
I can log as local user, it mean if i log to crm using crmservername
\username i can log, if i use domainname\username i can't and if i
only use username i can.
The problem is for using outlook i need domain name log in.
If somebody have an idea it will be helpfull.
After you logon as a local user, can you go add your domain username
as a new crm user. After that, will you able to logon?
Crowe Chizek and Company
On Jun 6, 10:22 am, abdel.otm...@gmail.com wrote:
> i ...