Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/File access error (Error 75) 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 -- Fuzzy logix |
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 (Error 75) after using Name Statement | Excel Programming | |||
Path/File Access Error | Excel Programming |