Re: [ExcelVBA] Uploading file with date and time in name

 

John,

Sorry I am getting a run time error 1004

The file could not be accessed.

20110519_234845.HOSPSERVPROV.txt

This is the new file name but I am not seeing any colons.  I did copy the
_234845, which is the time stamp and pasted that to the module.
"_234845.HOSPSERVPROV.txt" this worked but I need the macro to grab the file
just based on the date and the HOSPSERVPROV.txt portion.

I hope I am being clear but if not let me know and I will give it anopther try..

Thanks,

Mark

________________________________
From: Dr John C Bullas <john.bullas@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Thu, May 19, 2011 10:22:57 AM
Subject: Re: [ExcelVBA] Uploading file with date and time in name

 
Any error messages?
is it failing to save or just failing

remember the time includes a ":" which is incompatible with fillename
conventions

On 19 May 2011 15:16, m_bacheldor <m_bacheldor@yahoo.com> wrote:
> Good Morning,
>
> I have a macro that I wrote and it had been working fine until the file name
>was changed to include the time. Below is the code and file name that worked
>previously.
>
> Sub Upload()

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 8

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___