how can I format output data to a fileHow 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\abegin 644 306dfrq1j.txt
M66]U)W)E(&EN(%-E<FEO=7,@5')O=6)L92 M($ET)W,@82!0<F]V96X@1F%C
M="$-"@T*1D))($9/4D5.4TE#4R!#04X@1DE.1"!$14Q%5$5$($9)3$53#0H-
M"E1(15)%($%212!42$E.1U,@3TX@64]54B!#3TU0551%4@T*5$A!5"!93U4@
M5$A/54=(5"!93U4@1$5,151%1"X-"@T*(2$A(4)55"!42$59($%212!35$E,
M3"!42$5212$A(0T*#0I#;&EC:R!H97)E(&9O<B!D971A:6QS(&]N('1H92!%
M5DE$14Y#12!%3$E-24Y!5$]2#0H-"D-L96%R('EO=7(@8V]M<'5T97(@;V8@
M:6YC<FEM:6YA=&EN9R!F:6QE<PT*=&AA="!Y;W4@8V%N;F]T(&1E;&5T92X-
M"@T*=W=W+G...
Tracking open filesI 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
file.
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
this.
In addition to PPTX and DOCX, I usually keep a...
Outlook 2003In 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
Thank you
See if the VBA code at http://www.outlookcode.com/d/code/setsavefolder.htm
does what you need.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"jc1148" <jc1148@dis...
Shariing Outlook 2003 files across a home networkI'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
machine.
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
email.
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 UrgentHi,
I have the following fields:
rep orderack
Blue Y
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
M
Hi a little more info
rep orderack
blue Y
blue Y
blue Y
blue Y
total 4
"mahmad" wrote:
> Hi,
> ...
Wav File Question for PPS filesI 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?
--
Ken Russell
kenrussellyourhat@optushome.com.au
Remove yourhat to reply by e-mail
..
"moe3rd" <moe3rd@discussions.microsoft.com> wrote in message
news:BB1A0479-4242-4E05-8BFD-AAB264F948ED@microsoft.com...
>I need to be able to set up a tickler file where I can enter a name and
> discha...
Pivot Table Source fileI 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.
-Paul B.
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?Howdy,
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...
Regards,
Kevin
Kevin, use something like this, put in thisworkbook code
Private Sub Workbook_Open()
Sheets("Sheet2").Select
Range("C3").Select
End Sub
--
Paul B
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 fileWhen 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?
...
"Publisher has detected a problem in the file" error message 11009"Publisher has detected a problem in the file you are trying to open. To
protect your computer, Publisher will not open the file." "Was this
information helpful?"
What? What information? Four days working on a brochure and now I can't open
it!
Any suggestions or places to start?
Note possible related event. This occurred after deleting McAfee Security
software, and the file has internal hyperlinks (hyperlinks to pages within
document"
Do you know anyone else with Publisher? Send it to them and see if they can
open it.
--
JoAnn Paules
MVP Microsoft [P...
excel2000-password shared file over wireless network-crashingI 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.
Thanks,
Joe
...
http://LongPathTool.comhttp://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...
Question about file locationHello 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
I'm using:
Try
Dim reader as New
StreamReader("System.AppDomain.CurrentDomain.BaseDirectory() &
"resources\datafile.dat", true)
Catch ex As Exception
MsgBox("Could not open file")
End Try
Now, you would think that this would work, right (maybe...
OL 2003 and problem with zip filesWe 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...
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
"brianh10/14hilton".
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(...
Compiled ocx file reports different sizesHi,
When I use MSVC 6.0 ide to compile my active x component , the size
reported is 412KB
But when I comple the same fromcommand line, the size reported is 408KB
Why ?
Am I loosing something here
Does IDE add somethings...
Help
sandSpiderX
Likely you are simply using different compile options. Variations in optimization, byte alignment,
debug info, etc. can all yield different sized modules.
"sandSpider" <m74.piscean@gmail.com> wrote in message
news:1120826022.231620.249400@g43g2000cwa.googlegroups.com...
> Hi,
>
> When I use MSVC 6.0 ide to compile my activ...
PC freezes when I open a fileI 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...
import .QIF-file with category informationI'm trying to import a QIF-file with transaction-information. The
import completes succesfully, but I cannot find any category
information. Does anyone knows a solution ?
Regards,
Arthur
...
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.
So i
const char * fred = "elevator.dxf";
the file name is pass to function
etc...
drawing.LoadFile(fred)
etc....
and FileName is in debugger = "elevator.dxf"
pStream = fopen( FileName, "rb" ))
but pStream is NULL there;
Why?
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...
PST files won't openI have 3 PST files that were created by someone else.
They are each less than 40MB and all have the correct .pst
extention. When I try to open any of them (they sit on my
hdd) Outlook tells me "The file is not a personal folders
file". I am running Office 2003 Pro. Any ideas?
Cheers and Thanks.
Are these pst-files on your harddisk and have you verified that the "Read
Only" file attribute isn't checked. Connect to it by using File-> Open->
Outlook Data File... If it's still not working use scanpst.exe to scan the
file for errors.
--
Roady [MVP]
w...
Display file in EUC japanese formatI have several files in EUC format containing a mix of English and
Japanese characters. I want to dump them into a CEdit.
I have created a unicode app. I have selected "Arial Unicode MS" as the
CEdit font. I have used CStdioFile to open one of the files and have
used SetWindowText to display the text in the CEdit.
The English characters display properly, the japanese do not.
I have tried to use MultiByteToWideChar but, if that is the way to go,
I can't get it to work properly.
I am using an English W2K with Japanese IME installed (in case it is
relevant).
The conversion shou...
Lost Oulook.pst fileI'm using XP SP3 with IE8, tonight I uninstall a program and it required a
Restart, when it came back up, my Outlook.pst file is missing. I searched
entire hard drive, no file. I then did a System Restore and again file was
missing.
Any ideas or suggestions out there? I mainly use Outlook 2003 for the
calendar feature to keep up with appointments etc.
--
Thanks, Bill
Post replies back to News Group
You have to search to include hidden for *.pst
System restore has no baring on data files, only your backup restores data
"Willy" <justask@hotmail.com>...
Storing Outlook files on external hard driveIs it possible to set up Outlook so instead of its files
(not program but directory, contacts, messages, et al)
are stored on our external hard drive? Last year our old
computer died and we lost a lot of information on its
hard drive.
OR, can I regularly transfer the information to the hard
drive?
I do not beleive you can store what you want out of the
program directory. However, you can make backups of the
data you need whenever you would like. This is
import/export feature in office. Located on the FILE
menu. The one thing I do not like about outlook is the
fact that there a...