MS Excel / VBA help thread

You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.

•

dst2

I would like to open the open file dialogue using VBA from a pre specified location on a sharepoint site. I can open the open dialogue bow using GetOpenFilename. How can I make sure the open dialogue box is always pointing at the correct place?

For bonus points, can I also filter files based on the filename (with wild card)? i.e. the file name structure will be filename_yyymmdd. I'd like the user to only see files with the filename string in them.

and sorted by date for even more ageing fixeh sidder points.

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/application-getopenfilename-method-excel

•

NotThamesWater in reply to @dst2

sorted by date

I reckon you would struggle to do this with .net or vb, let alone VBA.

A diiiirty way could be to have a VBA application caller insert a dword value into the registry to force the sort order, and then remove it when the sub is run. The walk away when your PC stops running.

About

Avatar for NotThamesWater @NotThamesWater started