Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jaol
  • Content: Threads
  • Order by date
  1. jaol

    Getting access to Word mail merge data source from VBA

    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...
  2. jaol

    Outlook recipient address dissapear

    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...
  3. jaol

    Changing List separator in registry is not working

    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 =...
  4. jaol

    How do I control Outlook printer from Excel

    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...
  5. jaol

    Excel changes my data

    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...
  6. jaol

    How do I validate dynamic sql?

    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...
  7. jaol

    export excel chart to gif

    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?

Part and Inventory Search

Back
Top