I have a excel spreadsheet uploaded to onedrive which is shared amoung users for updating purpose. This workbook is used for task tracking purpose by our managers. Now this needs to be automated using VBA but I dont think it is possible in a shared environment. Is it?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
It is possible to run VBA on sharepoint?
0
Discussion
Hi Cartus. If you mean can a given .xlsm workbook be run from a SharePoint location then yes, it should be possible. I'm not working now (so not using SharePoint at present) but did that in that past. You might need to enforce a rgime of Check Out/ Check in (which might work against multiple concurrent users)
I've also used VBA to interrogate SharePoint sites (to extract heirarchies and extract files etc.).
I've also used VBA to interrogate SharePoint sites (to extract heirarchies and extract files etc.).
John_Ru (rep: 6142) Nov 30, '20 at 7:49 am
The excel file is .xlsx in sharepoint and the process is, it should fetch data from a .txt file situated in a local drive and paste into excel shared point.
As you said it should be in .xlsm to work with VBA, is it possible to rename the extension because it contains important sheets and data that other team is using.
As you said it should be in .xlsm to work with VBA, is it possible to rename the extension because it contains important sheets and data that other team is using.
Cartus (rep: 2) Nov 30, '20 at 8:04 am
You mean you want a local macro-enabled workbook (per manager) to extract the .txt from the local drive and submit that to the remote Sharepoint. Does each manager have their own sheets(s) within the remote workbook?
John_Ru (rep: 6142) Nov 30, '20 at 8:59 am
I mean there is a workbook named abc.xlsx sharepoint workbook and there is a locally saved .txt file.I want to extract data from txt file to abc.xlsx through vba.
Reagrding manager having their own sheets, I am not sure because there are like 10+ odd sheets in abc.xlsx.
Reagrding manager having their own sheets, I am not sure because there are like 10+ odd sheets in abc.xlsx.
Cartus (rep: 2) Nov 30, '20 at 11:20 am
Cartus, I haven't done that but it seems possible. Please revise your Question to add the clarification above and given an idea on the text file- is it a fixed format CSV? Hopefully then someone more knowledgeable can answer, most likely Don or Variatus.
In general, the more you tell us (within reason!) the better your chance of a reply. An attached sample Excel file is often the key to our understanding.
In general, the more you tell us (within reason!) the better your chance of a reply. An attached sample Excel file is often the key to our understanding.
John_Ru (rep: 6142) Nov 30, '20 at 11:26 am
Sure. I will do that.
Cartus (rep: 2) Nov 30, '20 at 11:46 am
Thanks
John_Ru (rep: 6142) Nov 30, '20 at 11:47 am
Is see you have posted a separate question (when I meant you should edit this Question). Not sure what responses you will get...
John_Ru (rep: 6142) Nov 30, '20 at 12:46 pm