Results 1 to 3 of 3

make worksheet active

This is a discussion on make worksheet active within the Excel Questions forums, part of the Question Forums category; I recorded a macro in Excel that I am calling from Access. However, the Macro is not working on the ...

  1. #1
    Board Regular
    Join Date
    Oct 2004
    Location
    Atlanta, GA
    Posts
    240

    Default make worksheet active

    I recorded a macro in Excel that I am calling from Access. However, the Macro is not working on the required worksheet.

    I need to make 'qryTransfer1' the active worksheet before the range I have is selected.

    I tried

    Code:
    qryTransfer1.Activate
    But I need to add something to the procedure.

    Can anyone help?

    Thanks in advance

  2. #2
    New Member
    Join Date
    Jul 2005
    Location
    Newcastle Upon Tyne
    Posts
    47

    Default Re: make worksheet active

    Hello,

    try

    Sheets("qryTransfer1").Activate

    or am I being a bit simplistic?

  3. #3
    Board Regular
    Join Date
    Oct 2004
    Location
    Atlanta, GA
    Posts
    240

    Default Re: make worksheet active

    I was looking at other samples on here and saw how they were putting

    Code:
    sheets(1).Activate
    I guess I was looking at that as 'Sheet1'


    Thanks for the help

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com