Hunterfeedback368

Automatically send email message when folder contents have changed.
Hoping someone can help. We have a UNIX server on our network and anExchange 2003 server. Ideally we would like to have the Exchangeserver send an email to a group of users when a new file gets added toa shared folder on the UNIX box. The UNIX box is running VisionFS andwe can see the shared folder in our Windows environment.Ideally I would like to have the Exchange server send a messagewithout having to dedicate a PC running Outlook and a plug-in to thetask but will do so if necessary.Any thoughts would be appreciated... Script it, schedule it to run on any member server (good i...
Loop to retrieve value in worsheet A and put into worksheet B
I am hoping someone out there cyber-world can help me with some code that I need. I have a workbook from an outside source. I need to loop through Worksheet named 'Details', column A to find the characters 'C:' and return the value from Worksheet 'Details' , column B into Worksheet 'New Details', Column A. There are blank rows in the data and the only designation between what would be considered a new record is a series of dashes (14 dashes to be exact). Is Anyone able to help with this? Anything is greatly appreciated. Is there an...
'Auto-change' button
Hello...How to do auto-change button e.g.I have button ' Start' and when I press it, 'Start' has to change to'Stop' andwhen I press 'Stop', it has to change to 'Start'.'Start' and 'Stop' must be connected with different functions. >How to do auto-change button e.g.>I have button ' Start' and when I press it, 'Start' has to change to>'Stop' and>when I press 'Stop', it has to change to 'Start'.>'Start' and 'Stop' must be connected ...
Prevent 'Updated:' Prefix on Changed Meetings
Does anyone know how I can stop the 'Updated:' prefix from being added by Outlook 2003 when someone in my office sends me an update to a meeting? AFAIK, you can't remove that designation.-- Milly Staples [MVP - Outlook]Post all replies to the group to keep the discussion intact.How to ask a question: http://support.microsoft.com/KB/555375After furious head scratching, Don asked:| Does anyone know how I can stop the 'Updated:' prefix from being| added by Outlook 2003 when someone in my office sends me an update to| a meeting? ...
outlook changing event duration
All of my one day events have been doubled in size. I don't know what causes this. I go in and try to fix it, but then it happens again! Why is this happenning? I first noticed it after changing my time due to DST. Thanks.Paulette guillorypr wrote:> All of my one day events have been doubled in size. I don't know what> causes this. I go in and try to fix it, but then it happens again!> Why is this happenning?> I first noticed it after changing my time due> to DST. Thanks.That's why it happened.http://support.microsoft.com/kb/197718/EN-US/> (applies ...
Have templates changed in Word 2007?
Our office has recently upgraded to Office 2007. Previously when opening a template (in 2003) it would open and be named as, for example 'Document1' rather than the name of the template. So it would be opening a clean copy of the template rather than the template itself. Now in 2007, our Word templates seem to open either as a read only versions of the template or the template itself. How can I get our templates to behave as they did in 2003? Thank you -- Brendan Adelaide, Australia When you 'open' a template, you're opening it for editing. To create...
Changing the sender name in email
We have a user whose email address appears as mike <mike@pierxx.com> when sending mail externally and appears as mike when sending it internally. We are using exchange 5.5, sp4. We want the sender's name to appear internally and externally as (e.g.) Mike Firet (I understand that the external email will still have the suffix of the sender's email address of <mike@pierxx.com>. which is fine.) I have modified every tab I find that is remotely pertinant w/o success, and have tried it on a exchange 2000 test bench as well. Can this be done. Thanks in advance. (TIA...
Change User Name
How do you change the user name in outlook from example john@ibm.com to John Smith? Go into the properties for your mail account and change it there. If youneed help with that, we'll need to know your Outlook version.-- Jocelyn FiorelloMVP - Outlook*** Replies sent to my e-mail address will probably not be answered --please reply only to the newsgroup to preserve the message thread. ***In news:015d01c39bf6$969cbba0$a301280a@phx.gbl,Melanie wrote:> How do you change the user name in outlook from example> john@ibm.com to John Smith?...
Why formula doesn't change on column insertion?
Hello:I know I will feel stupid when I hear the answer, but...If I have a formula ( =average(a1:a5) ), and I insert a new column, the formula, being relative, changes to ( =average(a1:a6) ). This works fine in a test. BUT I have a working spreadsheet in which inserting a column does *not* change the relative formula. Why? I can't see anything different in my working spreadsheet...-- Fred Boer Never mind - resolved.-- Fred Boer'Fred Boer' <fredboer1@NOyahooSPAM.com> wrote in message news:uin$VfrDIHA.5160@TK2MSFTNGP05.phx.gbl...> Hello:>>...
Need ideas for a changing sort key
I need to create a form where someone asks tasks which have to be accomplished in order, the dates being irrelevant, though it will be tracked. What is the best way to create a field that will prioritize these in order? There will be many instances where a task is inserted or removed from the list. If I have steps 1 through 5 for example, and need to add one between 2 and 3, I don't want to have to renumber 3 through 5 as 4 through 6.It's a tool to train new employees how to do their job, the series of tasks will change from project to project so I'd like to create a ma...
multiple or changing colours in a data table on an excel chart fo.
We are trying to have the 'negative' numbers in a data table (under the chart) show in red, like the data series, but seem unable to alter the format unless it is for all data. (we're trying to highlight or bring attention to the negative variances) The data labels will follow the excel font's but the data table does not appear to.Any suggestions? Kerri,Unfortunately the formatting options for data tables are fairly limited. As a result, it's not possible to apply different font formatting to different cells or rows within any one data table. If you are usi...
unable to paste from clipboard
I am trying to copy a range as a picture from excel and paste that into a picturebox on a form.The code I am using to copy isGlobals.Profiles.Range('ProfileChart').CopyPicture(Excel.XlPictureAppearance.xlScreen, Excel.XlCopyPictureFormat.xlPicture)to paste the chart into a picturebox I first triedMe.PictureBox1.Image = Clipboard.GetImageThat did not work and then I triedMe.PictureBox1.Image = DirectCast(Clipboard.GetDataObject().GetData(DataFormats.Bitmap, False), Bitmap)that did not work either.I can paste the bitmap into any other application like word, excel or o...
If check box changes
Access 2003 On my subform I have 3 checkboxes format YesNo BBAll - control source BBAll default Yes BB1 - control source BB1 default No BB2 - control source BB2 default No and 2 textboxes TextBB1 - control source =DLookUp('[BB1]','[t000Facts]','[UnitID] =' & [UnitNo]) TextBB2 - control source =DLookUp('[BB2]','[t000Facts]','[UnitID] =' & [UnitNo]) If TextBB1 is null then BB1.enabled=false If TextBB2 is null then BB2.enabled=false this means if TextBB1 is empty then the BB1 checkbox selection is disabled(s...
Run Macro If Cell value = 'Other'
Alright, I have a very simple macro at the moment that unhides a columnand adjusts the print area to suit.What I need is a maco that will run this macro if the cell F4 = 'Other'from a drop down menu.Seems painfully simple I just can't find where it is.Cheers If Range('F4').Value = 'Other' Then Call yourMacro End If--HTHBob Phillips(replace xxxx in the email address with gmail if mailing direct)<bobbly_bob@hotmail.com> wrote in messagenews:1163993734.539069.261810@j44g2000cwa.googlegroups.com...> Alright, I have a ...
Combo No Change and After Update Event
I have a combo box where the After Update event of the combo box isused to reset another control on the form to Null.Sometimes a user will want to reconsider his/her choice in the combobox and make a different selection from what was there before. This isOK as it triggers the resetting of the other control to Null.My problem is - sometimes the user will revisit the combo box andexplore the other possible selections in the combo but eventuallysettles back on the original selection with the result that the AfterUpdate event is triggered and the other control value is scrubbed,which i...
Who is changing my #$@# mouse cursor??
I wrote a custom control. On portions of this custom control, I change the mouse cursor to the hand cursor. I do this by handling the WM_SETCURSOR message and calling SetCursor(). All appeared to be working fine til QA happened to notice that if they hold down ALT-Z (an invalid menu accelerator that just causes the OS to beep) while mousing over my control, it sometimes flashes the normal arrow cursor when it should be showing the hand cursor.I can't for the life of me figure out who is changing this... these are the steps I've taken so far:1) check, double checked and triple...
copying and pasting only non-hidden rows
Would anybody know how to copy an entire worksheet and paste values only to a new worksheet and include only visible rows (do not include hidden rows)Thanks,Jason Jason, you can do it with a macro, here is one waySub Macro1()ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisible).CopySheets('Sheet2').Select Range('A1').Select ActiveSheet.PasteEnd Sub-- Paul BAlways backup your data before trying something newPlease post any response to the newsgroups so others can benefit from itFeedback on answers is always appreciated!Using Excel 97 & 2000** r...
paste over a filtered range
I have a spreadsheet with 40000 records, I have filtered down to 1000 records that have one coloumn of incorrect information that needs replacing, how do I paste the new data over the old?? What keeps happening is the new data pastes over the first 1000 records, not only the filtered recorsds freddieWhen you have your filter in place and the 1000 records are showing, hitF5>Special>Visible cell only and OK.Now paste your replacement data.Gord Dibben Excel MVPOn Tue, 26 Apr 2005 15:36:02 -0700, 'freddie2711'<freddie2711@discussions.microsoft.com> wrote:>...
Change format of one cell based on another
Hi.How do I change the format of one cell eg make the fill colour of cell A1 yellow, based on another eg if cell A4 is greater than 100%?Thanks. format...conditional formattin--Message posted from http://www.ExcelForum.com Thanks, but how do you reference another cell?>-----Original Message----->format...conditional formatting>>>--->Message posted from http://www.ExcelForum.com/>>.> in conditional formatting under condition 1 select 'formula is' and theput in the formula you wan--Message posted from http://www.ExcelForum.com &q...
Unable to access folders after changing mail server
Hi,I am using MS outlook 2003(win xp) with lotus notes connector toaccess my office mails. Everything was working properly untill Ichanged my mail server to a new one. The nsf file was also copied tothe new domino server. But after this my outlook stopped working. Itshows below message while trying to access inbox.'Cannot start Microsoft Office Outlook, Unable to open the Outlookwindow.The set of folders could not be opened. The server is not available.Contact your administrator if this condition persists.'I deleted and recreated my outlook profile,but the problem still...
Rank column with changing # of rows
Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws everything off. Please help :-) To modify the formula, you need to tell us what you want to happen to theformula when you add or delete rows.On Mon, 5 Jul 2004 07:10:01 -0700, Amy <Amy@discussions.microsoft.com> wrote:>Is there a formula that will Rank even when rows are added and deleted?Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throwseverything off. Please help :-)...
Can't change RIP folder
Media player will not allow mw to change the location of my RIP folder. No matter what folder I attempt to change it to I get a message stating that I don't have permission to use it. Any Ideas? You might be using the root of some drive as the rip folder. try to make a folder inside it and then try to select it. Or when starting Media player right click on the icon of media player and click 'Run as Administrator' and then try to select it. But if it works by the later suggestion then everytime you have to rip you have to run it as admin. Hope it works. Good Luc...
Changing Color in Cells
Is there an easy way to make a cell content change to a certain color?For example if you input say $2.00 into a cell can you have itautomatically become green?Can you do the same thing with the background color?Thanks Depends on how many rules you have and what version of excel you're using.If you're using xl2003 or below, and only have 3 rules (plus the normal look),you can use format|conditional formatting.The limit was increased in xl2007.John Ritz wrote:> > Is there an easy way to make a cell content change to a certain color?> > For example if you in...
Change Date Format #2
I'm new to Excel 2007. My problem is that I do not know how to stop Excel from automatically converting text to a date format. For example, when I enter data in a cell such as: Smith v Jones 06-91, Excel automatically changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains 06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91? '06' does mean June but it should stay as '06'.Thanks. > How do I stop Excel from automatically changing 06-91 to Jun-91? You can either precede the input: 06-91 with an apostrophe ('), or ...
copy and paste problem #3
When I copy a range of cells in order to paste it on another excelspreadsheet, some of the columns do not copy over because theycorrespond to functions that take in arguments from another cell. Howdo I copy the range of cells so that it copies the text that appear inthe cell and not the functions?-- chindo------------------------------------------------------------------------chindo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28669View this thread: http://www.excelforum.com/showthread.php?threadid=483835 did you try <pastespecial-values>...