"Sonnich" <sonnich.jensen@elektrobit.com> wrote in message
news:1145890981.311818.306140@v46g2000cwv.googlegroups.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