8 replies to this topic

[andykay]

Hi All,

I have written a report/spreadsheet to list file modifications done since our last upgrade (see sample attached). I would like to list the differences in Bold Red but am force to use Highlighted Red because everytime I try to use the BOLD command, the Excel ignores the DDE_EXECUTE command I send to it (Ie. The fon't comes out in standard formatting Normal Black).

I am using the following statement that works fine to turn the font Red:

$$PATTERNS = '[FONT.PROPERTIES(,,,,,,,,,3)]'

But I I change ANY other parameter, Excel ignores the entire command and prints the line normally...Black.

I've tried:

$$PATTERNS = '[FONT.PROPERTIES(,Bold,,,,,,,,3)]'
$$PATTERNS = '[FONT.PROPERTIES(Courier,Bold,,,,,,,,3)]'
$$PATTERNS = '[FONT.PROPERTIES(Courier,Bold,,,,,,,,3,False)]'

All with no Luck.

Does anyone know how to correctly issue a Bold command to Excel?

TIA.

Attached Files

•  Upgrade.xls   36.5KB   459 downloads

Edited by andykay, 30 May 2006 - 04:53 PM.

[Vol Yip]

Hi Andy,

I am interested to know how to write DDE to produce the outlining format worksheet looks like your Excel. Could you please give me some lights?

Regards,

Vol

Edited by Vol Yip, 20 December 2007 - 03:04 PM.

[Marcel De Rijk]

Looks great! I would also like to see the code that produced all that?

[Steve Houghton]

Hi David

In answer to your question "How flaky is all this DDE stuff?" I would like to say that I have developed a Pro-IV based finance system called VIP Financials and most of the reporting is done via Excel using DDE's. They work 100% in Excel 1997, 2001 and 2003 and there are minor coding changes for Excel 2007. The accounts system has user-definable colour schemes and the Excel spreadhseets match the user's choice of colours. My system does not really have high data volumes and this become an issue for some people.

Regards

Steve Houghton

[andykay]

Looks great! I would also like to see the code that produced all that?

Enquirer,

It would appear that the XLS report used for our upgrade project was converted to a Single Function XLS report after our upgrade. After reviewing the FUNCTION Documentation, I've determined that there is no sensitive code in the Doc itself...All the good bits of code, which my company might have issues about, are in the LU's being called.

You wanted to see the code for the report...here it is. While it will not provide you with any Excel code, it will give an enquiring programmer a starting point for the types of calls that are needed for highend Excel outputs...95% of which I found answers, through intensive searching for, here on the RC...directly and indirectly.


AK

Attached Files

•  Function_To_XLS.txt   13.9KB   352 downloads

[Vol Yip]

Looks great! I would also like to see the code that produced all that?

Enquirer,

It would appear that the XLS report used for our upgrade project was converted to a Single Function XLS report after our upgrade. After reviewing the FUNCTION Documentation, I've determined that there is no sensitive code in the Doc itself...All the good bits of code, which my company might have issues about, are in the LU's being called.

You wanted to see the code for the report...here it is. While it will not provide you with any Excel code, it will give an enquiring programmer a starting point for the types of calls that are needed for highend Excel outputs...95% of which I found answers, through intensive searching for, here on the RC...directly and indirectly.


AK

Thanks AK

[Marcel De Rijk]

Thank you for that!