• Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • Vlookup Worksheet Function

    I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

    Hunter115 pointsBadges:
  • Meeting Invitation not updated in Calendar

    I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for any...

    Subbu2k990 pointsBadges:
  • Using Lotus Domino Objects

    Is it still possible to use Lotus Domino Objects (domobj.tlb) in programs other than Notes? A few versions back I was able to use the reference from VB6 and VBA. Now when I try to use the object from MS Office VBA I get an automation error. I'd really like to read some messages in VBA and send from...

    BobH65 pointsBadges:
  • Access – Bound sub form trying to set the value of an unbound field

    I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

    TJay85 pointsBadges:
  • Combobox Intro. Question

    Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...

    Kiki83025 pointsBadges:
  • Revision clouding on selected cell

    I need to cloding e.g. revision clouding accors the selected cell. Can you help me to write macro for the same.

    Bhavubhai5 pointsBadges:
  • Extract all instances of a search between two symbols

    Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....

    Gotovamsee5 pointsBadges:
  • Import data from Lotus notes into Openoffice

    I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to Open...

    Silvius5 pointsBadges:
  • Excel VBA cell.find

    I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell G1 and looks for text...

    Sswcharlie5 pointsBadges:
  • SQL or VBA code to loop through two columns of data

    I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product...

    Limey5 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • Viewing sametime user status on lotus via vba

    Hi. I am newbie in this vba-lotus work, and right now I need to know if there is any vba class that allows to see via code a certain user state on lotus and if the status is disconnected, send a mail to ask for getting connected. I really appreciated all help that you can give, including telling me...

    Jansaduster5 pointsBadges:
  • Replacing this ListBox code with Treeview code in VBA

    I am importing the Board file and loading the data into treeview directly(Busname as parent node and NetName as Child node with delimitor as ! and i have taken the (myArray(i), "!")(1)) as Bus name and (myArray(i), "!")(2)) as Netname. Simultaniously i am tracking the Duplicate Netnames Listedin a...

    Maheshvba5 pointsBadges:
  • Microsoft Word 2003 VBA Endnotes

    I have a report that I am creating in MS Word 2003 VBA. I need to place some text at the bottom of each section in a Footnote or Endnote. The report is not behaving and the Word Help is not helping, does anyone know a good site to explain how to use and give examples of using Endnotes and Footnotes?

    Flyght55 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • Link Outlook Calendar to Excel Spreadsheet

    Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...

    Yosiniro5 pointsBadges:
  • VBA How to get cpu usages and updated in every one hour,in with in the system.

    How to get cpu usages and updated in every one hour,in with in the system.

    Rajuaruna70 pointsBadges:
  • Microsoft Excel to VBA

    We are working on a spreadsheet that we need to run with VBA. I need a field to hold "". when running it in VBA it gives me 4 to 8 "". How do I get it to just give me 2 ""?

    Chilipepperz35 pointsBadges:
  • ComboBox in Microsoft Excel VBA

    HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

    Narmadha5 pointsBadges:

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