+ Reply to Thread
Results 1 to 4 of 4

Writing property to closed file with DSO File

Hybrid View

  1. 03-02-2019, 06:40 AM #1
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Writing property to closed file with DSO File

    Hi,

    I have multiple workbooks in a predefined directory and I need to changed "Tag" property of all the files to "Completed" programmatically. I have installed the DSO file and also using the function of Cpearson (writepropertytoclosedfile)
    All my files are with ".xlsm" extenstion.

    Help would be greatly appreciated

    Imran Bhatti
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  2. 03-26-2019, 01:53 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Writing property to closed file with DSO File

    How is this different from your post here?
    https://www.excelforum.com/excel-pro...ml#post5090189
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 04-02-2019, 04:24 AM #3
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Writing property to closed file with DSO File

    Quote Originally Posted by FDibbins View Post
    How is this different from your post here?
    https://www.excelforum.com/excel-pro...ml#post5090189
    May be I forgot that post due to late response. Will check the solution there and let the helper know.
    Reply With QuoteRegister To Reply
  4. 03-26-2019, 07:20 AM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Writing property to closed file with DSO File

    Can you share the code that you have till now?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need help in writing a vba script to run a macro (.xlam file) on a .csv file
    By NeoDasari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2015, 02:02 PM
  2. Data from closed xlsm file without defined file path???
    By dbrizor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2015, 07:27 AM
  3. [SOLVED] BeforeClose event not running/working when file is closed through VBA in another file
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2014, 03:43 AM
  4. [SOLVED] strange sumifs problem, works with file open, #value with file closed
    By neowok in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2013, 05:32 AM
  5. Copy Data from Closed File to Existing File
    By srikanthbenoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2012, 08:36 AM
  6. Writing to Closed Excel File
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2010, 08:19 PM
  7. Excel is not asking to save a changed file when the file is closed
    By Ron in forum Excel General
    Replies: 2
    Last Post: 03-13-2005, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1