Help to debug VBA code for Excel 2007
I’m trying to have Excel look at the contents in Cell E (Account #2) and match it with A,B,C and extract to another sheet. B cell goes to 427,776 rows and E cell goes to 1,406. The end goal is to get the Salesforce ID & Company name lined up with the accounts in Account [...]

Answer Question   |  October 1, 2012  2:59 PM
excel, VBA editor

Printer Orientation Control using VBA Code
I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?

Answer Question   |  June 1, 2011  9:29 PM
VBA, VBA editor, Visual Basic, Visual Basic developers

Dir() Function doesn’t find .pdf files in Access 2003
I’ve used the Dir() function with VBA several times for different file formats, but for some reason it’s not working on .pdf files. Am I missing something?

Answer Question   |  January 28, 2011  10:40 PM
Access 2003, Dir() function, PDF, VBA, VBA editor, Visual Basic

Find and replace text in text file using MS Access VBA
Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text. Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim [...]

Answer Question   |  May 8, 2013  11:46 PM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation

use vba to draw graphics in ms word
can vba create drawing “free hand” or by joining forms and circles together (putting one near another is good enough)

Answer Question   |  June 6, 2008  4:04 PM
Microsoft Word, objects, VBA, VBA editor