Error at $WorkSheet_Select Function

Intel® Fortran Compiler

Build applications that can scale for the future with optimized code designed for Intel® Xeon® and compatible processors.

Error at $WorkSheet_Select Function

499 Views

I wrote folowing code to select one of sheet in the Excel workbook, but I got "Severe Error(157) , Programing Exception, Access Violation" Message.
I couldn't find where y made mistake.
Is there anybody to help me, please?

status = VariantClear(vBSTR1)
bstr1 = 0

vInt%VT = VT_I4
vInt%VU%LONG_VAL = 1
CALL VariantInit(vBSTR1)
vBSTR1%VT = VT_BSTR
bstr1 = ConvertStringToBSTR("ABCD")
! "ABCD" is name of worksheet to be selected.
vBSTR1%VU%PTR_VAL = bstr1
call $Worksheet_Select(worksheet,vBSTR1,$status=status)

Link Copied

0 Replies

Community support is provided during standard business hours (Monday to Friday 7AM - 5PM PST). Other contact methods are available here.

Intel does not verify all solutions, including but not limited to any file transfers that may appear in this community. Accordingly, Intel disclaims all express and implied warranties, including without limitation, the implied warranties of merchantability, fitness for a particular purpose, and non-infringement, as well as any warranty arising from course of performance, course of dealing, or usage in trade.

For more complete information about compiler optimizations, see our Optimization Notice.