What VSB language make it possible to open a "save as" dialog box when running the macro? Also a problem for me is, how to refer the default filename in the "save as" dialog box to a cell contents in the concerned worksheet? Thanks in advance for your help.
As part of a visual basic program I need to count the number of characters used in a cell. For example, if cell A1 in a workbook contains the text: How are you today?, the function or macro should give: function(A1) equals 15.
Thank yo in advance for your help.