Recent content by jaol

The Word data source file acts like a database, but is a word document - not a txt-file. In Excel I would like to select some of the information from one 'row' in the word data source file and process them into XMLfiles used for shipping. If the data source file was a database - plain SQL and a...

Hi all, In our company mail merging in Word is done with using Word as data source. We also an Excel application that needs to extract information from this Word data source, but I cannot figure out how to do it from VBA. If it is not posssible to get access to the Word data source file from...

In my office we use Outlook 2010 running under Windows 7. Everything is maintained properly. We are three people that have some problems with Outlook. Most of the time everything works normal, but for the last two months we sometimes see this and I think with a increasing frequency: Writing a...

Hi all, I would like to change the list separator in the registry HKEY_CURRENT_USER\Control Panel\International\sList form ";" to "|" using VBA from Excel. this small code gives me the current separator: Set WShell = CreateObject("WScript.Shell") GetRegistry =...

Yes I am running it from Excel VBA. I have a kind of central Excel application which is used by a lot of people. And I would like to give them all the possibility to print these outlook mails without going through outlook and change the printer. (And then, I have very little knowledge about...

Hi, I would like to make a routine in Excel (2003), from which I look in a group-mailbox and if the mail subject begins with eg "ABC D" I will print it on a special printer. My problem is, that using Application.ActivePrinter to change the printer works if I am printing from Excel, but now I am...

Thanks for these very quick answers. lionelhill you solved my problem. The "Precision as Displayed" was checked, and after unchecking this, everything works perfect. Thanks again

I have an excel 2003-sheet, that reacts quite strange. I have a cell with format number and decimals=1 The cell has a value = 1.1 If I change the value to 1.15 I will expect to see 1.2 in the cell and 1.15 in the formularow. But I have 1.2 both places. There are no data validation, no...

Let me try to explain. I build a INSERT-sql-sentence while i'm looping through a recordset. If this sql-sentence is wrong I am not getting an error from the server. If I write this wrong sql-sentence in Access, I can see the problem, because I am trying to update the same field twice in one...

Hi, Im trying to update several records in my Access-database through an ASP-page. The SQLsentence is build dynamicly for each record. If the UPDATE gives an error, I dont get the message, and everyting stops without warning me. How can I validate my SQL before executing or how do I get the...

Hi Andy, Thanks a lot for your help, now it is working fine. Cheers Janne

Hi, I have an excel-chart with a textbox on. When I export this chart to a gif-file using ActiveSheet.ChartObjects("Chart 1").Chart.Export filename:="XX.gif", Filtername:="Gif" the textbox is missing on the gif-file. Grouping chart and textbox is not the sollution. Can anyone helt me?

Try read thread333-738526. Maybe it will help you