Automatic save with csv-extension
I'm using Office 97 at my work. Normally, the following code will save
worksheet to a csv-extension. But....VisBas stops at the 3th line wit
a run-time error '438'. What's the correct code or what am I doin
ActiveWorkbook.SavesAs FileName:="C:\upload.csv", FileFormat:=xlCSV
Message posted from http://www.ExcelForum.com
"SavesAs." Typo. Should be SaveAs.
mvpearl omitthisword at verizon period net
--------------...Worksheet disappear when saving on shared workbook
Im Using Excel 2000 SP3, when i try to copy a cells from another workbook
and paste it on the shared workbook, the worksheet of the shared workbook
disappeared after saving it.
...changing the delimiter while saving as txt file
is there a way to change the delimiter to # instead of tab
characters while saving the excel file to .txt file.
Thanks in advance
"raj" <email@example.com> schrieb im Newsbeitrag
> Dear Experts,
> is there a way to change the delimiter to # instead of tab
> characters while saving the excel file to .txt file.
> Thanks in advance
And some more links...
Maybe you can steal some cod...need to find the file that Outlook emails are stored in
there is one file that contains all the outlook email and
information. i need help to find it. also, how can i view
Open Windows Explorer and select Tools | Folder Options. Select Show Hidden
Files and Folders and uncheck the option to hide protected operating system
files. OK out and open the search panel (f3). If you are using Windows XP,
you need to configure the search to look for hidden items. If all goes
right, you should find your *.pst file(s) under \documents and
settings\<userid>\local settings\application data\microsoft\outlook.
Neo [...Graphics and attached file in e-mail activity / quick campaigns e-mails
We have migrated from Siebel to MS CRM 4.0. We are happy with the decision,
but very disappointed by the default options on e-mails, especially e-mails
in quick campaigns:
- Graphics cannot be inserted, e.g. a company logo
- A file, e.g. a PDF, cannot be attached
Can anyone help with a workaround, or any tips on a third party add-on /
tool that can expand the functionality in CRM?
We have tried deferent workarounds:
- Export the targets e-mail addresses to Excel. Design the e-mail in Word,
and send the e-mails from Word via the Excel list merge. That solves the
graphics issue, but...Purge data based on another Excel file???
I am attempting to purge data from a large list based on data in another
document. I have the files I want to remaove in on file and the file I want
to remove them from. There should be simple way to do this no?
...Can't open many XLS files at once
I have Excel 2000 and Win XP pro.
I used to be able to highlight many XLS files in Explorer, right click, choose
open and all the highlighted files would open in Excel with the different xls
files on my task bar.
I can still do this on my W98 computer, but I can only open one file at a time
on my Win XP computer. If I double click on a 2nd XLS file the 2nd XLS file
opens and the first file closes.
I tried the run excel.exe /regserv fix but this did not solve the problem.
Does anyone know how to fix this for Win XP?
maybe: Tools - Options - General and uncheck 'Ig...Access corrupt files DBF?
Access corrupt files DBF?
"Frank Dulk" <firstname.lastname@example.org> wrote:
>Access corrupt files DBF?
What is your question?
I see you're from Brazil. Have you asked your question in the
Portuguese Access newsgroup? microsoft.public.pt.access.
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"Frank D...Publisher/Word auto saving to C Drive
I teach in a computer Lab and when students are editing text using Publisher,
it takes them to Word andafter editing they close Word, I get a "Permission
Error . . C drive." When I do it on my computer (has some admin. privileges)
How and where does one change where Word 'appears' to automatically save?
Can this be changed without giving all students Administrative Privileges?
...Write a tool to generate a PST file with the same structure as old
I will migrate 1000+ users to Exchange 2010 and those users are using OL 2003
and OL2007. To help them migrate more smoothly, I will provide a tool for
them to generate PST file with the same structure as an old PST file.
Is it possible? How to begin this idea?
Have you looked at ExMerge?
If you are copying a PST file, why do you need to create a copy instead of
just using the original PST file?
Dmitry Streblechenko (MVP)
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"PST TOOL" <PST TOOL@discussions.microsoft....Official name of the File Selection Part of CFileDialog
I want to know the official name of the file selection portion of the
CFileDialog. I also want to know how this is implemented, is there a special
kind of ListBox that can do multiple columns?
"Peter Olcott" <NoSpam@SeeScreen.com> wrote in message
>I want to know the official name of the file selection portion of the
>CFileDialog. I also want to know how this is implemented, is there a
>special kind of ListBox that can do multiple columns?
http://msdn.microsoft.com/library/en-us/shellcc/platform/commctls/list...Office 2007 Professional: Help Files Issues
I cannot find a solution to this odd issue and before I submit a support
ticket I thought I would ask the community.
We have office 2007 professional (volume licensing) on a Window 2003
terminal server. We have a few users out of a bunch that get the "This page
is unavailable" I have tried the Refresh and back. I've tried online and
offline modes. In offline I get the table of contents to the left but same
unavailable message when I click the links.
I noticed on testing some other users, that apparently never used the help.
That there are some prompts...EXCEL 2007
I have a GIS application which uses .dbf files (not sure if they are actually
Dbase files). When I need to append data (fields) to the files, I have a big
problem in that excel 2007 no longer allows save as / export to .dbf files.
If I try bring the data in MS Access and save as .dbf files, I have untold
problems with the GIS application... The only way I have been successful with
this is to find a user with an older version of excel, insert the data as
database columns and then save as .dbf
Any suggestions as to how I can get around this with out purchasing a
...Can Money Deluxe 2006 Read Money Premium File
Can Money Deluxe 2006 read/write a Money Premium 2006 file?
In microsoft.public.money, Bob Mc <Bob Mc@discussions.microsoft.com>
>Can Money Deluxe 2006 read/write a Money Premium 2006 file?
...How to playing AVI file....
Could anybody please let me know how to play an "AVI" file in MFC
Dialog base application.
Thanks in advance....
Look at codeproject/codeguru for samples:
Ajay Kalra [MVP - VC++]
"Mujtaba" <email@example.com> wrote in message
> Could anybody please let me know how to play an "AVI" file in MFC
> Dialog base application.
> Thanks in advance....
You can use a CAnimate...CFtpFileFind::FindNextFile() can't get the correct file name.
Once I want to get file from HP-UX by FTP. I use MFC
CFtpFileFind to find the files under a specified directory
in HP-UX, but the return value of CFtpFileFind::GetFileName
() is not the correct file name, it includes time
(sometimes and date) ahead, such as:
but the real file name existed are only Mydemofile001.txt
Is there any problem in the low level encapsulated by MFC
for FTP list files? Could anyone give me some advice?
...Distributing Mulit-Event ICS file
I would like to email a file to my group, have them click it, and have it
update their calendars in Outlook with multiple events. Is this possible?
It depends on their version of Outlook. Older versions of Outlook can't use
multievent ics files.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE...Outlook crashes when attacthing files over the network
A user at my company tries to attach documents etc on a
netowrk share. Everytime she goes to do this, Outlook
She's running Outlook 2000 Premium with SPK3 installed.
...Wanting to grab group of files and PkZip them.
I have an excel file that has two columns, Code and Filename.
I would like to be able to select all files with a specific Code and have
them zipped into a file that is named the same as the Code. i.e. Abc.zip
would contain 123456.txt & 123457.txt AND Def.zip would contain 123458.txt &
The file names are actually quite random but they are associated with
specific codes according to this Excel file.
I am creating an Access form that will allow users to browse to the Excel...Inserted sound files won't play
I've seen this reported a few times on Google Groups but no definitive
I have PowerPoint 2003
I have inserted a .wav sound into slide 2 of my presentation
I clicked Insert>Movies and Sounds>Sound from file
In the Browse window, the sound won't even play in Media Player if I
right-click it and choose Play
From Explorer the same sound file plays fine
I have tried converting the sound into other formats such as MP3
I have tried different sound files
The icon appears in the slideshow but doesn't play
I have set it to play 999 times and not to stop when clicked
I have...How to stop a file from opening when XL starts?
This isn't as easy as you may think.
I'm running XL2003 on Windows XP home and have a strange problem. When
I start XL it opens with a file named chart 1 gif 1.gif. I have looked
in the XLSTART folder but there's nothing in there, I do not have
anything in the folder to open files from upon starting XL either. I
have searched my hard drives for a file named as such without luck.
While testing I tried saving the file as chart 1 gif 1.guf to see if I
could find out where it was stored unsuccessfully, so now I get both
of those files opening each time I start XL, but their is n...How do I set Save Options?
I'm working with a Excel file created & saved on a secure network site by
another user. I wanted to reset the save options for this file so I clicked
File/Save As/Tools and expected to see General Options as a choice to choose
to set the save options. General Options was not displayed. I chose
properties under the Tools dialog box, set my ID as owner and gave my ID full
permissions and then saved the file. When I tried to reset the save options
again I still do not get the General Options dialog box. I have no trouble
performing this task with other files. Help!
I couldn...Insereting .png files
Outlook 2003, of Office Pro 2003 -
When I want to insert a .png photo, the dialog box always displays .gif,.jpg
files in the folder. I always have to change the file mask to "All Files"
to see my .png file.
What is the registry setting that controls the default file mask so I can
add .png ?
Just typ *.png in the box
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office XP CD slipstreamed with Service Pack 3
"Richard Fink" <firstname.lastname@example.org> wrote in message
I noticed that my .stm file is named priv1.edb.stm and its suppsoed to be
priv1.stm I think when we setup the exchange 2003 box and moved the database
file to a different drive we coppied the path for the exchange database .edb
file and we pasted this path in when pointing the .stm file so this is why
the file is priv1.edb.stm
So Can i rename the file to the correct name (priv1.stm) without losing any
On Tue, 6 Feb 2007 18:37:00 -0800, skip
>I noticed that my .stm file is named priv1.edb.stm...unknown files
I'm a newbie to programming but very much willing to work hard and
try. We have about 100 servers and on each servers we have the g
and e drive. early this year there were some temp files dumped all
over the 100 servers under variuos folders and subfolders so i have
been assigned a task to clean this up. Any chance someone can guide
in getting an automated script where all i need to do is enter the
list of servers and the file extension to search and then script
scan for the file extension on all 100 servers and each of the drives
associated with it. T...