Open excel files from sharepoint by using word wba

gmayor · #1 11-03-2021, 07:26 AM

I have little experience with Sharepoint, but it uses internet style paths rather than Windows filing system paths. As long as the code can access the sharepoint location the appropriate path can be substituted in the code.

What is the result of Environ("HOMEPATH") ?
You cannot however use Environ in the Const strWorkbook. Define strWorkbook as a string variable and set the value of the string to the location of the workbook.

gomezaka · #2 11-03-2021, 07:44 AM

Quote:

Originally Posted by gmayor

I have little experience with Sharepoint, but it uses internet style paths rather than Windows filing system paths. As long as the code can access the sharepoint location the appropriate path can be substituted in the code.
What is the result of Environ("HOMEPATH") ?
You cannot however use Environ in the Const strWorkbook. Define strWorkbook as a string variable and set the value of the string to the location of the workbook.

Thanks for your reply

The result is C:\Users\currentuserprofile\ , but this is only half of the adress. THe only constant in the adress is what comes after.(for example \files\test.xlsx. The first part has to depend on which user who is logged in.

Is there an way to combine the results of envirion and the string \files\test.xlsx into the second part of your code?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
hyperlink to open pdf files in excel	sharathnarayanan	Excel	8	06-21-2021 03:50 AM
Cannot open some Excel and Word files.	melvin1942	Excel	1	11-17-2019 04:41 PM
Excel Office 2010 Files will not open outside of excel	stevetag	Office	3	06-22-2014 07:23 PM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM
Excel Files Will Not Open From Documents Normally	tremaine	Excel	1	06-17-2009 08:05 AM