Is ExecuteExcel4Macro still works in Excel 2013 or later version?

F

Fredy6

Joined
Dec 25, 2017
Messages
2
Reaction score
0
Hello, Dear smarter friends:
I'm trying to use the following excel4macro to determine chart point coordinates.

Pnt1_x = ExecuteExcel4Macro("get.chart.item(1,1, ""S1P" & i & """)")

It wroks fine with Excel 2010 or older. But it fails to work in Excel 2013. I'm wondering if Excel 2013 does not support the ExecuteExcel4Macro macro. Is there any way to get it fixed ? Or, is there any other macro that can replace this old macro for Excel 2013?

Your help is greatly appreciated.
 
F

Fredy6

Joined
Dec 25, 2017
Messages
2
Reaction score
0
Fredy6 said:
Hello, Dear smarter friends:
I'm trying to use the following excel4macro to determine chart point coordinates.

Pnt1_x = ExecuteExcel4Macro("get.chart.item(1,1, ""S1P" & i & """)")

It wroks fine with Excel 2010 or older. But it fails to work in Excel 2013. I'm wondering if Excel 2013 does not support the ExecuteExcel4Macro macro. Is there any way to get it fixed ? Or, is there any other macro that can replace this old macro for Excel 2013?

Your help is greatly appreciated.
Click to expand...
Is there any equivalent function of get.chart.item in Excel 2013 or later version?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AUTOEXEX Macro - Check OS or Access Version BEFORE Enable MACRO Security 0
Can't Open Text File From Website in Excel 2010 0
Excel still hanging on quit wasn't fixed in latest update 1
Win7 VirtualStore Weirdness with Excel 2002 and earlier 60
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Older Version Of Excel 0
Importing Excel Data into PPT using VBA 1
Importing Data From Excel into PPT Charts and Graphs using VBA 9

Top