Results 1 to 9 of 9

Thread: Macro Issue

  1. #1
    Join Date
    Jan 2004
    Posts
    68

    Post Unanswered: Macro Issue

    Hello all,

    I'm hoping you can help me on a commercial project I'm working on.

    The first issue I am having is Macro 'Auto Generation' I am trying to create a system whereby a Business User can click on a function called 'Create New User' - On clicking this function it should automatically create a series of personalised workbooks (by name - for eg. JD_Q1_BCS, ZB_Q1_BCS) (There are approximately 15 Worksheets for each user) On clicking on the new function it should also create and format a series of 'navigational functions' on the 'Master Navigation Worksheet' The issue I am currently having with this at the moment is that I can get it to add new data/ format the cells but cannot get it to increment this data over the right and thus currently it keeps overwriting USER's A Data. We are trying to get this finished ASAP so any advice and or guidance on this would be fantastic. A lot of this may sound confusing so I am more than willing to send what we have done so far over to anybody if it helps.

    Kind regards,

    James

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    worksheets?
    is this an Excel question?
    have you considered using a template?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    My first advice is to post questions like this in the right forum.

    You need a Microsoft Excel forum, not a Microsoft Access forum!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jan 2004
    Posts
    68

    Many thanks.

    Many thanks.

    Unfortunately the Excel Forum Post Submit was not working this morning.

    I will re post this as soon as the service becomes available.

    As a side note Trekker - You happen to have the worst website I have seen in a very long time indeed! It is truly horrifying. I nearly had an epileptic fit whilst looking your early 90's use of Flash for the 'Grand Presentation' Far too much text, and a background image - Are you actually being serious?

    Thanks again,

    James

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    No need to repost, I'll move this one for you
    George
    Home | Blog

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by 00304367
    As a side note Trekker - You happen to have the worst website I have seen in a very long time indeed!
    Oh and James, ever heard the saying
    Don't bite the hand that feeds you
    ?
    George
    Home | Blog

  7. #7
    Join Date
    Jan 2004
    Posts
    68

    Ahh

    Ahh of course. But I think on this occasion he deserved it. Many thanks for reposting. Very much appreciated.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Hey, at least he's got one
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by georgev
    Oh and James, ever heard the saying

    Don't bite the hand that feeds you
    Especially from one who comes to the trough so very often, usually pitifully bleating "Help!!!!!!!!!!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •