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
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
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
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
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