1
  • 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...

    Vgnadeau15 pointsBadges:
  • 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 #2. I’ve got to load...

    cheekymonkey5 pointsBadges:
  • 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?

    KingsITI50 pointsBadges:
  • 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?

    McNitro255 pointsBadges:
  • 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)

    Elad Karako255 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following