l******n
发帖数: 9344 | 1 I have a excel file containing many VB codes. I need to save the results as
records. But I do not want the buttons and VB codes saved in the records.
How can I do that? Now I am using saveas, and set the buttons in records
invisible. The codes are still there.
Thanks you, |
b*****e
发帖数: 364 | 2 If you can provide some screen shot, it will be better for people to learn
what you are doing.
as
【在 l******n 的大作中提到】
: I have a excel file containing many VB codes. I need to save the results as
: records. But I do not want the buttons and VB codes saved in the records.
: How can I do that? Now I am using saveas, and set the buttons in records
: invisible. The codes are still there.
: Thanks you,
|
S***k
发帖数: 370 | 3 I guess you have VB code to create the excel file, and the created excel
file includes not only the results but the VB code itself also.
If this is the case, you may try
This.Visible = false;
Response.clear();
Response.ClearContent();
Response.ClearHeaders();
Response.WriteFile(…);
Response.End(); |
c**t
发帖数: 2744 | 4 FYI: http://www.vb-helper.com/howto_excel_save_without_macros.html
as
【在 l******n 的大作中提到】
: I have a excel file containing many VB codes. I need to save the results as
: records. But I do not want the buttons and VB codes saved in the records.
: How can I do that? Now I am using saveas, and set the buttons in records
: invisible. The codes are still there.
: Thanks you,
|
c**t
发帖数: 2744 | 5 another approach is to use VSTO. End user will see data, all code behind are
binary code, invisible to them.
as
【在 l******n 的大作中提到】
: I have a excel file containing many VB codes. I need to save the results as
: records. But I do not want the buttons and VB codes saved in the records.
: How can I do that? Now I am using saveas, and set the buttons in records
: invisible. The codes are still there.
: Thanks you,
|
l******n
发帖数: 9344 | |
l******n
发帖数: 9344 | 7 thanks
【在 S***k 的大作中提到】
: I guess you have VB code to create the excel file, and the created excel
: file includes not only the results but the VB code itself also.
: If this is the case, you may try
: This.Visible = false;
: Response.clear();
: Response.ClearContent();
: Response.ClearHeaders();
: Response.WriteFile(…);
: Response.End();
|
