Re: [ExcelVBA] Re: Using cell values from one sheet as workbook and spreadsheet names

 

Laerte,

Great that you got back with your solution Laerte!!! thanks!
Lisa

Sent: Tue, Oct 23, 2012 12:24 pm

Subject: [ExcelVBA] Re: Using cell values from one sheet as workbook and spreadsheet names

Hi Phil

This is how I solved it:

Cell D41 value with the sheet name is automatically updated with a
VLookup function.

Application.Workbooks.Open wkbk2

Dim sheetName

sheetName = xyz

CurJobNo = Sheets("Yearly Log").Range("D41").Value

Application.Worksheets(sheetName).Activate

Simple and works perfectly. :)

Thanks for your helping. I'll study and learn from your code and save
it for future reference.

Sorry for my nearly utter lack of knowledge of VBA. I'm just a
translator trying to make running a few daily work tasks easier.

Laerte J Silva

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___