User Profile

Collapse

Profile Sidebar

Collapse
bansod
bansod
Last Activity: May 6 '20, 04:50 PM
Joined: May 2 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • bansod
    replied to VBA Close a text file without saving
    I think I've solved my own problem.

    Instead of opening the file, modifying it, saving it and then reading it back, I am just reading the file into an array and making modifications in the array before using it further in the program. I never write anything back to the file and it never changes.

    Here is the new code:

    Code:
    Dim FSO As Object, MyFileObj As Object
    Dim ExtDictionaryPath As String
    Dim
    ...
    See more | Go to post

    Leave a comment:


  • bansod
    started a topic VBA Close a text file without saving

    VBA Close a text file without saving

    I wonder if someone can help on this question.

    I want to be able to open a text file in Excel VBA, make some changes to it, use the changed data in the rest of the code, and then close without saving the file. In other words I want to leave the original file (which is a reference) untouched. I cannot find any way to do this.

    What I am doing is reading an English word dictionary text file to use as a reference. The code...
    See more | Go to post
    Last edited by gits; May 3 '20, 06:12 PM. Reason: added code tags
No activity results to display
Show More
Working...