VBA

Resolved · Medium Priority · Version 2003

Mon 3 Nov 2008, 16:26 Delegate Ivan said...

Ivan has attended:
Excel VBA Intro Intermediate course

VBA

Can a macro be written which incorporates data from a second workbook?

Fri 21 Nov 2008, 13:43 Trainer Laura said...

RE: VBA

Hi Ivan

Thank you for your question regarding Workbooks in VBA.

Yes you can access data in other workbooks in VBA, you will need to open the workbooks.

Dim mybook as Workbook

Dim myotherbook as Workbook

' 

Set mybook = ActiveWorkbook

' Open other workbook

Workbooks.Open "Book2.xls"

set myotherbook = ActiveWorkbook

You can then use mybook.Activate and myotherbook.Activate to switch between the two books.

Please let me know how you get on.

Laura GB

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips