Recent content by pbcharlie

Yes, what I would do is record the macro into the xls that you want the data into, that way when you open the xls with that data you want to copy the macro will remember the xls that you want to open. have a play with recoding macros, you will get the hang of them. Charlie

You Should be able to do this using the stationary option if it is a static HTML page try tools/options/mail format and then stationary otions

I would suggest downloading a freeware to edit the wav/mp3 file. try downloads . com Thanks in advance Charlie

Hi there, just saw your question. I am sure that if you record the macro whilst you are doing your copy and pasting you will get the desired results. I just quickly tried it and got the following Sub Macro1() ' ' Macro1 Macro ' Macro recorded 18/05/2007 by Charlie Snedden ' '...

Hi There, I am wondering if the Generic RTA report can be changed from what seems to be a standard output of 82231 20 0 14 95 0 1 0 82731 82233 30 2 9 95 0 1 0 82733 82234 20 0 24 95 0 1 0 82734 to somthing like 17/05/2008 10:01:02 82231 20...

This looks good, I can see the logic behind it. Thank you very much Thanks in advance Charlie

Hi there. I was wondering if someon could help. I have a spread sheet that has multiple rows however the row is not prefixed with the date i.e 12/12/06 Fiona Young Charlie Snedden 13/12/06 Fiona Young Charlie Snedden What I need the macro to do is 12/12/06 12/12/06...

I have been bashing this around for a number of days now. What I have is a database with a content field. The content field has XML in it. I want to display the content in the textarea using the XSL template. Then I want to be able to press a button and see the XML. All this for edditing a...

I have a report with three seperate querys. Each of which has to have the same date varibles. How do I execute one request for inputs to the other querys? Thanks in advance Charlie

Is there a quick way to transfere a Oracle database to sql? Thanks in advance Charlie

Is there a quick way I can extract all the Table in the Oracle database so I can transfere them to a SQL server database.... Thanks Thanks in advance Charlie

I have a database and crystal report which does almost all I need. The last thing I need to do is create a summary of all the calls split by operator. I have fields callop, callid I need to sum the number of callid by the individual callop. Is this possible??? Thanks in advance Thanks in...

I have two tables. Users and names. In users the fields are ID, Fname, Lname, Location, sex in the names table I have Fname, lname and sex. What I want to be able to do is have an insert query that inserts from the names table, however the names are randomly selected and also randomise the...

I know that if you run an agent trace you can see what work codes have been entered by an agent. What I need to know is howlong does it keep agents workcode data and where can I find out more information on workcodes? Unfortunately I am only a technical user and My IT dept will not release the...

Thanks this has helped alot Thanks in advance Charlie