Recent content by alchohaz

thread965-1603533 as a continuation of the thread listed at the start... I found this online which looks to be a pretty comprehensive Overview - dated 2010 http://www.siemens-enterprisehipathdx.com/pdf/dx_product_guide.pdf Just thought i would share.....

Hi Combo Getting there - thanks for your help :) =SUBSTITUTE(CELL("address",OFFSET(G106,0,3)),"$","") Cheers Al

Combo - AWESOME, been looking all over the net for a fix Next step for me is to increment the reference cells, and concentanate to create a more complex formula. I have done it before but need to dig out - if you have a quick idea then great - please :) Example First cell will be A1 using...

Hi all Hopefully a simple one for you :) I am using the formula/function "CELL" as follows =CELL("address",A1) However it is returning and absolute ref "$a$1" when i need "a1" - please advise me how to implement Thanks in advance Al

OK - thanks for the information :)

This is purchased from you provider and/or maintainer. How old is your system? If it is circa 10 years old, have a look around the Telecoms area for some large Blue Ericsson Folders - the O&M manuals with have details on the command structures and what they do. BE CAREFUL - IF YOU ARE UNSURE...

Hi All A bit of guidance please re voicemail on the SX2000 Light system. I beleive we are using a built in voicemail system, is this likely - does the system has this capability (built in voicemail)? 1) If it does - can it autocopy messages to other mailboxes? 2) Can Multiple extensions be...

Thanks for your Help Combo What the correct syntax for applying part 2 of your 2nd post? Also is there NO WAY to set a Varaiable as the current open file name without the "GetOpenFilename" or "GetSaveAsFilename" as per my original post? Thanks All :)

Thanks Combo, i will try that and see how i get on, but i would guess that if working between 2 workbooks, that would only apply to the one active at that instant. Can i use the snapshot to set a variable? ie, can i set ThisWorkbook as a variable - if so would you mind showing me the syntax...

Hello All i am trying to set the open workbook name (Full Path) as a varible but seem to be coming up against walls every time i search foe the info. I don't want to open any dialogue boxes as in "Application.GetOpenFilename" or "Application.GetSaveAsFilename" Am i confident that this should...

Skip - i have it working - thank you :)

Skip i did, but to me as a novice this was not clear - thanks for your input, it is always appreciated. In my defence what i was actually after was the cause of the issue - this was working last week (as Value = FormatDateTime(Now, vbGeneralDate) and now for some unknown reason it has changed...

Code is as above in the following context: If Application.Dialogs(xlDialogSendMail).Show("abc.t.com ", Subject) = True Then Range("Completed").Value = FormatDateTime(Now, vbGeneralDate) End If But i have now managed to get it to work as follows: If...

Something very suspect happening here - i changed the regional settings to US and ran the Macro - this resulted in the correct information being displayed !! I changed it back to UK setting ran the macro again and they are now incorrect !! Any tips please ?

Thanks PHV - that will work on my code but i want the hours mins and seconds too, i am guesing i can just add that as if it were a custom date/time - i will have a play to resolve that. However it doesn't fix my overall problem which is also reflected when i enter a date using a form i have...