Macro in xp

E

Esau

This works in Me why not in XP

Workbooks.Open Filename:="C:\My Documents\One\" & _
ActiveWorkbook.Worksheets("sheet4").Range("A1").Value _
& ".xls"

Thank you
Esau
 
E

Esau

I found the answer in XP you have to add Documents and
settings\your name\ in front of my Documents

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SetRange Help 4
HELP - Too long coding for Macro 12
Macro to select and delete levels of a document 2
Select Case Code does not run... 10
Open a workbook, Copy several cells, then Close the previously openedworkbook 0
go to a particular sheet Gord Dibben 10
Open four Wbooks, copy four columns from each to Master Wbook 16
problems getting this macro to work 8

Top