You could then click that link any time to open the Sales spreadsheet. Add this functionality to your spreadsheets by creating a short VBA macro that generates links to external spreadsheets on ...

I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access ... BR><BR>Easy: Have VB open the file, then search it looking for a ...

The file I'm attempting to open is an XLSX file. According to everything I've read this is the correct connection string for an XLSX file. Interestingly, this connection string WILL successfully ...