vinmam123VBA
New Member
- Joined
- Dec 18, 2020
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi All,
Can one of you please help me:
I have opened the one excel file and made some changes and then I have opened another excel file using get file open opetion.
Now I want swith to first file. Can someone guide me how to do
First file is -
FileToOpen = Application.GetOpenFilename(Title:="Browse Your File", FileFilter:="Excel Files(*.xlsb),*.xlsx")
Set OpenBook = Application.Workbooks.Open(FileToOpen)
second file is-
FileToOpen1 = Application.GetOpenFilename(Title:="Browse Your File", FileFilter:="Excel Files(*.xlsx),*.xlsb")
If FileToOpen1 <> False Then
Set OpenBook1 = Application.Workbooks.Open(FileToOpen1)
I am trying to select first file by below line of code
Windows("OpenBook").Select
however it it not working
Regards,
Vinayak
Can one of you please help me:
I have opened the one excel file and made some changes and then I have opened another excel file using get file open opetion.
Now I want swith to first file. Can someone guide me how to do
First file is -
FileToOpen = Application.GetOpenFilename(Title:="Browse Your File", FileFilter:="Excel Files(*.xlsb),*.xlsx")
Set OpenBook = Application.Workbooks.Open(FileToOpen)
second file is-
FileToOpen1 = Application.GetOpenFilename(Title:="Browse Your File", FileFilter:="Excel Files(*.xlsx),*.xlsb")
If FileToOpen1 <> False Then
Set OpenBook1 = Application.Workbooks.Open(FileToOpen1)
I am trying to select first file by below line of code
Windows("OpenBook").Select
however it it not working
Regards,
Vinayak