Reply:

can't send anything in Outlook 2002
I just sent a post asking for help because I can no longer send email with attachments. After sending in the post, I went back to Outlook and clicked on the Send/Receive button just to check if I had any new mail. I got the same message: "The operation failed". So I am totally out of business with Outlook. How to solve the problem? Marilyn Did it work before? Did you change anything in yr settings? Are you sure your internet mail account settings are valid (correct username, pw, smtp/pop3 servers)? ------------ "Marilyn Fogelquist" <fogel@cablespeed........

Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it possible to email to the address of what ever is in A34 is? The email body should say: this has been submitted for cell B34 and todays date. Thanks. Check out Ron De Bruins "Send-Mail" tips: http://www.rondebruin.nl/sendmail.htm Micky "Neil Holden" wrote: > If i type in the cell A34: neil.Holden@test.com and press a button is it > possible to email to the address of what ever is in A34 is? > > The email body should say: this has been submitted for cell B34 and...

Macro must return the name of the button
Hi there, I want to a macro to display the name of the button (or object) from where I am calling that macro. Anyone an idea? thanks, Derek What sort of button (userform, worksheet forms, worksheet control toolbox)? -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Derek Brussels" <Derek Brussels@discussions.microsoft.com> wrote in message news:8441F83B-89DC-4515-A643-CE8F258DFC1F@microsoft.com... > Hi there, > > I want to a macro to display the name of the button (or object) from where I > am calling that macro. Anyone an idea? > &...

Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400 server. I have created pararmeters within Access which asks for certain fields which works. I then go into Excel and create a pivot table with the external data source that I have created in access. When I go to enter a pararmeter within Microsof Query I get a reply saying that "Parameters can not be used with this Query", what I want to do is setup a parameter on the Excel spreadsheet which then goes and gets the data i require from this parameter. I would be very grateful if someone could help me with thi...

VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add. I avoided using them because I'm not sure how/why they are created - i.e. maybe some user's defaults would only create 1 empty sheet or none. So, form MS Access's VBA I'd like to do: On Error Resume Next .Worksheets("Sheet1").Delete .Worksheets("Sheet2").Delete .Worksheets("Sheet3").Delete .Worksheets("Sheet4").Delete On Erro...

Illegal operation error while printing EXCEL or WORD Files
Hi, I am facing an illegal operation error when i try to print any file from excel (any no. of pages), this happens in stand alone printer as well as a networked printer. When we press the print button, it flashes this message, but still prints, but once the printing is completed, i will have to restart the PC. Due to this error other applications PRINTING also will NOT HAPPEN and the only way out is, restart the PC. This happens not only in EXCEL, it happens in all the MS applications (outlook, access, front page, powerpoint also). When I check the print manager (before restart),...

how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break, then a time when I leave work. Following that I want to be able to add up the amount of hours that I have worked. This will enable me to plan my week ahead and ensure I only allocate a specific amount of time to a project. http://www.cpearson.com/excel/datetime.htm#WorkHours -- Kind Regards, Niek Otten Microsoft MVP - Excel "Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message news:37D03D72-5525-4D6E-8ED7-2911B16248B0@microsoft.com... >I want to insert a time when I start work and...

Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is there a setting that I can use so that it opens each new excel file in a new excel window so I can drag different ones to each monitor? Is there a similar setting for Word? I am using Excel 2002 and Word 2002. Thank you. Hi, Yes, you can check the Windows in Taskbar checkbox in Tools; Options. This is on the View tab for both Word and Excel. >-----Original Message----- >I am using multiple monitors for work and it is great! Is >there a setting that I can use so that it opens each new >excel file in a new excel ...

Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me what keystroke allows me to edit a cell? Before I switched to a Mac it was the F2 button. Please help. Thank you. See the answers in the m.p.mac.office.excel newsgroup. In article <1176582208.958694.269620@q75g2000hsh.googlegroups.com>, ssears@indy.tds.net wrote: > Switched to Microsofts version of Excel for Mac. Can anyone tell me > what keystroke allows me to edit a cell? Before I switched to a Mac > it was the F2 button. Please help. Thank you. ...

EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a number of changes is causing me problems when I re-open the file. Windows task manager goes to 100% CPU activity, and i cant do anything within the excel file. However, if I set recalculation to manual before I open the file, all seems fine. Obvioulsy I have a problem. But how do i find that problem ? Thanks in advance. I have had some experience running large spreadsheets lately. Above a certain size, the recalculation time seems to climb very fast. While Excel is recalculating, you can't do anything anyway. Best in my v...

Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump drive so I can work on them at home. I attempted to work on a Word documents which had an Excel worksheet inserted in it. I tried double clicking on the worksheet to edit it and Word and Excel shut down. Now when I attempt to open Excel at home it asks for my Office XP Professional installation cd. (I have Office XP at home with Windows XP). I'm having a hard time locating my original discs. Does anyone have any suggestions or experience anything like this? ...

worksheet size in bytes
Hi Everybody, is there any algorythm/function to know the size of given excel worksheet in byte? Tamas -- Tamas Nagy ------------------------------------------------------------------------ Tamas Nagy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28000 View this thread: http://www.excelforum.com/showthread.php?threadid=475020 I think you'd have to save the worksheet in question as its own workbook. While you could add up all the characters in all the cells that's only a part of the picture given that many other things are part of the sheet, fo...

Default font for PowerPoint slide
PowerPoint Office 2001, Mac OS 9.1 Is there a way to set a default font so that every time I choose a blank presentation from the options shown in the "new slide" box that appears, the default text font and its various attributes will be as I want them -- say, Arial 24 pt. Right now every time I open a new blank slide, the default text font is Times 24 pt. How did it get to be that? Thanks for your patience - you can see that I don't use PP very much. :-/ I've also posted this to the microsoft.public.mac.office.powerpoint group. -- -Barb, <www.jamlady.eboard.c...

Wrapping clipart around text
When i word i can wrap my text around my pictures is there any way of doing the same in Publisher 2000. -- Thank you for reading my post. Hopefully you can answer my querie On the toolbar there is a hand holding a script. This is the wrap tool. Select the object, select the tool. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Shazza" <shazzalowe@hotmail.co.uk> wrote in message news:474A689F-DC18-4545-A73B-1E2CDDB34633@microsoft.com... > When i word i can wrap my text around my pictures is there any way of d...

Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other templates not available in Excel today - speedometer charts, multi-dimension comparitive charts, charts that build information overlays. I regularly create these in a manual way for executive and customer summaries but would appreciate the ability to automatically generate these types of charts allowing for real time viewing of "what if" scenarios. Steve, there are tons of these things out there to review, few better than this collection: http://www.andypope.info/charts.htm Andy Pope has put together...

connect a form to excel database
I have a database in excel which lists our stock and prices etc. I would like to be able to enter a stock number on an invoice that will retrieve the details and price from my excel database. Can this be done? Excel has built in option--try data|form. If that doesn't quite work, but it's close, John Walkenbach has an enhanced dataform at: http://j-walk.com/ss/dataform/index.htm And if you want to design your own, Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html Kathy wrote: > > I have a database in excel which lists our stock and p...

Debugger comes up when attaching files to Outlook 2002
I have a pro bono non-profit client running win xp sp3 & ms office pro. Last week she reported that every time she tried to attach a file to an outlook email, she received a dialog asking her if she wanted to start the debugger. It never allows her to attach the file and if she goes through with starting the debugger, she gets a variety of errors... never a repeating error. Anyone have any experience with this error? Michael ...

Outlook 2002/XP Folder List view question
Any assistance would be greatly appreciated. I have a user still using Outlook XP and has the following issue. Outlook does not remember the folder view settings. User has folders under the Inbox folders and of those folders some are expanded and some are collapsed. When he closes Outlook it does not "remember" the folder settings. The user would like for Outlook to remember the settings because it has in the past. Is there a way I can get this back? Thanks ...

Does anyone know where I can download EXCEL.MSI?
I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3 without this file. ...

Money 2002 Can't seem to download sucessfully
I have been trying for 10 days now to download banking info from my various accounts into Money 2002. Before it worked, now for some reason it is showing that it is downloading, but doesn't import into the Money program. What happened? I created a Passport to work online, but that is the only thing that has changed on my end. Can someone please help me!!?!?!?!??! >-----Original Message----- >I have been trying for 10 days now to download banking >info from my various accounts into Money 2002. Before it >worked, now for some reason it is showing that it is >dow...

Excel to check for regular expression?
Hi, How do you use Regular expression in excel? For eg: Check a column of data to see whether are all of them valid email addresses? Please advise THanks By valid, do you mean that the email is in proper syntax or that it is an actual email address. Text formulas can be used for proper syntax. Perhaps a Visual Basic proceedure. I doubt you can check that the email address actually exists, as many companies and ISPs will simply disregard and drop mail to invalid email addresses to eliminate spam "user" wrote: > Hi, > > How do you use Regular expression ...

Excel ignores boot-time regional settings when interpreting a date
I have a third party DDE app that exports dates as strings, correctly using the short date format in the regional and language settings, which, in my case is MM/DD/YYYY (reset at every boot). Unfortunately excel insists in interpreting that date as DD/MM/YYYY [Application.International(xlDateOrder)=1, it should be 0], disregarding my regional settings. The result is that all the dates are wrong or #VALUES! If this is not wierd enough, listen to this: it only happens after I reboot (when the date format is reset to MM/DD/YYYY). If subsequently I change the short date format in the regional se...

deleting fonts
My computer uses Vista Home Premium. I just had to reset it to its original state. I'm trying to delete fonts, but don't have permission. I am the only user of this computer and its administrator. When I've gone into the Fonts folder Properties - Security tab, the option for Special permissions is grayed out. When I click the Advanced option ("For special permissions or advanced settings, I don't know what to do next. Can someone please walk me through how to get permission in the Fonts folder so I can delete fonts? Thanks Kelly On Wed, 6 Jan 2010 07:...

powerpoint texbox issue
Sorry for posting this twice but I could not find my previous post, but I really need some help here. We have a ppt 2007 problem. The problem is on our CEO's computer too! We have ppt 2007 with all updates/service packs. The user will create a textbox in powerpoint and starts typing, then saves the ppt file. When the user goes back into the ptt file and clicks in the textbox and starts typing, "randomly" the font will increase and the user has to set the font back. Why Microsoft, why? This person uses powerpoint probably more than anyone at our company, sin...

How Can I Tell What Button Was Just Clicked?
I have a bunch of images on the sheet that calls ONE function. Is there a way I can tell which button was clicked within the function? I'd hate to make a function for each image. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ See one technique at your other thread. kenji4861 wrote: > > I have a bunch of images on the sheet that calls ONE function. > > Is there a way I can tell which button was clicked within the > function? > > I'd h...