Using Calc with VBA/Macros [closed]

asked 2013-06-17 15:48:09 +0100

hartacus gravatar image

updated 2014-01-16 02:09:29 +0100

razon_22 gravatar image

I have an excel file that I purchased to use as a check for calculating structural elements named ProBeam from Construction Calc. I open the file and it asks if I want to open a copy or as read only. This file is not open already. I click open copy and get the security warning about the macors. I enable macros and then get a warning:

BASIC syntax error. Label CustInputCellFormat undefined.

I click ok and then the same error pops up in a never ending cycle that pops up and never opens the file. It works fine in excel.

Here is the excel program: http://www.ebuild.com/articles/865396.hwx

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 19:21:04.728146

Comments

1
m.a.riosv gravatar imagem.a.riosv ( 2013-06-17 23:10:52 +0100 )edit

The answer here also provides some detail on which file formats (XLS, XLSX, ODS) support saving of macros.

oweng gravatar imageoweng ( 2014-07-13 07:17:17 +0100 )edit