User Profile
BobOxford
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Stream Viewer in Teams vs. SharePoint/OneDrive
Given the roadmap feature ID 82039 "https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Microsoft%20Stream%2CLaunched#:~:text=Microsoft%20Stream%3A%20Updated%20Web%20player%20for%20video%20%26%20audio%20files%20in%20SharePoint%2C%20Teams%2C%20Yammer%2C%20and%20OneDrive" that is now in General Availability, I am wondering why the viewer in Teams Streams viewer has more functionality than when I open a video from our SharePoint tenant. Stream - SharePoint UI Stream - Teams UI Is there something our SharePoint admins need to do to get the better UI when viewing videos through SharePoint/OneDrive, etc.? Thanks. Bob OxfordRe: Macros/VBA not working
Dharmendra_BharwadHere is an Excel Workbook, in a Zip File, that Contains a UserFrom. You will need to Unzip the file first. The UserForm will run when you open the Workbook. The UserForm contains an Example of how to use the FileDialog to find a folder, or a CSV File. Hope that helps. Thanks for posing the code. FYI - when you post code, it makes sense to have it heavily commented, indented properly, and only post the portion of the code that is not working or where you need help.Re: Macros/VBA not working
Dharmendra_BharwadMight I suggest that you upload a text file of your macro rather than an *.xlsm file. I think people might find it a bit risky to download and open an Excel file that contains a macro. That being said, when you reference a file from your macro, it will generally assume the file you are referencing is in the same folder as the Workbook where you launched the macro. If it is in a different folder, you will need to provide the Fully Qualified path to the file and folder. If you want to provide a way to choose the import file, You can work with the FileDialog Object. Documentation on this object can be found at: https://docs.microsoft.com/en-us/office/vba/api/office.filedialog?f1url=https%3A%2F%2Fmsdn.microsoft.com%2Fquery%2Fdev11.query%3FappId%3DDev11IDEF1%26l%3Den-US%26k%3Dk(vbaof11.chm256000)%3Bk(TargetFrameworkMoniker-Office.Version%3Dv16)%26rd%3Dtrue&WT.mc_id=email Otherwise, you will need to provide some other way to get the FQ filename into your code. You could hard code it into your code, or provide a way for the user to enter the full path using an InputBox, but the recommended way would be to use the FileDialog Object. I hope that helps.
