Palo Calculation into a VBA Macro

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

gchicoye

Intermediate

Posts: 10

Date of registration: Feb 28th 2011

Tuesday, March 6th 2012, 11:35am

Palo Calculation into a VBA Macro

Hi,

I've got some problems using a macro which is supposed to refresh an Excel form then print it.

In fact, when I update an element, Excel does not perform the calculation into the macro. It is once I'm out the macro that the correct data appears.
I've tried several things such as application.calculate but if does not work.

Please let me know if you have an answer or further question.

Gabriel

Go to the top of the page

dmarkovic

Master

Posts: 90

Date of registration: Aug 11th 2011

Location: Vienna / Austria

Occupation: Vector SW DV GmbH

Tuesday, March 6th 2012, 2:19pm

Hello gchicoye,

i'm not sure that i understand your problem, but you want to refresh the view (F9) and then to print it, so try this:

	Source code
1 2	application.calculate application.calculation = xlCalculationAutomatic

Regards.

Djordja Markovic
Vector SW DV GmbH

Interessant things:
Internal derby:
http://www.jedox.com/community/palo-foru…14338#post14338
Calculate your cube size:
http://www.jedox.com/community/palo-foru…14406#post14406

Go to the top of the page

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

Thursday, March 8th 2012, 11:01pm

Hi,

if you try to create a batch print process and you have DATAC formulas in your spreadsheet, you cannot use "activesheet.calculate". You can either replace DATAC through DATA or use the "application.run" function for recalculating as descibed in the Jedox for Excel manual.

Regards.

Robert Tischler
Senior Consultant Vector SW DV GmbH

Unterstützung für Jedox und Palo Projekte - Jedox und Palo Schulungen in Wien - Vector Blog auch über Jedox und Palo

Go to the top of the page

dmarkovic

Master

Posts: 90

Date of registration: Aug 11th 2011

Location: Vienna / Austria

Occupation: Vector SW DV GmbH

Friday, March 9th 2012, 10:17am

Quoted from "tish1"

Hi,

if you try to create a batch print process and you have DATAC formulas in your spreadsheet, you cannot use "activesheet.calculate". You can either replace DATAC through DATA or use the "application.run" function for recalculating as descibed in the Jedox for Excel manual.

Regards.

Robert is right!

Regards.

Go to the top of the page

gchicoye

Intermediate

Posts: 10

Date of registration: Feb 28th 2011

Friday, March 9th 2012, 12:20pm

Quoted from "tish1"

Hi,

if you try to create a batch print process and you have DATAC formulas in your spreadsheet, you cannot use "activesheet.calculate". You can either replace DATAC through DATA or use the "application.run" function for recalculating as descibed in the Jedox for Excel manual.

Regards.

It works!!!

I just had to replace datac with Data, it is perfectly working!

Thanks a million guys!