A simple dde update problem

[cristinita88]

Hello to all, my 1st post here!

I have a problem that , after many hours, cannot solve
I'm sure for the expert people here, it's very easy to solve, so i aks your help

I put in A1 a formula with a DDE link
I need to copy the A1 value in another sheet
The problem is that the A1 cell updates only AFTER the macro finished
It seems like the DDE starts downloading the data only after macro ends
I tried also to put a wait for 30 seconds, but doesn't help
The A1 cell will show the value downloaded from the DDE only after macro finished its job

Is there a way to have the A1 updated when the macro is in execution?
Thanks!

Private Sub CommandButton1_Click()

Range("A1").Formula = "=FDF|Q!'664898.MOT;isin'"
Application.Wait Now + TimeSerial(0, 0, 30)

End Sub

 

[cristinita88]

i tried also to add the command to recalculate, but doens't work
ActiveSheet.EnableCalculation = True


Any idea?

Please help..i'm a super newbie