Ars Technica

VB: Need to open a .txt file, and then parse it with VBA... help please

I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access in that case) and then ideally place it inside a table format, at the very least ...
TechRepublic

Demonstration files: How to execute a VBA sub procedure in Microsoft Excel

This is the demonstration file to accompany the article, How to execute a VBA sub procedure in Microsoft Excel by Susan Harkins. From the hottest programming languages to commentary on the Linux OS, ...
Ars Technica

Reading External Excel Files from VBA

I have about 50 excel spreadsheets all saved in separate files but they all have the exact same format. I need to basically consolidate all of the data.<BR><BR>Is there a way, using VBA, to read in ...
TechRepublic

Use VBA to insert a picture file onto a PowerPoint slide

Use VBA to insert a picture file onto a PowerPoint slide Your email has been sent If you often insert the same graphic file, such as a company logo onto a PowerPoint slide, use VBA to automate the ...
The Next Web

Want your Microsoft Excel files to almost run themselves? Master VBA for just $25

Mastering software is all about understanding the hidden tricks in an app that save time while still getting the job done right. How often have you wished you could just automatically remove all those ...