"Sonnich" wrote in message
oups.com...
Hi!

I have an excel doc, with a button, for which I need to know:

I need to open another file, which I like this
Workbooks.Open ("C:\test\somefile.xls")
- Is there a way that I can prompt for the filename?

Look at GetOpenFilename in VBA Help

The I copy data from that into my document. Like this

Workbooks(1).Sheets(1).Cells(i, j) =
Workbooks(2).Sheets(1).Cells(i, j)
Workbooks(1).Sheets(1).Cells(i, j).Font.Bold =
Workbooks(2).Sheets(1).Cells(i, j).Font.Bold

- How can I copy the widths of the cells, and the border (if any)?

Workbooks(1).Sheets(1).Cells(i, j).Copy
Workbooks(2).Sheets(1).Cells(i, j).Paste PasteSpecial:=xlPasteAll