hidden files

Hi, I currently have the below code to pull a list from a file path every time the worksheet is activated. Sub worksheet_Activate() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder =...

Hi all, Full disclosure, I am still learning VBA, am not very good yet, and hoping someone can help. I currently have a script (not written by myself) being used at my office. It used to run fine but now is throwing an error because it is picking up a file called "thumbs.db". After some due...

I'm distributing a number of USB devices containing a lot of files and reports which people require regular access to, basically to save printing so much out and havign all the information to hand on such a small object. The USB device will autorun and show a html file which develops into an...