Hello.
I have a vb script that works in Excel 2003 and now I need the script to work in Office 365.
I can paste the entire code if needed, but for starters, I am looking for the vb replacement for Application.FileSearch.
The code basically sets variables and searches the network drive for a particular folder (month) and then opens up a file and imports select columns back into a template.
I get an error: Object doesn't support this action: Run Time Error 445...... this happens on the following code line. Set fs = Application.FileSearch
Any ideas?
Thanks.
I have a vb script that works in Excel 2003 and now I need the script to work in Office 365.
I can paste the entire code if needed, but for starters, I am looking for the vb replacement for Application.FileSearch.
The code basically sets variables and searches the network drive for a particular folder (month) and then opens up a file and imports select columns back into a template.
I get an error: Object doesn't support this action: Run Time Error 445...... this happens on the following code line. Set fs = Application.FileSearch
Any ideas?
Thanks.