[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

--

----------------------------------------------------------
tradutormg@gmail.com - ljstrans@gmail.com
laertejs@ljstraducoes.com http://juramentado.ljstraducoes.com (31)
3498-6020 - 9992-8118

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

[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 (6)

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

.

__,_._,___