Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/File access error (Error 75) after using Name Statement
I wrote the following code to rename a folder based on information entered
into an excel file contained in the folder ' ROUTINE TO MODIFY EXISTING INFORMATION If Workbooks("FILE MANAGEMENT SYSTEM.xls").Sheets("ONE").Range("CHANGE_EXISTING" ).Value = "YES" Then Set InformationRegister = Application.Workbooks("INFORMATION.xls").Sheets("I nformation register") Call WritetoInfoRegister Application.Run ".xls'!TenderInfoReport" Call OpenRegister ' open register file Call RewriteToRegister ' write new information to file Call CLOSERegister ' close register file Application.Workbooks("INFORMATION.xls").Save Reset Call RenameFolder End If End If End If The RenameFolder reads Sub RenameFolder() Dim OldName As String Dim NewName As String Dim dummyvar Call CalcPath ' define the folder names OldName = path & " " & Workbooks("FILE MANAGEMENT SYSTEM.xls").Sheets("START"). _ Range("ProjShortName") & " " & Workbooks("FILE MANAGEMENT SYSTEM.xls").Sheets("START"). _ Range("status2") NewName = path & " " & Workbooks("FILE MANAGEMENT SYSTEM.xls").Sheets("START"). _ Range("ProjShortName") & " " & Workbooks("FILE MANAGEMENT SYSTEM.xls").Sheets("START"). _ Range("bidstatus") dummyvar = "C:\File Setup" Name OldName As NewName End Sub This is a very small portion but is the revelant section of the the code I have tried the workaround found for excel 2000 to reset the pointer and it has not worked is there anyone who may have any ideas -- Fuzzy logix ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Path/File access error: '.\VB??.tmp' | Excel Programming | |||
Path/File access error | Excel Discussion (Misc queries) | |||
Path/File access error: '\VBx.tmp' | Setting up and Configuration of Excel | |||
Path/File Access error: "VB3B.tmp | Excel Programming | |||
Path/File Access Error | Excel Programming |