I’ve coded a simple conversion utility for our corporation and I need a line at the beginning to have Excel completely EXIT if the first file doesn’t exist (both files are coexistent). Please help
I know that in access the code might read
On Error Exit or something like that but not for Excel. The code is the following:’ B A N K O F T O K Y O – M I T S U B I S H I
‘ L O S A N G E L E S B R A N C H
‘
‘ Written by Hugo E. Vanegas
‘ Banking Assistant
‘ Corporate Banking Department No. 1
‘
‘ ———————————————————
‘ * This set of code converts both “g:\cmd-info” files: *
‘ * tickler.wk4
‘ * borr_trn.wk4
‘ *
‘ * to Excel ’97
‘ * and then proceeds to delete both Lotus 1-2-3 files *
‘ *——————————————————–
If Error Exit
‘ Limits Scroll Area to window
For Each Sheet In Worksheets
Sheet.ScrollArea = “a1:k15”
Next Sheet
‘ This line goes to the next file if first file does no
