• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 95
  • Last Modified:

Can Microsoft SharePoint will give access for macro enabled excel sheets?

Hi,
Can we export an excel sheet with VBA (i.e, xslm sheet) to sharepoints?

If yes how to export the macro enabled sheets to sharepoint , and how to run from sharepoints?  Can you explain?
Thanks in advance..
0
Saha c
Asked:
Saha c
  • 3
  • 3
1 Solution
 
KoenChange and Transition ManagerCommented:
if export means, can I share/store the file on sharepoint, than yes, no problem, just save it to the sharepoint site.

can you run it from sharepoint? again, depends on what you are saying:
you can double click the file and it will open, however macro's can not be run in the online excel, it will require you to open the file with a local excel client.
0
 
Saha cAuthor Commented:
Thanks..

In case we want to run macros online then how to do it?
How to connect with a local excel client?
I am new to that so I don't know
0
 
Roy CoxGroup Finance ManagerCommented:
As far as I know, no version of Excel  can run macros from online sources.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
KoenChange and Transition ManagerCommented:
to open the file with local excel, there are basically 2 ways:

- instead of just clicking on the file, you right click and select open with Excel
- you could specify the library to open the files with Excel instead of online (but that is than for all files).
0
 
Saha cAuthor Commented:
OK thanks for your  suggestions..

Can we do it from any VBA code?

I mean to say, applying any visual basics code  can we implement that?
0
 
KoenChange and Transition ManagerCommented:
I'm sorry but your question is not clear...

You can open an excel from vba...but that would be in another excel...problem stays the same.
0
 
Saha cAuthor Commented:
OK  thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now