750 KB file saves 10 times longer than a 900 KB file
We use a spreadsheet in our office that has numerous macros. This spreadsheet is approximately 750 kb. I created another file with no macros that is about 900 kb. The 900 kb file saves enormously faster that the 750 kb file with macros
I spend a lot of time waiting for these files to save all day long. I have tried moving the macros to another sheet to see if that would help - but it only helped minutely. I have no add-ins checked (I saw that suggestion on another post). Any suggestions are hugely appreciated. Thank you.
I've never noticed a difference in time based on if a workbook cont...Box when opening File
Quick question...When I open up one of my saved files,
Visio automatically puts some kind of box (function box
possibly) around my heading and some of the text. I'll
take it off and save and it isn't there. But when I close
the file and then open it up again later it's there
again. I try to delete the box but it deletes my text
with it. I can't resize or delete the box (actually
conjoined boxes) by itself.
Any help would be greatly appreciated. Feel free to
Try changing the line weight of the shape to none.
John... Visio MVP
Nee...Email addresses in a comma-delimited (CSV) file
I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.
First, hyperlinks are not just formatting. The Insert|hyperlink style of
hyperlinks are objects in excel.
Second, CSV files are plain old text. They don't hold these kinds of objects.
(And they also don't contain any formatting properties, either.)
But third, you may be able to cheat a bit.
Can you go back to the othe...Export data in XML through Web Services
I have a WebMethod that retrive data from a DB and I want to return this
data in a XML format.
I try to do with the TextWriter class but I wasn't able to do, because I
didn't found any example thet explain how to use the Stream attribute.
Can I use the TextWriter or I have to use the XmlDocument class?
Thanks in advance
can you show us the code now, and
show us what you are getting on the wire
and show us what you would like to get on the wire?
http://www.15secon...Problems saving excel file from outlook
I have an EU that whenever he saves an excel file from
outlook, it will rename the file (by adding the number "2"
at the end of the file "file2.xls") and it also changes
all the embedding links in the document. (The embedding
link of F:\users\file.xls changes to c:\documents and
Are you setting a Hyperlink base for your links? See Menu
> File > Property > Summary tab. Put the original folder
location there and when you move or save the file the
links will not be renamed. Also assigning a letter to the
drive can cause problems (not ...pdf. file
Someone has sent me an e-mail with a pdf file attachment.
For some reason, unknown to me, I can't open it. Any
suggestions, tips or clues???
thanx in advance
Do you have Adobe Acrobat/Acrobat Reader installed? If you save the file to
your hard drive, can you open it?
> Someone has sent me an e-mail with a pdf file attachment.
> For some reason, unknown to me, I can't open it. Any
> suggestions, tips or clues???
> thanx in advance
do you have adobe reader?
"deb" <firstname.lastname@example.org> wrote in message
news:0...Excel tab as windows
Is there a way while running Excel to be working on one tab and open another tab as a smaller window that is always on top. So I can enter information in both tabs without having to minimize, maximize, or switch back & forth?
you could align the windows so you can see both at the same time. But a
'always on top' option does not exist AFAIK
> Is there a way while running Excel to be working on one tab and open
> another tab as a smaller window that is always on top. So I can
> enter in...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...help attaching files
Using XP Pro and Outlook 2003.
For some odd reason, I am unable to attach files when sending emails.
Click on the 'paperclip', window opens to the My Doc folder. then when I
click on a sub folder to open, nothing happens... finally, a Microsoft Word
window opens that it is unable to open....
It is almost as if it is trying to launch Word to open the folder...
FWIW, from the Microsoft side a new Knowledge Base Article (KBA) was
released on Apr 15th.
It lists two known conflicts so far....Transferring contacts from OAB file
I am trying to transfer the entire GAL from a work PC to a home PC.
I copied the oab, ost, and pst files to an external harddrive but have
not been able to open the offline address book in Outlook at home. The
pst opens fine.
Any assistance or ideas appreciated.
Love your attempt in regards to the oab/ost, but take a peek at
<email@example.com> wrote in message
> I am trying to transfer the entire GAL from a work PC to a home PC.
> ...Converting Eml files to Msg files with code
Sorry if this question is overly simple. I'm developing an integration
project between Exchange and SPS. I read the message on a public folder of
Exchange with ADO. I use ADO's stream object and save the message as a file.
Created file formatted as .EML file and has .EML extension. We want to read
this file in Outlook but it can't open the file. Because of this I need to
format this file as .MSG file. I don't need a tool. I should make this
process in code. Is there any API or code sample. Thanks in advance.
...Exporting distribution lists
Is thee any way to export distribution lists into
something like a spreadsheet?
Which version of Exchange are you using? In 5.5 it is easy to do. 200x is
not as easy, but doable.
"Elbryyan" <firstname.lastname@example.org> wrote in message
> Is thee any way to export distribution lists into
> something like a spreadsheet?
Do you keep all of your DGs in one OU? If so you can easily use LDIFDE or
"Elbryyan" <email@example.com> wrote in message
news:483201c4a09c$dd0a524...how do I get old versions of modified files?
I made a mistake and modified a file, how do I get back the old version? Thanks
From your backup, which, of course you take every evening !!!
"Power Image" <Power Image@discussions.microsoft.com> wrote in message
>I made a mistake and modified a file, how do I get back the old version?
...Open & update another file (through macro) while running macro
I am using MS Excel 2003 and I need help to solve my problem.
One excel file (suppose A.xls) in which I’ll update my graph and the data is
available in another file (suppose B.xls). What I am doing (through macro) is
that I have created one button (in A.xls) and when I pressed it; its open the
file B.xls (the data file) and at their I select month from drop down from
which its update the pivot table based on the selection month and then same I
was doing with another data excel file (suppose C.xls).
Is there any solution that when I pressed button from file A.xls its ...Can't open Money file directly.
I have Money 2005
I have many accounts at different banks.
I can always open Money by using my password.
I just added a new account & it tried to hook it up with Net.Passport.
Now everytime i try to open my file it wants my Net.Passport.
I deleted the new account,but it still opens with Net.Passport.
I went into tools & selected to remove my accounts from Passport's server.
Still can't open Money file directly.
How can i get it back to just open my account from my PC ?
In microsoft.public.money, desgnr wrote:
>I have Money 2005
>I have many accounts at different bank...Updating .nsf lotus notes server file
Using the below code i can fetch data from the .nsf file kept in the server.
Dim LotusWizard As DAO.Recordset
Dim session As Object
Dim notesdb As Object
Dim notesView As Object
Dim NotesEntry As Object
Dim notesdoc As Object
Dim Item As NotesItem
Dim doccollection As Object
Dim datetime As NotesDateTime
i = 0
Set session = CreateObject("Notes.NotesSession")
Set notesdb = session.GetDatabase("Server", "path\file.nsf")
'Check if open
If notesdb.IsOpen = True Then
...Working with recovered Money files
Does anyone have advice or experience working with Money files recovered
through a complete format restore recovery? I have recovered 68 .mny type
files from a Harddrive that had a PC restore image overlayed on it.
This was MS Money 2007 under Vista Ultimate.
The recovered files are semi-genericly labeled with "Recovered_MS-Money_##"
they just show today's new save date and range in size from 60KB to 23,300KB.
When viewed in Wordpad the largest files have an opening line that says
"MSISAM Database" before the gibberish code begins.
I tried the Money standard r...Disable password protection on .pst files
Just wondering if there is a registry key change or something I can do using
the orktools that will prevent users from applying passwords to their .pst
files. This is at the request of our legal department who is concerned that
users may leave and their case files and such are now inaccessible to
Mary Patricia <rodgers.patricia@> wrote:
> Just wondering if there is a registry key change or something I can
> do using the orktools that will prevent users from applying passwords
> to their .pst files. This is at the request of our legal department
> who is ...Prompt for Save when closing a file
Excel used to prompt me to save my files, and now it is just closing them
without saving them. How do I get the warning to appear again?
...Page header or footer longer than a page. File 794368d5a91da8.rpt.
Anyone seen this before? It only happens when trying to run the report via
the CRM interface. The report ran fine last month. It's a copy of one of
the canned pipeline reports that comes with CRM, with a date filter applied.
Report has no parameters, just a filter. The report runs fine in Crystal.
i saw this a few weeks back and restarted the crystal services to get rid of
Microsoft CRM MVP
"Jeff Metcalf" <JeffMetcalf@discussions.microsoft.com> wrote in message
news:E8B9A1DD-777D-4746-A333-392955F912...Excel attachment file names change on their own!
Using Outlook 2003, XP & Office 2003.
I have to send a bunch of Excel files (typically around 10) to a
supplier every week. They are sequentially numbered (purchase orders)
and the order number is part of the file name.
I attach them and everything looks fine. Then I send them and look in
the sent box and one or two of the files will have renamed themselves
using the names of other files! So if they were numbered 1 to 10,
they would have changed to 1, 2, 3, 3, 5, 6, 7,7, 9, 10 for example.
If you open the attachments, they're fine - depite the name change,
the conten...Data files
What is the difference between the **.mbf and **.mny files?
In microsoft.public.money, duhmel wrote:
>What is the difference between the **.mbf and **.mny files?
*.mbf is Money Backup File.
You cannot do salv.exe or standard repair directly to a *.mbf file.
...What is the file called which holds outlook express email?
I'm trying to migrate my old Win98/Outlook express email
system to WinXP/Outlook. I don't know what the file is
called which stores all the email I have saved over the
last few years...
>I'm trying to migrate my old Win98/Outlook express email
>system to WinXP/Outlook. I don't know what the file is
>called which stores all the email I have saved over the
>last few years...
It will either be a xxx.pst or a xxx.ost. Do a search on
your hard drive for *.pst and it will show you where your
file is located.
...Rounding difference in Access 2003 text exports
We're finding rounding differences when exporting Access 2003 data to text
files - about $4000 difference from the original Excel Worksheet. # lines -
Original Dollars - $800,000,000 +. Access export is under by about $4000.
Floating decimal in original Excel data, which is imported to Access and
seems not to lose any data, more divisions and calculations are done driving
the dollars out to a large customer base. Before exporting, data is summed
and foots to the original $800MM+. Data is exported using Export Wizard as
comma delimited. I wonder - are ther...CPropertySheet Help button fails to launch chm file.
I have a application built around a CPropertySheet derived class. The help
button is looking for 'app.hlp' file (this is the default MFC stuff, I've not
added anything other than moving the button). How do I get it to look for a
'app.chm' file instead?
I've tried the following using a test help file.
Iin the CWinApp derived constructor:
and this in InitInstance():
//First free the string allocated by MFC at CWinApp startup.
//The string is allocated before InitInstance is called.
//Change the name of the .HLP file...