error 76 path not found

**swe1** · 03-30-2009, 10:13 AM

Hi,

I an trying to write a macro to copy the last row from one workboo1 and paste it in workbook2. After pasting it needs to rename the second workbook in a new folder.
Folling is the code.I am experiencing some problems like.
error 76 Path not found.
When i am trying to create a new folder.First i need to check if that folder exists or not.if it does it needs to save this workbook2 in that folder,otherwise create the new folder with that name and then save it.
Please help.

Please Login or Register  to view this content.

**royUK** · 03-30-2009, 10:58 AM

keep your code tidy, declare all variables before the actual code. Also, you haven't declared all your variables.

You shouldn; need to activate the workbooks.

Depending on the format of Mydate you might not get a correct file name. Although in your code Mydate is a Row number!

This is untested

Please Login or Register  to view this content.

**swe1** · 03-30-2009, 11:58 AM

Thanks royuk.

I tried ur code and made it organised. But i still get the error 76 path not found. Please help.
A little change in my task now.
I dont want to create this new folder now but look for that folder which is already existing. If this folder is not existing then show a message box saying folder not found so create first and then generate this report.

Please Login or Register  to view this content.

**royUK** · 03-30-2009, 12:51 PM

What is GetDate returning, an example workbook would help.

**swe1** · 03-30-2009, 01:21 PM

Get Date = 3/9/2009

I am attaching both the workbooks.
thanks for ur help.

**royUK** · 03-31-2009, 02:08 PM

GetDate is returning an invalid format for naming a Folder. Try this

Please Login or Register  to view this content.

**swe1** · 03-31-2009, 08:09 PM

Thanks RoyUK !
It works.
But i need to do little bit more to it now.
The folder is already existing .So i just need to find that folder and save workbook2. And if the folder is not existing then a msgbox saying folder does not exists. Please Help.

Please Login or Register  to view this content.

End Sub

error 76 path not found

LinkBack

Thread Tools

Rate This Thread

Display

error 76 path not found

Re: error 76 path not found

Re: error 76 path not found

Re: error 76 path not found

Re: error 76 path not found

Re: error 76 path not found

Re: error 76 path not found

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions