Macro must return the name of the buttonHi 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?
>
&...
outlook 2007 runs slowHi
Outlook 2007 runs slow. Is there a way to speed it up.
Thanks
Do you have the outlook performance update installed?
Are you using a Dell laptop?
Did you upgrade from an older version and are still using that profile?
http://www.slipstick.com/outlook/ol2007/slow.htm - install the update
listed at the end - also make sure all OS and Office updates available
through Microsoft update are installed. If it's still slow, try the various
solutions that apply to your situation.
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Ta...
Emailing in excel 2003 02-26-10If 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...
Opening a new instance of ExcelI 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 ...
Importing Data into an Excel Pivot Table via AccessI 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 FilesHi,
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 & minsI 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...
EXCEL TROUBLESHOOTING #2I 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 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.
...
Exchange 2007 Evaluation version #2Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
wrote:
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
...
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...
Excel CrashI 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?
...
Wrapping clipart around textWhen 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 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.
...
Excel ignores boot-time regional settings when interpreting a dateI 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...
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 ...
connect a form to excel databaseI 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...
In Excel program shows a broken line and don't know how to get ri.I am trying to put in entries in Excel program and when I go to Print
Preview, it only shows part of the entries I put in. When I go to the last
entry that it shows in Print Preview, there is a broken line between it and
the next entry. I don't know what I did. I could use some help
You probably have multiple areas selected for your print area.
you can check this by <view><page break preview>
One possibility to correct this would be
<file><print area><clear print area>
or specifically select the area you want printed and
<file ><Print area>...
Excel Cells Contents to HTML Pages
Hi,
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTML page.
HTMLCode clumn has actual HTML Code like:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...
macros disabledI've just upgraded to Office 2007. Now, when I tried to run a program, it
says, "The macros in this project are disabled." What to do?
Thanks,
Scott
I've got it. It was due to the "Missing" references. Mr. Chip Pearson helped
identify the problem.
"Scott" wrote:
> I've just upgraded to Office 2007. Now, when I tried to run a program, it
> says, "The macros in this project are disabled." What to do?
>
> Thanks,
> Scott
Just as with 2003 you need to enable macros. But, unless the VBIDE is open,
you don...
Office 2007 Compatibility Pack 12-10-09My new Windows 7 laptop came with a trial version of Office 2007 (Student),
which I uninstalled prior to first use. However, I have the PowerPoint
Viewer installed, which I use. Question: There's a huge 173 MB Office
Compatibility Pack in the Control Panel, Programs and Features, which can be
uninstalled. Can I uninstall this without any effect on the PowerPoint
Viewer or Microsoft Works (or Windows Live Mail) programs? Thanks.
EW
Hi, Lone Star,
The compatibility pack is actually quite useful if you are running a
previous version of Office. Are you only using W...
Question Regarding Excel 2007 Formatting Corruption #2Hi Folks,
I am having a problem with Excel 2007 files losing all formatting
(merged cells, colors, borders, and data formatting (99% turns into
0.99)) when I open a file on our office server make edits and then
save the new file on the server. Each sheet usually has a mix of
locked and unlocked cells and I unprotect the sheet to make edits.
Also, something is fundamentally changed with the file as its size
doubles or triples. If I reopen the corrupted file and redo any of
the formatting and try to save it none of the new formatting is
retained either. Has anyone else ever experienced a pr...
Convert Date to TextI want to use a date field to produce an invoice number.
Can anyone tell me how to enter a date in a date formatted field e.g.
31/12/06 and have "061231" appear in another cell, but formatted as text?
(It needs to be text because my next stage will be to add the first three
characters of the company name [concatenate], which I'm OK with.
Thanks
Jeff
Jeff,
try this:
="ABC"&TEXT(A1,"yymmdd")
where your date is in cell A1 and your company initials are ABC - you
could get these from another cell, eg B1, so the formula becomes:
=B1&TEXT(A1,&qu...
Macro Help #11Hello,
Need help with a Macro. I have a work book with multiple sheets. I need to
make a master sheet from all the others, that will combine all the data. The
first column of all the sheets contains the product model number and how all
will be organized. Also if possible, when master sheet is made, can the
information be assorted ascending and also if duplicate data can be removed.
Thanks for any help,
JR
...