Access Violation at Address 00432893

[catander12]

When I try to run a macro with the XLGetCell command I get the Access Violation at Address 00432893 in module 'mssched.exe'. Read if address FFFFFFF0.
I have no idea how to fix this

[Marcus Tettmar]

Does XLOpen work - does it return a valid reference? Does the sheet name exist? Is the row and column reference correct? Can you share your code?

[catander12]

I tried with a non-Read only version too

Code: Select all

XLOpen>\\SERVER01\RedirectedFolders\JDimarco\Desktop\Customer Deposits Validation.xlsx,1,depos


let>k=12
repeat>k
Wait>2.0
SetFocus>Customer Deposits Validation [Read Only] - Excel
  WaitWindowFocused>Customer Deposits Validation [Read Only] - Excel
  XLGetCell>depos,pvt DEPOSIT PAYMENTS workpaper,k,C,name

  IECreate>sps
  IENavigate>sps,https://motw.stoneprofits.com/vSalesHome.aspx,
  


  SetFocus>SPS - Sales Home - Internet Explorer
   WaitWindowFocused>SPS - Sales Home - Internet Explorer
   
   




let>k=k+1
Until>k=262

[Marcus Tettmar]

I don't see any value set for "C". Perhaps you are hardcoding this and don't realise this needs to be numeric. Change "C" to 3. C is column 3. So change your XLGetCell to:

XLGetCell>depos,pvt DEPOSIT PAYMENTS workpaper,k,3,name