I'm trying to import a 1-2-3 file via macro while error msg is appearing.
run-time error '1004' Cannot open Lotus 1-2-3 file
I'm not able to understand what's the error: Do you have any idea on how to solve?
Txs for help
'File to be opened
Filetoopen = Application.GetOpenFilename("All files(*.*), *.*", , "File")
If Filetoopen = False Then End
Workbooks.Open Filename:=Filetoopen
FileOpened = ActiveWorkbook.Path
n1 = Len(FileOpened)
n2 = Len(Filetoopen)
Filename = Right(Filetoopen, (n2 - n1 - 1))
'clean variable overview
Windows(Filename).Activate
run-time error '1004' Cannot open Lotus 1-2-3 file
I'm not able to understand what's the error: Do you have any idea on how to solve?
Txs for help
'File to be opened
Filetoopen = Application.GetOpenFilename("All files(*.*), *.*", , "File")
If Filetoopen = False Then End
Workbooks.Open Filename:=Filetoopen
FileOpened = ActiveWorkbook.Path
n1 = Len(FileOpened)
n2 = Len(Filetoopen)
Filename = Right(Filetoopen, (n2 - n1 - 1))
'clean variable overview
Windows(Filename).Activate