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 Chriss Miller 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: *

  1. JackCopper

    How to detect "AfterXX" events (e.g. Workbook"After"Save)

    Though at first blush it seems a bit convoluted, I concede it also may be the only way - and certainly an option I hadn't thought about. I haven't had a chance to do any serious work on it yet - until an hour ago I thought I was going to China today. I'll try to do more later today (it's noon...
  2. JackCopper

    How to detect "AfterXX" events (e.g. Workbook"After"Save)

    Thanks for the suggestions, but unfortunately they don't quite address the problem. My code is running as an add-in. The add-in explicitly loads a dll (for access to international message strings) during auto_open in a module in the xla add-in. After Excel is merrily running, all GUI labels...
  3. JackCopper

    How to detect "AfterXX" events (e.g. Workbook"After"Save)

    I need to know when a workbook has been saved for certain (i.e., user did not cancel the SaveAs dialog). I would like to determine this through an event of some kind, but I have not found anything suitable. I also have a similar problem with auto_close (in a module). If a user closes Excel...
  4. JackCopper

    How do I put a delimited text string into Excel Cells

    Thanks, folks. I finally decided I'd have to parse the string and insert values cell by cell (my add-in has to work with Excel 8/87, so I can't rely on Split). I'm trying to break myself of the habit of writing all low-level stuff - I continue to find Excel methods that I didn't previously know...
  5. JackCopper

    How do I put a delimited text string into Excel Cells

    I would like to put tab delimited text into successive horizontal cells. TextToColumns does what I want, except that it is a method of range objects, hence I seem to have to put the entire string into a one-cell range, then use TextToColumns on the range. It works, but it is ugly. Could someone...

Part and Inventory Search

Back
Top