Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    3
    Views
    2,126

    In your VB6 project (assuming that is where you...

    In your VB6 project (assuming that is where you are building the COM addin in), you use code like this in the XLConnect designer:


    Private Function IRibbonExtensibility_GetCustomUI(ByVal RibbonID...
  2. Replies
    7
    Views
    4,756

    I expect so. Best to read the license agreement.

    I expect so. Best to read the license agreement.
  3. Replies
    7
    Views
    4,756

    One way to have both versions is by installing...

    One way to have both versions is by installing one of them inside a virtual machine.

    Your summary seems to be correct.

    The "common" controls however, should already be on your system, as they...
  4. Replies
    7
    Views
    4,756

    If they say to look for alternatives, they mean...

    If they say to look for alternatives, they mean look for the 64 bit counterparts of the control you need if you're using Office 64 bit.

    The only place you can look for them is by using the more...
  5. Replies
    7
    Views
    4,756

    If any, they should be available through the More...

    If any, they should be available through the More Controls... button on the insert control dropdown in the ribbon.
  6. Replies
    13
    Views
    3,225

    Array(arg1,arg2,arg3,...) is a VBA function and...

    Array(arg1,arg2,arg3,...) is a VBA function and eval cannot handle VBA functions or methods. It can do the regular math operations however.
  7. Replies
    3
    Views
    509

    As you saw, in order for a web query to work, the...

    As you saw, in order for a web query to work, the page must be "ready" when Excel tries to read it.
  8. Replies
    3
    Views
    509

    Is the javascript done on the client? I suspect...

    Is the javascript done on the client? I suspect those might be blocked for "security" reasons.
  9. Replies
    4
    Views
    1,477

    On the offending machines, click start, run and...

    On the offending machines, click start, run and enter this:

    "c:\Program Files\Microsoft Office\Office\Excel.exe" /regserver

    (quotes mandatory, change path if needed). That usually fixes...
  10. Replies
    11
    Views
    3,096

    Another option (but some more work) is to...

    Another option (but some more work) is to download the free Virtual PC from Microsoft and set up a virtual machine (VM). You need a valid Windows CD for this however, because that is what you have to...
  11. Replies
    11
    Views
    3,096

    I run 2002 and 2003 next to each other without...

    I run 2002 and 2003 next to each other without problems. I used to run 97, 2000, 2002 and 2003 without noticable trouble too.
    There are some quirks though. Maybe more, but I've only heard of these:...
  12. Replies
    3
    Views
    2,910

    Using the routine to download a file is very...

    Using the routine to download a file is very easy:


    Sub Foo()
    'Some code
    DownloadFile "CompleteURL2FIleGoesHere", "CompletePathToStoreFileGoesHere"
    'Other Code
    End Sub
  13. Replies
    3
    Views
    2,910

    I have some sample code to download a file. See...

    I have some sample code to download a file. See this page:

    http://www.jkp-ads.com/articles/updateanaddin.asp


    Private Declare Function URLDownloadToFile Lib "urlmon" _
    Alias...
  14. Replies
    4
    Views
    607

    The code as such is OK, so something else is...

    The code as such is OK, so something else is going on here.
    Maybe the worksheet in question is protected?
    What if you try to hide the row manually?
  15. Replies
    4
    Views
    607

    Do you get an error? If so, which and on what...

    Do you get an error? If so, which and on what line of the code?
  16. Replies
    1
    Views
    443

    Probably the file opens in Internet Explorer. VBA...

    Probably the file opens in Internet Explorer. VBA code in Excel files does not work well when the file is opened in IE.
  17. Replies
    11
    Views
    1,915

    MS did not include all of the styles you have...

    MS did not include all of the styles you have deleted, they were added to your workbook during copy/paste actions pasting in information from other workbooks.

    Copying a worksheet from workbook A...
  18. Replies
    15
    Views
    1,175

    Make sure you use the proper double quotes, it...

    Make sure you use the proper double quotes, it looks like all the opening double quotes need to be replaced with "
  19. OPen Office should be able to read your Office XP...

    OPen Office should be able to read your Office XP documents without too much trouble.
    However, some formatting will probably turn out different that expected and some Excel functionality may not...
  20. Thread: Macro Setting

    by pieterse
    Replies
    1
    Views
    458

    Maybe your IT department has locked you out of...

    Maybe your IT department has locked you out of that part?
  21. Replies
    6
    Views
    1,034

    Any hidden rows? Does it help to do a...

    Any hidden rows?

    Does it help to do a control+shift+alt+F9 (forces Excel to rebuild the calculation tree)?
  22. Replies
    8
    Views
    3,975

    This is certainly do-able in Excel VBA. If you...

    This is certainly do-able in Excel VBA. If you can write VB (I assume classic VB), VBA is a no-brainer. Take head that VBA is a subset of VB6 and hence some things aren't there (especially the forms...
  23. Replies
    6
    Views
    1,034

    Are there formulas pointing to entire columns?...

    Are there formulas pointing to entire columns?
    Where does control+end take you on the sheets?
  24. Replies
    11
    Views
    1,915

    I just counted on a plain new workbook and there...

    I just counted on a plain new workbook and there are no more than 42 predefined styles. ONE of them is Neutral. So your workbook is definitely "dirty" with styles.
    You can right click entries in the...
  25. Replies
    12
    Views
    3,702

    Why not include a real-life example? You can...

    Why not include a real-life example? You can still change the product names and such so we don't know what products this is about.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4