excel problem - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

excel problem

excel problem# Database - 数据库

l*n2008-10-29 07:10

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*e2008-10-29 07:10

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*k2008-10-29 07:10

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*t2008-10-29 07:10

4 楼

FYI: http://www.vb-helper.com/howto_excel_save_without_macros.html

as

【在 l******n 的大作中提到】

c*t2008-10-29 07:10

5 楼

another approach is to use VSTO. End user will see data, all code behind are
binary code, invisible to them.

as

【在 l******n 的大作中提到】

l*n2008-10-29 07:10

6 楼

thanks

【在 c**t 的大作中提到】

: FYI: http://www.vb-helper.com/howto_excel_save_without_macros.html
:
: as

l*n2008-10-29 07:10

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();