+ Reply to Thread
Results 1 to 1 of 1

Writing to a text file

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2016 / 2019

    Writing to a text file

    Is it possible with Excel VBA to write to an online text file? I am using a text document to store the next sequential number for invoice numbering. This text document is stored in OneDrive. My current code works well when the file is on a local or network drive, but it is thrown for a loop by the "https://..."

    Here is a sample of the code:
    Please Login or Register  to view this content.
    How can I rewrite this to accommodate a URL with forward slashes?
    Thank you for your assistance.
    Last edited by pinebush; 03-07-2016 at 08:27 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Export specific range to text file and import the text file if needed
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 07:38 AM
  2. Loop through Code that copies the content of a text file to another text file
    By michiel soede in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2013, 01:34 PM
  3. Replies: 2
    Last Post: 08-16-2013, 02:45 AM
  4. Replies: 1
    Last Post: 02-23-2013, 08:36 AM
  5. Copy Excel to Text file and pass Text file to Access Table
    By robbie_xcell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 01:53 PM
  6. Importing a text file to an existing sheet, with a dialog to pick the text file
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2011, 01:43 PM
  7. looping, Open text file, copy text, close text file
    By jwilds1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2009, 05:12 PM

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1