I don't have a hotline to Microsoft or a pre-alpha copy of Excel 2020, but I was thinking about where Excel might be headed over the next few years and came up with 8 bold predictions.
What do you think? Do you have any other predictions/ideas about where it could/should go?
http://www.accessanalytic.com.au/pdf/20120601Ar…tureofExcel.pdf
Posts by jgrob3
-
-
A client of ours has one particular file that has some very strange
behavior as described below. This only occurs with the one particular
file and the behavior is consistent across different PC's in both their
office and ours. All other Excel files in both offices work fine.Here's what happens:
- you can use Windows Explorer to copy the file between drives without
a problem (as expected)- if you open the file in Excel on one drive then save it back to that
same drive with either the same file name or a different file name, the
file works fine (as expected)- if you open the file in Excel on one drive then do a "Save As" to
save it to a *different* drive with either the same file name or a
different file name (in default .xls format), the new file causes
errors in Excel every time you open it as per below (weird!)- even if you do a "Save As" and choose a different format eg Excel
97-2003 or Excel 95, the error behavior is consistent (weird!)What happens when opening the Save As version is:
- you open the file (using either Excel or Windows Explorer)
- the Enable Macros dialog box appears twice (with non "save as"
versions, this only appears once as normal)
- an error message appears stating that:
"Errors were detected in the file but Microsoft Office Excel was able
to open the file by making the repairs listed below. Save the file to
make these repairs permanent."In the error log txt file, we get:
"Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and Settings\Jeff Robson\My
Documents\test.xls'
The following is a list of repairs:Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted."When Excel "repairs" the file, it strips out all the formatting and
formulas, leaving you with just a series of sheets with hard-coded
numbers (not a particularly useful repair job!).We're running Excel 2003 on WinXP (SP2) however the behavior is
consistent on Excel 2002 as well (haven't tested other versions).Any ideas? Anyone seen this kind of behavior before?
Weird!
Jeff Robson
http://www.mailbarrow.com -
Hi AJW
I'm still looking around for some help in this area so let me know if you're interested or know of someone that might be suitable.
Thanks
Jeff
-
Can you bring me a drink from the fridge next time you're walking down the 200km hallway? :spin:
My personal favourites are the Paperclip, Chartadelic, or the frickin' laser beams. :biggrin:
-
-
Glad you liked it! That seems to be a favourite with a few people
Thanks for the suggestion Pesky! That's a good one!
I have a few more that I'll be putting up in a little while so will try to include this one as well!
Thanks :yes:
-
Mailbarrow has just launched a new page full of funny e-mail-able Excel Geek E-Stickers! :spin: Cool! :tumble:
"What's an E-Sticker", you ask? Good question!
An E-sticker is a bit like an online greeting card (or "e-card") in that you can personalise it and e-mail it to your friends. Except an E-sticker is better than an e-card because you can actually print it out! And ... if you print it on sticky paper, you can actually create a real live sticker that is perfect for your PC, car, bike, wall, fridge, washing machine, or pet. OK ... maybe not the last one!
Anyway, have a browse and hopefully a few laughs too! Feel free to send them to any Excel geeks you know ... or just print them for yourself! We sure had lots of fun putting it together ... yes, we have a very strange sense of humour.
Enjoy!
http://www.mailbarrow.com/postcards.phpJeff Robson
Mailbarrow -
Sorry - I should have read the full text of your post before replying!
Unfortunately, I don't have Notes installed on my PC so I can't give you the exact answer.
However, the following url's should be helpful for you:
http://groups.google.com/groups?hl=en&l…Bemail%2Battach
http://groups.google.com/groups?hl=en&l…Bemail%2Battach
They seem to have quite a bit of useful info there. You'd think it would be quite a simple thing to do!
The examples they show all require the filename to be passed as a string to the functions so you may need to modify them slightly if you want to attach the active workbook.
I don't know whether you could simply specify the ActiveWorkbook name or would need to use ThisWorkbook.FullName as the argument.
Hope this is enough info to figure it out.
Jeff
-
I can't say I've tried this but here's a solution I found elsewhere:
Public Sub SendMail(strAddressee As String, strSubject As String, strBody As String)
Dim objNotesWS As Object
Dim notesdb As ObjectSet objNotesWS = CreateObject("Notes.NotesUIWorkspace")
Set notesdb = objNotesWS.COMPOSEDOCUMENT(, , "memo")
notesdb.FIELDSETTEXT "EnterSendTo", strAddressee notesdb.FIELDSETTEXT
"Subject", strSubject notesdb.FIELDSETTEXT "Body", strBodynotesdb.Send
notesdb.Close Set notesdb = Nothing Set objNotesWS = Nothing
End Sub
Hope this helps!
Regards
Jeff