Search results for query: *

Quick one.. Given one or more customer accounts, credit region groups, etc., what report from SAP 4.6 gives a list of customers with the field 'next int. review' date as per fd32 or fd33. thanks, medieval.

Hi, Ok, I'll keep it simple and you can ask me if you need more details... I have created a macro to tidy up, colour, currency change, date format a spreadsheet. This is then saved to the desktop. I have it so I am not prompted for errors. The spreadsheet saves, no problem. Albeit it doesn't...

this is entered in select expert as part of the formula editor. i'm trying to see if a discrete parameter appears in any part of a table.field, if so then i can include this in a gorup.

I'm using Crystal V10 and have entered InStr({CS_CONTACTS.EMAIL_ADDRESS},{?EMAIL_ADDRESS}) but this is treated like an array for some reason and a prompt denotes that this array should be treated as a subscript. Any ideas as to why this is happening and what can be done to get the INSTR effect?

When replying to an email which had an attachment, how do you configure Outlook 2003 to include the orginal attachment? for some reason, this seems to be missing.

thanks. problem solved.

thanks synapsevampire and Madawc. The code to the formula is 'Year (CurrentDate)'. What are your thoughts ?

Hi, Pretty new to this so bear with me however using V10.. I have created two simple mathematical formulas however when attempting to group the data under detail by formula; the program does not give me the option. I have the various fields for any one of the Tables I have chosen but that is...

Hi, I have an excel spreadsheet with multiple worksheets. By making a cell active in one worksheet, is it possible to show which other cells in all spreadsheets use the active cell as part of any formula or calculation by colouring this say yellow ? This will help identify any...

Thanks for the quick reply Bcastner, Will you fix work each time I turn off and turn on the pc ?

When listing files in Explorer or in a dialogue box, I would like to change the default view Windows XP offers for all situations. As it stands, the view default is 'List' but I would like this changed to 'Details' in an ascending alphabetical order. This needs to remain constant always. Any...

I have a motherboard with SATA connections and a 200Gig SATA hard drive. I have installed windows 2000 but it reports the hard drive as 133Gig in size. I have been told to reinstall windows and press F6 on the keyboard but this only prompts me to enter a floppy disk which I do not have; in any...

Okay, I have created a VBA script which in the end saves the worksheet. But if I wanted to embed a VBA script within the worksheet before it is saved, how can I do this ? Now I'm not exactly proficient with VBA so please keep it simple, oh and please tell me if you need more information from...

Hi macropod, Thanks for the website. I'll give it a read although it will take a while to digest as I am somewhat new to VBA. :-) medieval

First of all thanks for reading this.. I have created a VBA script in Excel which culminates in saving a spreadsheet. However I would like to have the spreadsheet saved so that it includes it's own proprietry VBA script. So in this example, I have saved the worksheet which includes a column...

Thats Great BrianB. Thank you. I threw a cup of coffee at my screen to make the window application run faster. I'm waiting to see if that works too. :-) medieval

Thanks for looking at this one. I would like to add a ticker scroll bar into an excel worksheet. The ticker will need to scroll a string variable. Does anyone have any idea's as to how this can be acheived ? regards, Medieval.

Hi Skip, Fanta is a composite file name to which one of the consituted variable strings is denoted as "c:\crg". This will be excluded from the process. cheers, Medieval

Hi Rodie, Thanks for the reply I will give that a go. Hi Skip, I intend to apply the script given by Rodie on the file name itself and not on the path which can be excluded from the process. Thanks for your tip too. ta ever so. Medieval.

Firstly thanks for looking. I am using the code ActiveWorkbook.SaveAs Filename:=Fanta where Fanta is a variable string. However in an instance where the string contains illegal characters like "/" or "\" or "&" for example is there a script which will remove these illegal characters ? For...