Userform open Excel file (new or existing)

[fehmous]

Hello guys,

I'm new here, so i have a little problem with my macro

I created a dialog box (UserForm 1) with 3 buttons:

* - New Excel: here I call a specific Excel file (I open with the file address) then I entered a numeric value in a cell (to simplify my application): in this case it worked perfectly

- Update an Excel: here I chose browser opens any file and then I try to write in a cell: in this case I can not open a file and write data in the corresponding Excel sheet. I feel that the sheet is not active or something to that effect.

- Cancel: Clicking the dialog is hidden. In this step : no problem ; It's working

If someone has an idea to update an Excel (opening any file - Writing in the sheet)

Thank you in advance