How can I use VBA read XPS file! Currently using the Set fo=fs. OpenTextFile (strPath, 1, True, TristateTrue), read is garbled,

What is the way to read is not gibberish

CodePudding user response:

https://msdn.microsoft.com/en-us/library/windows/desktop/dd316976 (v=versus 85). Aspx
File format details not found, only the XPS data of API

CodePudding user response:

You use "fs. OpenTextFile"?
These documents is "text file" won't...

Is very simple, if you use the system of "notepad" open, can "normal display content", so it's possible to use this way, otherwise, don't even think about it,
Such as Word documents, Excel document that, you use a "text" to open, no matter how you read it, it would be "gibberish",

CodePudding user response:

The

refer to the original poster dongchem response:

could you tell me how to use VBA read XPS file! Currently using the Set fo=fs. OpenTextFile (strPath, 1, True, TristateTrue), read is garbled,

What is the way to read not garbled

XPS somehow is also the format of the picture, please do not use OpenText to read, somehow using binary way,

CodePudding user response:

XPS is a virtual printer files, can be converted into a ps (postscript) and then using vb to read