Search:

Type: Posts; User: Henrik Ryberg; Keyword(s):

Page 1 of 15 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    844

    Thanks John, I'll give it a go tomorrow. They...

    Thanks John, I'll give it a go tomorrow. They seem to be something in the right direction.

    Suggestion #2 - "Multiple Excel Files..." worked like a charm :cool: (Thanks again Hans / :rolleyes:)
  2. Replies
    2
    Views
    844

    A'2010 - Automated XL import

    Hi,

    I'm a newbie to Access (Office 2010), have been working primarily with Oracle, so please bear with stupid questions :o

    Got a folder with a large number of spreadsheets (sequential date...
  3. Thanks for sharing the insights Rory. Trying...

    Thanks for sharing the insights Rory.

    Trying to understand my options in O2010 from both the programmatic and the GUI side.
  4. So if I understand your comment and the...

    So if I understand your comment and the documentation correctly, I can set up a theme with a set of basic colors and vary those with ao. the .tintandshade property of the .interior object?
    ...
  5. So the .Colors thought is gone and you just apply...

    So the .Colors thought is gone and you just apply specific colors at specific instances??

    So it's not really possible to supply a user with a detailed set of "approved" colors without:

    1....
  6. "...so I'm not sure what your question really...

    "...so I'm not sure what your question really is".
    Probably because I took it slightly out of context to simplify :o (Maybe I should have posted in VBA forum)

    Actually I'm trying to setup themes...
  7. O2010 - Color themes vs. old color palettes

    Hi,

    Just converted from O2003 to O2010.

    In Excel I have a lot of different color palettes swapping color, using all 56 color options. (40+8+8). In 2010 the idea behind the themes seems to be a...
  8. Replies
    2
    Views
    832

    Thanks for the answer - appreciate it, but I'm...

    Thanks for the answer - appreciate it, but I'm already aware of that option. :) I was just hoping to achieve more or less the same with the "input box" directly, so that I don't have to go through...
  9. Replies
    2
    Views
    832

    Getting password from user

    Hi

    (Win XP SP-3, O2003 UK)

    In Excel, I'm asking a user for password through an inputbox. As he types it reveals the password - not nice :huh:. Are there a way to substitute or mask the input...
  10. Replies
    3
    Views
    1,509

    Hi Rory, Why use the subset .ProtectContents...

    Hi Rory,

    Why use the subset .ProtectContents in comparison to "just" .Protect - after all .Protect includes .ProtectContents as well?? (fwik)
    :confused:
  11. Replies
    3
    Views
    1,509

    Worksheets - protect/unprotect

    (Win XP, O2003 SP3 UK)

    Hi,

    In Excel I have an 'admin' menu and a sub menu point 'Protect/unprotect' worksheets. With this single menupoint the user to be able to toggle the worksheets of a...
  12. Replies
    4
    Views
    1,863

    Hi jscher, Thanks for the tip. Only problem is...

    Hi jscher,

    Thanks for the tip. Only problem is that this is directly between Excel and Word, so for now there's no ODBC source involved. http://windowssecrets.com/forums/images/smilies/biggrin.gif
  13. Replies
    4
    Views
    1,863

    Hi, A colleague of mine wants to insert a...

    Hi,

    A colleague of mine wants to insert a piece of text (longer than 255 chars) from Excel into Word in a merged document. Once inserted some of the text is cut of. Our guess is that there is a...
  14. Hi Rory, Got you on that - thanks for the tip....

    Hi Rory,

    Got you on that - thanks for the tip.

    I have decided to take a slightly different approach with a fast double iteration, in which I first find the exact number of matches (the UBOUND -...
  15. Hi Rory, Not sure I understand what you mean...

    Hi Rory,

    Not sure I understand what you mean by "Make arr2 a 1D array of arrays" - got an example?

    I tried the transpose bit for starters, but I find it to be a bit messy to work with, when I...
  16. Hi, Got a dynamic array (arr1) that changes in...

    Hi,

    Got a dynamic array (arr1) that changes in size (currently 2182 rows x 17 columns)

    Looping through the arr1 I'm searching for a user provided variable in a specific column (say column 2)....
  17. Replies
    6
    Views
    1,006

    Hi Rory, Not quite sure that I understand what...

    Hi Rory,

    Not quite sure that I understand what you mean by that... http://windowssecrets.com/forums/images/smilies/unsure.gif , but I'll try to explain.

    Combo1 - array of 50 rows x 12 columns ...
  18. Replies
    6
    Views
    1,006

    Thanks Rory, Problem is not so much the first...

    Thanks Rory,

    Problem is not so much the first addition of the lists. It's when the value in combo1 changes that I'm in trouble... http://windowssecrets.com/forums/images/smilies/blush.gif
    ...
  19. Replies
    6
    Views
    1,006

    Hi, (WinXP, O2003 - UK SP3) For starters -...

    Hi,

    (WinXP, O2003 - UK SP3)

    For starters - though I'm aware this would be ideal for a database, that is not an option // http://windowssecrets.com/forums/images/smilies/flee.gif

    Got a...
  20. Replies
    6
    Views
    761

    Thanks Rory, Normally I don't do it either,...

    Thanks Rory,

    Normally I don't do it either, but problem here is that .activate gives me the current selection - which is the entire range (B6:F19) and not just a single row.

    Therefore I decided...
  21. Replies
    6
    Views
    761

    A really informative article. Thanks for the...

    A really informative article.

    Thanks for the input RG - I appreciate it. http://windowssecrets.com/forums/images/smilies/clapping.gif

    Despite the clarity of the article, I have an example...
  22. Replies
    6
    Views
    761

    Found an answer to my question... ...

    Found an answer to my question... http://windowssecrets.com/forums/images/smilies/smile.gif

    Public Function Array_FillFromSelection()
    Dim c
    Dim d
    Dim varGetArrayAll As Variant...
  23. Replies
    6
    Views
    761

    Hi I need to fill a selected range into an...

    Hi

    I need to fill a selected range into an array and are aware of the "tedious" way of doing it. http://windowssecrets.com/forums/images/smilies/wacko.gif
    (If possible I would like not to have...
  24. Thanks RG. But from tests so far and based on...

    Thanks RG.

    But from tests so far and based on the documentation, I don't think this method will work. From below extract from the documentation .run only passes parameters as values.

    "Remarks...
  25. Thanks RG. But from tests so far and based on...

    Thanks RG.

    But from tests so far and based on the documentation, I don't think this method will work. From below extract from the documentation .run only passes parameters as values.

    "Remarks...
Results 1 to 25 of 354
Page 1 of 15 1 2 3 4