Open excel files from sharepoint by using word wba

		Microsoft Office Forums > Microsoft Word > Word VBA
Open excel files from sharepoint by using word wba

11-04-2021, 08:23 AM

Peterson

Windows 10 Open excel files from sharepoint by using word wba

Office 2019

Competent Performer

Join Date: Jan 2017

Posts: 143

To get the full path, i.e., C:\Users\username, use:

Code:

Environ("USERPROFILE")

This function does not include a backslash at the end, so your code will need to include it:

Code:

strWorkbook = Environ("userprofile") & "\" & "YOUR PATH HERE\Word List.xlsx" ' The workbook path

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.