How do I save an Excel file in ASCII?
Mrs Crinkle wrote:
Save as *.csv
> How do I save an Excel file in ASCII?
To save formulas and values, use:
Tools >> Options >> View
and check "Formulas"
File >> Save as
and choose CSV as the "Save as type"
Many Excel features aren't preserved, but you'll get the basic values and
formulas for one worksheet.
...Find the most recent record in a file
I'm using Access2003 and this is what I'm trying to do.
I have a Table with 3 fields:
[Date of Activity] [Person Performing Activity] [Type of Activity]
I want to write a query so I can list the Date of the most recent Activity,
for each Type of Activity, and have it print on a Report.
I'm going to run this report daily, and want to list one record for each
"Type of Activity" and show the most recent date that activity was
performed, and the person who performed it.
Any help would be appreciated.
create a query with type of activity grouped and date of ac...Additional file with no extension created during File Save As proc
Good morning all!
I originally posted this query on the Developer board, as I thought it was a
problem with my code, but now I'm not so sure.
I have a workbook with a macro that runs a Save As within a loop, to create
test data files.
I was finding that for every new file I created, and additional file with a
filename comprisiong eight alphanumeric characters and no file extenson was
created in the same folder.
Thinking that the workbook might be corrupted, I created a new workbook
(with NO copying/pasting from the original - everything types in from
scratch) , created new code m...merging .pub files
I have created 2 .pub files using Publisher 2003, a 50 page directory file
and a 4 page calendar file. I want to append the calandar file onto the end
of the directory file but can't find any method of combining pre-created
..pub files. I assume there is a method, but as a rookie, can't find it.
I also have Publisher 2007 available, if it would work better.
Any assistance is appreciated.
Bruce H wrote:
> I have created 2 .pub files using Publisher 2003, a 50 page directory file
> and a 4 page calendar file. I want to append the calandar file onto the end
>...FILE SIZES/CANNOT SAVE
Hi there !
I have an excel spreadsheet with 8 wsheets which
worked perfectly , and was 180k in size. However , as I
REMOVE wsheets the file size INCREASES! When I leave just
3 Wsheets , each EMPTY! , the file size has quadrupled to
750K ! .. and I am unable to save/overwrite it on a
Has anyone any ideas ? ... Many thanks .... Brian
NEVER save to a floppy. SAVE and COPY to the floppy. Same thing on getting
file FROM floppy. Copy to HD. Then open.
"BRIAN BARNARD" <firstname.lastname@example.org> wrote in ...Converting money file #2
I have installed GnuCash. Can I use Microsoft Money data with it?
Microsoft MVP - Money
For unofficial FAQs see
I do not respond to any emails that I have not specifically asked for.
"abc" <email@example.com> wrote in message
>I have installed GnuCash. Can I use Microsoft Money data with it?
GnuCash imports QIF. Money exports QIF. Assuming GnuCash does sane things
with the iimports, that'd be better than nothi...Excel 2007 painfully slow to open files
Having upgraded to Office 2007 (XP Pro, 1 Gb RAM Pentium 4 2.4GHz) I am
finding Excel to be painfully slow even when opening small (50k) files by
double clicking either the file or a shortcut. If I have Excel open and go
through the ribbon menu to open the file from within Excel it opens
immediately - it is only slow when opening a file via shortcut or double
clicking the file with Excel closed.
Is there a fix for this?
> Having upgraded to Office 2007 (XP Pro, 1 Gb RAM Pentium 4 2.4GHz) I am
> finding Excel to be painfully slow even when opening small (50k) f...Forgot my PST File Password
I have Outlook 2003 and I put the password on my PST file, but now I
can't remember it. Is there any way I can recover the password?
Thanks in advance,
> I have Outlook 2003 and I put the password on my PST file, but now I
> can't remember it. Is there any way I can recover the password?
> Thanks in advance,
Google is your friend - many PST password-crackers out there....
Gordon <firstname.lastname@example.org> wrote:
> Google is your friend - many PST password-crackers out there....
But none I've s...Tutorial On Using Windows Vista Compressed Files Capabilities
Where can I find a link or tutorial on using Windows Vista's Compressed Files
Capabilities? I am of need to create several Zipped Compressed Files. I am
not interested in third party software. Thank you Eddy.
Very simple - Right click the file ( or Files ) and from the context menu
place your pointer over "Send To". From the secondary menu choose
"Compressed (Zipped) File".
"Eddy" <Eddy@discussions.microsoft.com> wrote in message
> Where can I find a link or tutorial on usi...Excel 2008 cannot open xlsx and xlsb files created by Excel 2007 for PC
Just today (17 January 2008), I installed Office 2008 on my Mac and discovered a major incompatibility: Excel files, moderate in size or larger (e.g., 2 Mb) created in Excel 2007 for PC and saved in xlsx and xlsb formats cannot be opened by Excel 2008 for Mac. <br><br>I just spent an hour on the phone with technical support at Microsoft. While talking to the support person there, I sent to him three such files, and he and his collegues were unable to open any of them in Excel 2008. <br><br>If you try to open such a file in Excel 2008, the latter seems to "hang&qu...Importing Excel file without server access
I'm automating the process of emailing query results as an Excel file
attachment to one recipeint. The recipient will complete data in the Excel
file. My problem is that our company will not give this person access to our
server, therefore he cannot upload his updated Excel file to one of our
drives where I can then access it, import and update my table. There is
nobody that he can email the file to either. I believe, however, that he'll
have access to unpload a file to our company's SIFT site. Is there a way,
through automation, that I can then import the file from ...Repost: Signed catalog file giving me "can't verify publisher" err
I have a driver that consists of a single .inf, .cat, and .sys files. I
signed the .sys, ran inf2cat, and then signed the .cat file. Signtool verify
/kp gives the catalog file a clean bill of health, but I still get the red
dialog with the "Can't verify the publisher of this driver" warning whenever
I plug in the hardware and install the driver.
Does anyone have any idea what could be going wrong? I don't require full
WHQL certification to get rif of the warning dialog, do I?
I suspect you have not cross-signed your driver. Please check my blog post
regard...deleting the dynamics.dic file on the server
Someone at a client of ours went in and somehow managed to accidentally
delete the dynamics.dic file from the server’s GP code folder. Now, GP will
of course not run on the server.
The client tried to alleviate this issue by copying the dynamics.dic file
and dex.ini file from a working workstation. That did not work. They still
get errors on the server whenever someone tries to launch GP from the server
(Visual Basic initialization failure, ".tlb files are missing", outdated
versions of OLE system files are present, etc.)
The client does not have a backup of this c...Problem opening office xp excel files
I have office xp and when I click on an excel file, Excel will run bu
it doesn't open the file, it leaves it empty and gray. Problem goe
away if I do file, open, filename. Can anybody help?
This problem happens to all my excel files, not just a particular one
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Try Tools / Options / General / If 'Ignore other Applications' is checked then
Ken..........................Excel Image not displayed when the physical file is N/A
I'm having a problem on images that's generated from excel. I'm using the
url method to generate the excel file and I'm aware that the images are
stored in a physical location and the images won't be able to be displayed if
the physical file is not available.
I'm able to display the images out when the excel report is generated;
however, when we save it as the default xls extension file, and open it in
another location, the images are not displayed, as only the physical file
path is being stored in the excel file. I've tested it on a c...Excel opening with Visual Basiic File not Found Error?? Help!!!
When I open up Excel I am receiving an error message "Microsoft Visual Basic
File not Found" when I hit help it tells me it is file not found error 53.
Can anyone provide me some information on how I need to fix this problem.
See responses to similar questions from Tom Ogilvy
and Dave Peterson:
"jbsand1001" <email@example.com> wrote in message
> When I open up Exce...Word Automation
Bug Report (can't find out how to submit bug reports other than here)
Summary of bug - Word 2007 automation object throws error 5174 with any
filename that has the pound sign (#).
I have run into this bug only when using the Automation object for Microsoft
Word 2007. I have not tried this with other versions of Word.
The file I am opening is a "doc" file, NOT a "docx" or "docm". The filename
contains a pound sign (#). I am able to open this file using any other method
(File->Open; double-clicking from Windows Explorer; etc). But when opening ...Make ZIP files from ASP.NET with VB
Hi somebody have an example or an idea to how to make ZIP files from a
Thanks a lot
On 9/17/2010 2:14 PM, Marcos G. wrote:
> Hi somebody have an example or an idea to how to make ZIP files from a
> Thanks a lot
Have a look on codeplex (http://www.codeplex.com) - there are severa...How to properly transfer an outlook.pst file?
For years I have struggled with "transferring" Outlook's .pst file, e.g.,
when doing a complete re-install of Windows or when a client buys a new PC
and wants their Outlook data transferred from their backup files. Invariably
something gets botched up and this usually means I have to spend hours
trying to resolve the mess created. I am assuming there must be a proper way
to do this and obviously I'm not doing it. What I'm hoping for is that
someone will provide a step-by-step procedure that WORKS.
My general practice has been to install Office, open Outlook and cre...outlook freezes attaching files
Outlook freezes when users try to attach files stored on a
network drive. Only some users have this problem, if I do
the same with a different login it work just fine.
Does anybody know of any RMS Add-On where you can Create a Purchase Order by
importing an item list from a CSV text file? We have a customer that gets an
excel spreadsheet from their supplier of all the items that they should be
receiving via UPS. The customer doesnt know before hand what they will be
receiving until they get the excel spreadsheet. Any Ideas?
I'm new to RMS, so forgive me if this info is slightly inaccurate, try it
If you create a blank P.O for adding item manually, on the screen where you
enter your items, right click, and import. Then you choose you...Opening Publisher 2002 Files
When trying to open a file in a terminal server environment I get the
following error. Microsoft Publisher: The file s:\04a.pub cannot be opened.
Access privileges have not been given. Publisher 2002 is installed on both
Windows 2000 Terminal Servers.
Is the file on a network drive? If so, try copying it over to your local
MVP Microsoft [Publisher]
"Senior Systems Engineer" <Senior Systems
Engineer@discussions.microsoft.com> wrote in message
> When trying to open a file in a termin...Looking for Microsoft Office Binary File Format or File Signature data
I have an application which obtains numerous "unidentifiable" files
with no file extension, via FTP, and would like to run some sort of
binary filter on it to identify PPT, DOC, XLS file formats.
I did fine this: http://www.garykessler.net/library/file_sigs.html
But it seems a messy way of accomplishing this, and is incomplete. Any
clues as to finding the binary record format and/or file signatures of
Office documents (Office 2000 and greater).
...Menu Options on File
I have Outlook 2000 working in Win2k with all the service
paks installed. On my File menu I have a Backup menu
option that allows me to back up my .pst files at pre-
defined interavals. I have Outlook installed on WinXP
Home and it does not give me the backup option. Is there
something that can be set in Outlook on the XP system to
give me that menu item?
...Excel temp files in network dir
I have users that are accessing a network shares to their
excel files. I often see files that are 8 characters long
Ex(D8710B20) and without extensions, left over in their
dir. I have read MS article 814068 and understand that
these are created during the save function; however, i
have ruled out permissions and antivirus as the cause.
These files consume a lot of network space. Any guidance
would greatly be appreciated.
"les" <firstname.lastname@example.org> wrote in message
: I have users that are accessing...