数据不固定长度vba编程文本文件 [英] data not fixed length vba programming on text file

问题描述

我想通过文本文件上的vba编程打印报告，但问题是我根据数据结构长度发现数据在报告上没有固定长度。我希望数据类型文本的细节字段和字段大小5总是占用5个字符的空格，即使它是空白或2个字符。如果我以dbf格式导出它可能通过foxpro而不是在vba中。

请帮助打印报告通过vba

thanx提前

i want to print report through vba programming on text file but the problem i find that the data is not of fixed length on report according to data structure length. i want that for detail field of data type text and field size 5 will always occupy space of 5 characters even if it is blank or of 2 character.if i export it in dbf format its possible through foxpro but not in vba.
kindly help to print report through vba
thanx in advance

推荐答案

kkshansid，


你能给我们一个你想要的例子吗？例如，您是否希望显示前导或尾随字符以填充额外的空白空间？请解释并向我们展示你到目前为止所尝试的内容....

kkshansid,

Could you give us an example of what you are looking for? For example, do you want leading or trailing characters displayed to fill up extra empty spaces? Please explain and show us what you have tried so far....

展开 | 选择 | Wrap | 行号

是你要这样做：
http://office.microsoft.com/en-us/ac...010006905.aspx

-z

Are you tring to do this:
http://office.microsoft.com/en-us/ac...010006905.aspx
-z

这篇关于数据不固定长度vba编程文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！