Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
This is a followup to a question I posted earlier.
I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
Folder = ActiveWorkbook.Path
NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
Thanks for your help, but it's not quite what I'm looking for.
I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
Excel will work the URL that start with \\drive\folder. You don't need c:\
drive letters. "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
OK, would you be able to help me with the statement(s)? I don't use VBA
enough to easily figure this out. For desktop version, I used ChDir and ChDrive to control the path and then used Frombook = Dir(*.xls) when opening each of the workbooks in the path (without the first 2 statements, the 2nd always points to D drive). For sharepoint, I'm still lost on what function or statement I should be using to achieve. And/or how to incorprate activeworkbook.path with it. I set SPPath = activeworkbook.path, then I tried Frombook = Dir(SPPath & ".xls") but this doesn't work. lol, I have tons of test scenarios I'm trying out that are laughable. Hence why I need help from the forum. Excel will work the URL that start with \\drive\folder. You don't need c:\ drive letters. "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
Check out this site. It might answer your questions.
http://technet.microsoft.com/en-us/l.../cc288173.aspx "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
Thanks for the link. It's not quite what I was looking for, but came in
handy for someone else in my department. "JLGWhiz" wrote: Check out this site. It might answer your questions. http://technet.microsoft.com/en-us/l.../cc288173.aspx "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
It does work very much the same as LAN folders if you map the sharepoint
drive. Have you tried it? -- HTH, Barb Reinhardt "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping to sharepoint drive
I just haven't worked with coding URL stuff before and I guess I was making
it more difficult then it needs to be. I just now was finally able to get a workbook to open. Thanks for everyone's help. "Barb Reinhardt" wrote: It does work very much the same as LAN folders if you map the sharepoint drive. Have you tried it? -- HTH, Barb Reinhardt "PurpleMilk" wrote: Thanks for your help, but it's not quite what I'm looking for. I'm not creating/saving any file in the macro - it opens up each of workbooks within a folder to see if there is a specific tab name, if yes, I copy a specific row of data from the opened workbook into the file I launch the macro from, then close the other file and go open the next. The issue with sharepoint is it's url based not drive based and doesn't work the same as in LAN folders. "Joel" wrote: Folder = ActiveWorkbook.Path NewFile = "book1.xls" ThisWorkbook.SaveAs Filename:=Folder & "\" & NewFile "PurpleMilk" wrote: This is a followup to a question I posted earlier. I'm only so-so at VBA, so I'm stuck. I thought this would be easier, but this is the first time I'm working with URL's. I need to run a macro in Sharepoint that accesses other files residing in Sharepoint but can't figure out what the function/statement is to do this. I can do this on desktop folders by using the following statements to simply default the path to whichever folder the macro runs from (the macro is not drive specific - can run anywhere): ChDrive ActiveWorkbook.Path ChDir ActiveWorkbook.Path I would like to do similar in Sharepoint folder (again, the macro could reside in different Sharepoint olders). It was mentioned earlier for me to use the Sharepoint URL somehow (which I know the current one, but not future ones), but I can't seem to find the write statement to use. Any suggestions? NOTE: I would have appended this to earlier question, but had already closed it off. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel links & SharePoint 3.0 (worked fine with SharePoint 2.0) | Excel Discussion (Misc queries) | |||
How to get network drive mapping | Excel Programming | |||
Links broken - UNC vs drive mapping | Links and Linking in Excel | |||
Saving to a netword folder without mapping drive | Excel Programming | |||
Mapping a drive through a macro | Excel Programming |