Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. The following code illustrates how the FileSystemObject object is used to return a TextStream object that can be read from or written to:. Have questions or feedback about Office VBA or this documentation?
Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. I suspected it might be something along those lines. Our Attach directory is huge because users are uploading some rediculously large attachments. We would prefer to prevent the users from uploading the file to begin with.
We opened a ticket with HP to find out how. We were told that there was no configuration in QC to limit the attachment size and they provided us with the workflow code that I have been dealing with. They explained that QC cannot determine the size of the file until it is uploaded, thus the code looks at the file size once it is uploaded then if it is larger than the size you set, it then alerts the user and deletes the file.
At least that is how it is supposed to work. I need to work with the UNC and see if that works. Thank you. Using the UNC path solved the problem. I did not realize, until it was explained to me this morning, that the workflow code is executed on the users local system and as such looks on the local disk if the UNC path is not used.
So, the code is all working now, there is only one last thing that is not happening and I'm not sure if it is addressed by the code.
The code is deleting the file and removing the icon from the Attachment tab in the record. However, when the record is displayed in the Defect grid it retains the paperclip icon in the left margin that indicates that is has an attachment. When you open the defect there is no evidence of an attachment.
Any idea why the paperclip is not removed. I've included the section of code below that removes the attachment. Thanks for your help. Command com. I think it's because you are not doing the delete using the approved methods. This means that your users all have access to write OTA scripts that can delete whatever they want from the database.
Echo "That song was added to end of list. Close But I'm not sure how to add text to the file. Add a comment. Active Oldest Votes. How about this Close End With If Err. Echo "File access error" WScript. Echo "File does not exists" Wscript. WriteLine strSearchFor. Close End With Wscript. I discourage this approach as it makes it harder to share the file with other users without having to explain how to reference the library.
The native VBA approach is better for creating binary files or writing to files. Below are examples show how to check if one of these exists or is missing. The FileSystemObject allows you to copy files and folders. Lookup CopyFile and CopyFolder on details:.
However, it comes useful when you want to obtain file or folder properties.
0コメント