ExcelBanter - Workbook.activate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Workbook.activate (https://www.excelbanter.com/excel-discussion-misc-queries/1812-workbook-activate.html)

Jeff

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,

Bob Phillips

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,

All times are GMT +1. The time now is 07:31 PM.