Can Excel VBA extract data from a file without opening it?

Answer It should not take more than a fraction of a second to open a simple file, get a bit of data from it, and then close the file.But since you did not say what version of MS-Excel you are using, nor w... Read More »

Top Q&A For: Can Excel VBA extract data from a file without ...

Opening an excel file and display all values without opening their links?

It would have helped to know which version of MS-Excel you are using, and optionally what update level.As to the external links sometimes having the correct value, and other times having the "N/A#"... Read More »

How to Extract Data From a CAB File?

CAB files are utilized by Microsoft for installations of Windows system files and components, and are also used as installation packages for the Windows Mobile operating system. A Cabinet (CAB) fil... Read More »

How do I extract data out of a pst file?

Outlook uses a personal storage file, or pst file, to store email messages, calendar items, contacts, journal entries, tasks and notes. If your Outlook profile is not configured with a direct conne... Read More »

I've a excel file of list of Birthdays. Is there a reminder s/w where I can feed data from the file in one go?

If you have the full MS-Office suite of products, then you can use the Excel file of Names and Birth Dates to work with Outlook and its way of handling Calendars and Reminders.Or, you can do some V... Read More »