I have a file that run code below :
Dim wb as Variant
set wb = GetObject(path) 'path is the path of excel file
It can't be run. It's alert : file name or class not found ....
But when i create new file and the path is pointed to new file. It's run OK.
I'm sure that path is right. Because when i run
Dim wb as Variant
set wb = Excel.WorkSheets.Open(path) 'path is the path of excel file
It's run OK. So i think the file that i try to open has some special things that GetObject method in Mac can't be run ( in windows, it run well )
And i don't want to use Excel.WorkSheets.Open. Because, it's slow than GetObject method. So how can i solve this problem?
Reply With Quote
)
