| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Workbook.activate
Hi,
This is my VBA Macro: fname = Application.GetOpenFilename Workbooks.Open filename:=fname ' ' Windows("Fichier Exemple.xls").Activate Sheets("Fichier Exemple").Activate How do I re-activate fname ? Thanks, |
|
#2
|
|||
|
|||
|
fname = Application.GetOpenFilename
Set wb = Workbooks.Open( filename:=fname) ' ' Windows("Fichier Exemple.xls").Activate Sheets("Fichier Exemple").Activate wb.activate -- HTH RP (remove nothere from the email address if mailing direct) "Jeff" wrote in message ... Hi, This is my VBA Macro: fname = Application.GetOpenFilename Workbooks.Open filename:=fname ' ' Windows("Fichier Exemple.xls").Activate Sheets("Fichier Exemple").Activate How do I re-activate fname ? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
