Confirmation messages formatting Excel spreadsheet

[mfong75]

Hi,

I'm exporting data to Excel and I'm using automation to format the spreadsheet. What I do is to record a macro with everything I want to do. Then I edit the macro, copy the Visual Basic code to my program and change the code to FoxPro syntax.

When I Merge cells (mergecells = .T.), a message pops up with the following:

"The selection contains multiple data values. Merging into one cell will keep the upper-left most data only"

Is there a way I can avoid having this message?

Also I get more confirmation messages to save the spreadsheet and RESUME.XLW

I'd appreciate any ideas to get rid of these messages.

Thanks in Advance,

Monica

 

[Mike Gagnon]

o=CREATEOBJECT("excel.application&quot
o.DisplayAlerts = .f.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[mfong75]

Hi Mike,

Thank you very much for your answer. That's exactly what I needed.