Search:

Type: Posts; User: KingMartin; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    503

    Re: VBA - replacing (Word2k)

    Thanks Andrew,

    the " " should have read   replaced with " " (space). The string was lost probably due to HTML here at Woody's. I have written it in capitals now.

    The recorder is definitely...
  2. Replies
    6
    Views
    503

    VBA - replacing (Word2k)

    Hello,

    after converting code from VBEditor into HTML, I get this:

    <font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> FormatNumber()
  3. Re: Calling Access code/UDF from Excel (Office 2k)

    Thank you for the prompt answer Hans,

    no problem with Automation and yes, I'd like to do this - if possible <img src=/S/smile.gif border=0 alt=smile width=15 height=15> .
    <pre>Sub...
  4. Calling Access code/UDF from Excel (Office 2k)

    Hello,
    I have a code and UDFs in MS Access database. How can I use them / call them from Excel VBA module?

    Thank you
    Martin
  5. Replies
    5
    Views
    1,745

    Re: Invalid NZ function (Excel/Access/VBA 2k)

    Thank you very much Hans,
    obviously I must have ODBC installed, ODBC Add-in is not enough (?).
    Martin
  6. Replies
    5
    Views
    1,745

    Re: Invalid NZ function (Excel/Access/VBA 2k)

    Thank you very much Hans,
    I am not very good in understanding how OLE DB works and I thought that early binding could solve the problem but apparently it did not.

    maybe you could help with this...
  7. Replies
    5
    Views
    1,745

    Invalid NZ function (Excel/Access/VBA 2k)

    Hello,
    first of all I am not sure in which forum to place this but as I am using Automation I opted for VBA forum. Please fell free to move it to wherever most appropriate.

    I use the following...
  8. Re: Troubles with Excel - Word Automation (Office 2k)

    Thank you very much Hans,
    it seems that these lines:
    <pre>With .ActiveDocument.Shapes(ActiveDocument.Shapes.Count)
    and
    .Left = InchesToPoints(0)
    </pre>


    were causing the troubles. I...
  9. Troubles with Excel - Word Automation (Office 2k)

    Hello,

    I have a rather complex code that generates a report from several excel files and copies the pictures and text into Word. Some of the Excel files are changed on the fly and they need to be...
  10. Replies
    10
    Views
    636

    Re: Access into XL (Office 2k)

    Hello Wendell, thank you very much for your reply.
    In the meantime, I found a method how to connect to an user-level secured database, build a SQL on the fly and import the result into Excel. The...
  11. Replies
    10
    Views
    636

    Re: Access into XL (Office 2k)

    Thank you for the answer.
    Unfortunately the help item "Connection Object (ADO)" in my Help woun't open, either I do not have the whole help file installed or something's wrong with it.

    I...
  12. Replies
    10
    Views
    636

    Re: Access into XL (Office 2k)

    Just read briefly the links - actually I am quite familiar with ADO, never used Access as Automation server though.
    I can't find out the proper way how to connect to the db that is user-level...
  13. Replies
    10
    Views
    636

    Re: Access into XL (Office 2k)

    Thank you very much for your reply. I'll give it a try and dare to be back in case of troubles.
    I didn't know that one about Access2002: Does it allow e.g. multiple column headers? I can't believe...
  14. Re: Access into XL (Office 2k) (336491) was moved to the Access board

    Sorry for wrong posting, thanks
    M.
  15. Replies
    10
    Views
    636

    Re: Access into XL (Office 2k)

    Thank you very much for your reply.
    Yes, I tried this, however I am encountering problems when connecting to user-level secured database. (my system file is named MIS.mdw).
    And last but not least...
  16. Replies
    10
    Views
    636

    Access into XL (Office 2k)

    Hello,

    I find the crosstabs in Access sort of not user-friendly. <img src=/S/tongue.gif border=0 alt=tongue width=15 height=15> I'd like to establish a connection to a user-level secured...
  17. Re: VBE: Change back to default view (Excel2000)

    Thanks for the link, I managed somehow:
    All but Object browser must be dockable, I started with maximized code window and I placed all the windows except Object browser, make code window invisible,...
  18. VBE: Change back to default view (Excel2000)

    Hello,
    this is probably a very stupid question, but it happend to me for the first time.

    I have clicked on something and the windows in my VBE have lost their initial position and do not want to...
  19. Replies
    3
    Views
    387

    Re: Manipulating Tables in Word (Word2k)

    Many thanks to both of you,
    Hans, this works a treat!
  20. Replies
    3
    Views
    387

    Manipulating Tables in Word (Word2k)

    Hello,
    what is the code that accesses a cells in a table in Word?

    For instance, I have a table 10 x 4 and I would like to copy first two columns, but only e.g. 2nd, 3rd, 5th and 9th row into a...
  21. Replies
    5
    Views
    346

    Re: excel column split in 2 (officeXP)

    Hello,
    try this:
    <pre>Sub HalfRange()

    RowsCnt = Range([a2], [a65536].End(3)).Rows.Count
    FstRowToMove = RowsCnt 2 + 1

    Set srcRange = Range("A" & FstRowToMove).Resize(RowsCnt - FstRowToMove...
  22. Re: Range of Cells Containing Text (2002 SP-2)

    You mean randomly spread cells?
    No CurrentRegion or UsedRange?
  23. Replies
    18
    Views
    1,141

    Re: Send Files (VB6)

    Hi Dave,
    a) you can also extract the name by combining Left and InStr functions. No need to remove the FileModified info.
    /forums/images/smilies/cool.gif re ZIP & MAIL: Have a look here
  24. Replies
    18
    Views
    1,141

    Re: Send Files (VB6)

    Hi Dave,
    did you try to hard-code one copy procedure e.g. in the immediate window?
    Something like

    FileCopy "C:test.dat", "C:Datatest.dat"

    If there's an error, it has something to do with the...
  25. Replies
    5
    Views
    394

    Re: Date formula (excel 97 (at work))

    To be complete, here's a formula I use to convert a number into an ordinal number:
    ...
Results 1 to 25 of 41
Page 1 of 2 1 2