Copy all Files From K:\ drive to a folder

**cdowney** · 06-29-2013, 08:12 AM

I have a macro that works but I'm trying to schedule it with Windows Scheduler to run at a certain time in the "Run whether user is logged on or not" mode. I have multiple macro's that I'm doing the same thing and have no problems with them. This macro is set up as WorkBook_Open and runs great when I double click on it and also in the "Run only when user is logged on" mode. I am at a loss. I have looked at everything on this site about copying along with all over the internet and i've tried every code I could find. Some worked some did not, but none worked in the "Run whether user is logged on or not" mode. Any help would be appreciated.
The files are all .txt files.
I'm on a work computer and have Admin Rights
Windows 7 Enterprise
Microsoft Office Professional Plus 2007

Please Login or Register  to view this content.

**shg** · 06-29-2013, 08:58 AM

When you created the task in Task Scheduler, did you tick Run whether user is logged in or not?

Is the file in a trusted directory, or is the project digitally signed, so that the macro will run?

**cdowney** · 06-29-2013, 09:07 AM

shg thank you for the quick reply. Yes I have tick the Run whether user is logged in or not. I've set it up exactly like the other excel macro's that I have that work. They are all located in the same folder. How can I tell if the directory is a trusted directory? And I don't think the project is digitally signed..... I have not yet learned how to do that. but I have Macro settings set to "Enable all macros (not recommended;potentially dangerous code can run) and the Developer Macro Settings ticked off the box for Trust access to the VBA project object model.

**shg** · 06-29-2013, 09:13 AM

I have Macro settings set to "Enable all macros

I would seriously not do that.

How can I tell if the directory is a trusted directory?

Excel options > Trust Center > Trust Center Settings > Trusted Locations

**cdowney** · 06-29-2013, 09:31 AM

Ok. I set Macro Settings to "Disable all macros with notification". and I added the folder that all of my Macro's are in to the Trusted Locations. I tested some of the macro's that had been working and they worked fine. But I'm still having the same problem with this one. It says it's running in the scheduler but nothing is happening.

**shg** · 06-29-2013, 09:49 AM

Ah -- mapped drives don't work when you're not logged in. They are part of user settings. If it's a network share, use a UNC path.

**cdowney** · 06-29-2013, 11:00 AM

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\hshd>net use
New connections will be remembered.

Status Local Remote Network

-----------------------------------------------------------------------------
OK K: \\RETUS211-NT0001\EXCHANGE
Microsoft Windows Network
OK P: \\RETUS211-NT0001.ikea.com\Common
Microsoft Windows Network
OK U: \\RETUS211-NT0001\HSHD$ Microsoft Windows Network
The command completed successfully.

C:\Users\hshd>

So K is the drive I'm trying to use. How would I translate K:\ into UNC path?

This is what I have now

"K:\*.*", "\\RETUS211-NT0001.ikea.com\Common\Logistics\Chris\K_Drive\2013\today"

I've tried a few different ways with no luck.

**shg** · 06-29-2013, 11:10 AM

This should be the UNC path:

\\RETUS211-NT0001.ikea.com\Common\Logistics\Chris\K_Drive\2013\today

**cdowney** · 06-29-2013, 12:13 PM

shg thank you so much for your help. The UNC path for the K:/ ended up being \\RETUS211-NT0001.ikea.com\EXCHANGE\

you have helped me so much. Just learning about the UNC path has opened up my eyes to so much more.

Thank you again

**shg** · 06-29-2013, 12:24 PM

You're welcome, glad it helped.

Copy all Files From K:\ drive to a folder

LinkBack

Thread Tools

Rate This Thread

Display

Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Re: Copy all Files From K:\ drive to a folder

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions