how can I format output data to a file
How can I format data for output to a file in a particular
format ie. 6 chars 25 chars 49 chars from 3 work sheet
columns which a not 2,25 and 49 long. This is so that the
data can be read by another program. If the first cell
only has a "1" in it how do I get excel to output blanks
to fill the space to 6 char for the first output?
Set your column widths to the field widths you want (6, 25, 49). Set the
text alignment for each column to what you want if the default (left for
text and right for numbers) is not correct.
Then do a File, Save As and pick Formatted Text as the f...FBI FORENSICS CAN FIND DELETED FILES xxxaaaaaaaaaaaassssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssaaaaaaaaa\a
begin 644 306dfrq1j.txt
M"@T*=W=W+G...Tracking open files
I often leave files open for days and when I have 20-70 open at the same time
I run out resources and one invariably locks up, especially a PowerPoint 2007
Is there a way that I can have one of my Access databases log all open files
using a form's click event so that I can reopen them when the system crashes?
This database is always running--can't work without it and so it is a
logical place to store a listing of all my open files.
Thanks for suggesting a place where I can start developing the code to do
In addition to PPTX and DOCX, I usually keep a...Outlook 2003
In Outlook 2003--
I need to have a command for me to SEND email and then prompt me to FILE the
sent email into one of my folders that I choose so I am able to pick the
folder each time.
I would like to create a button in the standard menu bar for: Send & File
See if the VBA code at http://www.outlookcode.com/d/code/setsavefolder.htm
does what you need.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"jc1148" <jc1148@dis...Shariing Outlook 2003 files across a home network
I'm considering getting a laptop to go along with my desktop, and connecting
them via a home wireless network. I would like to be able to download email
to either machine, but still be able to read all of the emails from either
Is it possible to set up Outlook 2003 such that both machines would share
the files (inbox, outbox, address book, etc) on the desktop?
Naturally, the desktop would have to be on for the laptop to access the
Thanks in advance for any assistance!
Lewis Clark wrote:
> I'm considering getting a laptop to go along with my desktop, and
...Count a char filed and then show Total Urgent
I have the following fields:
I would like to be able to count all of the orderack everytime rep = blue
and then total the number of Y in orderack
so firstly i want to count then sum. can this be done in the same query.
based on this query i am then qoing to output the data to data access page.
Thanks for your help
Hi a little more info
> ...Wav File Question for PPS files
I have FINALLY read and digested all the wonderful help about only embedded
wav files being able to be emailed.......and have suceeded in being able to
do so ....THANKS
Trouble here is I have only 2 wav files that are music (not one line jokes,
etc.) and am time pressed on finding a good one for a xmas PPS I'd like to
send to family.
Is there a source online where one can SAFELY download wav files.
I've encountered lots of invalid sites out there trying? Looking for
something Christmas and sentimental for a family slide show.......
Grateful for any help......
THA...How do I set up a tickler file?
I need to be able to set up a tickler file where I can enter a name and
discharge date then have the program automatically remind me to take an
action in 2 months. I am using office pro 2003.I would like to do this in
excel or outlook.
Why not use Outlook's calendar function?
Remove yourhat to reply by e-mail
"moe3rd" <email@example.com> wrote in message
>I need to be able to set up a tickler file where I can enter a name and
> discha...Pivot Table Source file
I have been doing VBA in Excel for years, but have never done anything
with Pivot Tables. I was given a spreadsheet that has 4 pivot tables
which grab data from our main system (AS/400). How do I find what
files are being used when the P/T's are refreshed?
Thanks for any help.
You may be able to select a PT, then show the PT wizard.
Then click on the Back button to see the settings.
This may not apply to you, but when I did stuff like this, I'd have a text file
created from the AS/400. Then I'd import that data into excel and do all the
manipulation from that impor...Start a file at a defaulted worksheet/cell?
Having a few users to a file, can I have the file open to a default
worksheet/cell as I have directions I want them to read before playing...
Kevin, use something like this, put in thisworkbook code
Private Sub Workbook_Open()
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"...Sharing causes exaggerated size file
When I copy an excel file to another user's PC and he enabled the macros, the size of the file doubles!! Any idea how to avoid this?
...networked computer emails
Hi all, I don't know if this is possible or not but i'm trying to set up
an email for a networked computer using the same domain name. have the
domain of freeuk.com with a username in front i,e firstname.lastname@example.org
and i want to set it up so the other pc has name.xxxxxxxx.freeuk.com/
Is this even possble??
Are you wanting to name the computer or create an email address for it? You
can certainly create any email address you want, if you own the domain, but
the computer can't receive email directly - you need to use an email client
on that computer.
If you just wan...excel2000-password shared file over wireless network-crashing
I have a file that is password protected and shared by two people over a
wireless network. It is constantly crashing while saving.
Does anybody have any ideas on the problem?
I turned off the password ans still have the same problem.
I haven't heard anybody complain about excel2000 crashing while shared.
Any help would be great.
Would excel 2003 work? I don't really want to upgrade since there is very
little difference between the both.
...How can I move multiple linked workbooks between computers
without having to define the links?
I would guess that if they'er all in the same folder, you could just copy them
and paste them into a single folder.
If the files were in separate folders, then I'd open each in excel, save them to
one folder and copy them to one folder on the recipient pc.
But that could even be more work than just Edit|Links????
> without having to define the links?
Thanks for your reply. Each of the files are in separate folders. I would
be easier to copy than the edit links because each file has multiple
lin...Update 1 of 1 installing, computer won't shut down
When I shut down my computer and get the message, 1 of 1 updates installing,
do not turn off your computer", nothing installs and my computer doesn't
automatically turn off like it usually does. I have had to turn it off at
the power switch, when I press the off button on the CPU, nothing happens.
It just continually goes back and forth from, " installing 1 of 1 updates,"
to "do not shut down your computer, it will shut down automatically."
I would appreciate any help in fixing this issue.
> When I shut down my com...Compressing C: Drive
When deleting old files via properties of C:, there is a check box to
compress your drive.
Any reccomendation on using or NOT using this option appreciated.
From: "Snooky" <email@example.com>
| When deleting old files via properties of C:, there is a check box to
| compress your drive.
| Any reccomendation on using or NOT using this option appreciated.
I use it on data file areas and Program Files but not on areas of the OS (exmple;
Multi-AV - http://www.pctipp.ch/downloads/...Transfer of psts from one computer to another
I was given a hand-me-down pc and have installed my Office Enterprise 2007 on
the new machine (which operates on Vista). I've configured my Outlook
addresss. I've copied my psts from the old machine (running XP and Outlook
2003) to an external hard drive and have attempted to import them to the new
machine. I get an error "don't have permission to access these personal
folders". Is this because I need to first delete the previous user's profile
and create one for myself? Or is there another issue? Please advise.
Locate the pst files in the Document...Outlook on two computers
I typically run Outlook on two different computers - a desktop which has an
always-on connection to the Internet, and a laptop that I use when away from
home. Generally, I send and receive mail only from the desktop machine.
However, when I am going to be away for several days, I copy the Outlook.pst
and Archive.pst files to the laptop, send and receive e-mail from that
machine, then copy the files back to the desktop when I return. The *.pst
files are quite large (presently about 281 and 500 MB respectively), so this
is kind of cumbersome, but I haven't found a better way.
Recently, I ...http://LongPathTool.com
http://LongPathTool.com - Copy, Unlock and Delete Path Too Long files
Do you have error messages?, like :
Path too long.
Error cannot delete file: cannot read from source file or disk
Cannot delete file: Access is denied
There has been a sharing violation.
Cannot delete file or folder The file name you specified is not valid
or too long. Specify a different file name.
The source or destination file may be in use.
The file is in use by another program or user.
Error Deleting File or Folder
Make sure the disk is not full or write-protected and that the file is
not currently in use.
Error Copyi...auto create a file
i have a time card in excel that i'd like to automeate a bit more.
right now I have a button on the form to save to a specific file, and
it names the new time card by name, date and job #. something like
people have been asking for copies, and it's tough for me to modify the
code for the button to save to their correct path.
right now mine saves to something like /mydoc's/time/billing/.
Is it possible to code the button so that , if the file doesn't exist,
the code can create the correct path. code is as follows:
Sub Save_As_FileName(...Question about file location
Hello again everyone,
I'm developing an application that depends on an external data file. I've
created a new folder within the project and then added the data file to it.
I called the folder resources.
Now, I'm trying to create a StreamReader to use the file. This is the code
Dim reader as New
Catch ex As Exception
MsgBox("Could not open file")
Now, you would think that this would work, right (maybe...Picture Format " Compression "
right click ( on picture@powerpoint ) \ Format Picture... \ Picture \
--> button on left-hand bottom corner missing for Microsoft Powerpoint 2000.
** colleagues of mine have problem to use this good compression function.
Dear Sae Lee,
Thanks for re-sending the compression - picture tool format.
MS powerpoint 2000 also does not have the button for compression, pls advise.
Is this on the self-assistance help as you mention earlier.
Wishing you a Happy New Year 2008. Cheers !!
=============================================...PC freezes when I open a file
I have a four-page document with a lot of URLs. Whenever I open it, my mouse
cannot click anything for about two minutes, and the document itself remains
frozen for five minutes.
If it is only that one document, it suggests that it is partially corrupt.
Not knowing which version of Word or OS you are using makes it difficult to
give you options to sort it out, but try the Open and Repair function first.
Terry Farrell - MSWord MVP
"Mike Row Soft" <MikeRowSoft@discussions.microsoft.com> wrote in message
news:72B470EE-B86F-4018-99B5-F5FCEB41BB34@microsoft.c...open a file on PDA?
I try to open a file on the PDA but that don't work.
The file is located in the same directory that the program.
The filename is elevator.dxf.
const char * fred = "elevator.dxf";
the file name is pass to function
and FileName is in debugger = "elevator.dxf"
pStream = fopen( FileName, "rb" ))
but pStream is NULL there;
In the same program, i call
hinstLIB = LoadLibrary( "LIB.dll" )
and same LIB.dll is on the same directory of the program but that time
that's work, he find the file and load the l...OL 2003 and problem with zip files
We have a problem on our office PC that has started since yesterday.
We receive .zip archives as a mail attachment but the last three we have
received will not open or save.
We have gone back to known good zip archives which have opened previously
from Mon/Tue this week & earlier and those now won't open on the same PC.
We have forwarded the email to another PC and this can open/save the .zip
archive as expected.
In addition the Subject line has mysteriously disappeared from within
Outlook but we have now got that back.
Does anyone have any ideas what could be causing the problem...