Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA (Ex
I have an Excel application which needs to move the workbook to different
Sharepoint library (directory) depending on the step in the process. The application is a combination of Worksheets and VBA modules. Each step is initiated by clicking a command button that is embedded in the excel worksheet. The current workbook is then moved to the new directory. The move is accomplished via a SaveAs command. What I'm having problems with is deleting the original version of the workbook left behind after the new file has been saved in the new directory/library. I have tried Kill and the FSO.DeleteFile method with no results. I want to accomplish this using VBA within the application workbook. I have accomplished this a number of times in prior projects outside of Sharepoint server. This is my first project using Sharepoint Server, which may account for part of the reason (not being familiar with the correct way to do this in the Sharepoint environment). I can even run this application on my local drive with no problem. Is there a solution or direction I can look in to resolve this?? Anyone who can assist, please let me know as soon as possible. Thanks, Ken Etter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA (Ex
I've run some macros from within excel on Sharepoint server and the way I
accessed the files was using a mapped drive. It might work if you accessed them that way. -- HTH, Barb Reinhardt "Net_prof" wrote: I have an Excel application which needs to move the workbook to different Sharepoint library (directory) depending on the step in the process. The application is a combination of Worksheets and VBA modules. Each step is initiated by clicking a command button that is embedded in the excel worksheet. The current workbook is then moved to the new directory. The move is accomplished via a SaveAs command. What I'm having problems with is deleting the original version of the workbook left behind after the new file has been saved in the new directory/library. I have tried Kill and the FSO.DeleteFile method with no results. I want to accomplish this using VBA within the application workbook. I have accomplished this a number of times in prior projects outside of Sharepoint server. This is my first project using Sharepoint Server, which may account for part of the reason (not being familiar with the correct way to do this in the Sharepoint environment). I can even run this application on my local drive with no problem. Is there a solution or direction I can look in to resolve this?? Anyone who can assist, please let me know as soon as possible. Thanks, Ken Etter |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA
I've gotten around that by using some code to select the folder and/or file
to use and the user can select it using their mapped name. -- HTH, Barb Reinhardt "Net_prof" wrote: Barb, I tried your suggestion, but it won't let me map a drive at the root directory. Because we have multiple subdirectories, one for each step in the process, this will not work. In addition, I am already questioning the feasibility of creating map drives that would require drive letter to be stored in the filepath for each step directory. If a company manager trying to use this did not have the same drive mapping, the application would not work for him. Any other suggestions would be great and are appreciated. Thanks, Ken "Barb Reinhardt" wrote: I've run some macros from within excel on Sharepoint server and the way I accessed the files was using a mapped drive. It might work if you accessed them that way. -- HTH, Barb Reinhardt "Net_prof" wrote: I have an Excel application which needs to move the workbook to different Sharepoint library (directory) depending on the step in the process. The application is a combination of Worksheets and VBA modules. Each step is initiated by clicking a command button that is embedded in the excel worksheet. The current workbook is then moved to the new directory. The move is accomplished via a SaveAs command. What I'm having problems with is deleting the original version of the workbook left behind after the new file has been saved in the new directory/library. I have tried Kill and the FSO.DeleteFile method with no results. I want to accomplish this using VBA within the application workbook. I have accomplished this a number of times in prior projects outside of Sharepoint server. This is my first project using Sharepoint Server, which may account for part of the reason (not being familiar with the correct way to do this in the Sharepoint environment). I can even run this application on my local drive with no problem. Is there a solution or direction I can look in to resolve this?? Anyone who can assist, please let me know as soon as possible. Thanks, Ken Etter |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA
So you tried to remove it using VBA.
Have you tried creating a VBScript that removies it and calling the VBScript from VBA? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA
I don't understand why you want to save to a shared drive when you are
using Sharepoint. Can't you save there? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete file from Sharepoint Server Library using VBA
I couldn't map a SharePoint drive when my WebClient service was not running.
I don't know what turns it on/off, but that solved my problem. -- HTH, Barb Reinhardt "Net_prof" wrote: Barb, I tried your suggestion, but it won't let me map a drive at the root directory. Because we have multiple subdirectories, one for each step in the process, this will not work. In addition, I am already questioning the feasibility of creating map drives that would require drive letter to be stored in the filepath for each step directory. If a company manager trying to use this did not have the same drive mapping, the application would not work for him. Any other suggestions would be great and are appreciated. Thanks, Ken "Barb Reinhardt" wrote: I've run some macros from within excel on Sharepoint server and the way I accessed the files was using a mapped drive. It might work if you accessed them that way. -- HTH, Barb Reinhardt "Net_prof" wrote: I have an Excel application which needs to move the workbook to different Sharepoint library (directory) depending on the step in the process. The application is a combination of Worksheets and VBA modules. Each step is initiated by clicking a command button that is embedded in the excel worksheet. The current workbook is then moved to the new directory. The move is accomplished via a SaveAs command. What I'm having problems with is deleting the original version of the workbook left behind after the new file has been saved in the new directory/library. I have tried Kill and the FSO.DeleteFile method with no results. I want to accomplish this using VBA within the application workbook. I have accomplished this a number of times in prior projects outside of Sharepoint server. This is my first project using Sharepoint Server, which may account for part of the reason (not being familiar with the correct way to do this in the Sharepoint environment). I can even run this application on my local drive with no problem. Is there a solution or direction I can look in to resolve this?? Anyone who can assist, please let me know as soon as possible. Thanks, Ken Etter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to modify 2007 file on NAS server shared drive | Excel Discussion (Misc queries) | |||
excel is connected to sharepoint server and says too many members | Excel Discussion (Misc queries) | |||
Issue with Template Wizard and SharePoint Document Library | Excel Discussion (Misc queries) | |||
#VALUE error when referencing spreadsheet on sharepoint library | Excel Worksheet Functions | |||
file delete in Excel receives permission denied by Server 2003 | Excel Programming |