Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel

Pages : 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74

1501. Macro doesn't work for other users
1502. VB6, Open an existing Excel template for editing from code, help
1503. Cutstom ToolBars: A Love/Hate Relationship.
1504. VLOOKUP with multiple ranges
1505. find string in the cell
1506. Disaggregating Formula Contents
1507. Format cells
1508. complex matching - need help!
1509. reading from Name Ranges
1510. looping through worksheet
1511. Exporting Macros to a Dll
1512. Search for Value, Then Cut/Paste Text New Worksheet
1513. Find & Cut/Paste
1514. Change margins in a word docfrom excel
1515. Using 'Trim' on a Selection of Multiple Cells
1516. Edit spreadsheet while UserForm is open
1517. Opening new file without "linking"
1518. Posting picture on command button
1519. Editing delete sheet control
1520. End Excel Process
1521. Protection
1522. Hiding rows in Excel 97
1523. searching through and editing excel file
1524. Automatically select CSV file from directory
1525. Listbox without scrollbars?
1526. Newbiw to VB with Excel
1527. FlyGuy ~~~ FlexGrid to Excel
1528. Is there a "Workbook Open" event ???
1529. convert .txt file 2 .xls file
1530. how to spot duplicates in Excel
1531. Multiple References To Excel *URGENT*
1532. Did the active sheet change?
1533. moving in a column
1534. checkspelling command
1535. Limit the number of rows and columns ?
1536. e-mail address in msgbox
1537. another stupid question
1538. Gui
1539. Disable opening of other Excel Workbooks
1540. protecting sheet in shared file
1541. newbie unable to get a <> to work
1542. Cell Formatting
1543. Compatibility Issues with Word Automation and other
1544. Macro Changes Page Lists in Pivot Table
1545. excel formulas
1546. Timesheet and Calendar in a form
1547. Opening a text file in excel using delimeters
1548. .PrintOut append
1549. Accessing Excel Data in VB
1550. Complete and Utter Frustration
1551. Setting the color of a cell
1552. reading probs
1553. excel file transfer
1554. reading probs
1555. Protect VBA Project In Excel
1556. Cant open VBA help files in Excel/Office 2000
1557. .next not working
1558. copy range into another workbook range
1559. Need to save workbook as original csv name
1560. Lookup
1561. conditional formatting for a drawing object?
1562. Database problems for school project
1563. Printing MultiPage UserForm
1564. regression automation
1565. Menu Item parameter
1566. Extracting value from worksheet
1567. shorten search time?
1568. activate workbook which includes macro
1569. VB - Easy Printing Question ?
1570. 'Replace' method accross multiple sheets
1571. Help requried please - Excel automated save and email
1572. Text Wrapping in Excel
1573. Maintaining excel cell formatting when inserting new line
1574. Returning DB Query Results Using a Cell Ref
1575. Importing delimted file into Excel 2000
1576. Grabbing data from multiple cells
1577. Embedded ComboBox. Please see attached Sheet.
1578. How do you write a macro referring to the row the active cell is currently in.
1579. Excel Objects Reference?
1580. Adding a path to the footnote in an excel worksheet
1581. Possible to embed a useform on an Excel sheet?
1582. How Can I Insert Picture Through DialogBox?
1583. How to change GetSetting datatype
1584. Flexible Summary Sheet
1585. Prevent a form and code from loading
1586. General Formatting/Printing Question
1587. Force recalc after "#REF!"
1588. The Error In My Ways? (Macro)
1589. Is it just me or does a later date have a smaller value?
1590. How to test an excel file is already opened?
1591. excel database macros
1592. automating excel database update
1593. removing Special Characters from a string
1594. String Searching
1595. Name excel workbook
1596. *argh* converting Excel5.0 to Excel2000 macro problem - *PLEASE HELP* - urgent !!!
1597. Userform default fonts
1598. Doesn't active cell return a range?
1599. Changing color of text outputted to excel file
1600. Can u merge cell values into one cell?
1601. VBA function
1602. Workbook_SheetCalculate Infinite Loop
1603. Calling a subroutine in anther workbook
1604. Coding
1605. A question on sorting data...
1606. VB6.0 using Excel Object
1607. Hilighting Excel Cells..please help
1608. help with array's
1609. Pivot Table
1610. Ticking a box in excel unhides text on spreadsheet?
1611. Excel -> MSFlexGrid
1612. ActiveCell.Offset to the left not working
1613. Sending email via Excel VB
1614. Change "Microsoft Excel" and Icon in Titlebar
1615. Problems with delete range
1616. delete rows
1617. Self-Replacing Subtotal
1618. Please help, I'm stuck
1619. Why am I getting a function not assigned error?
1620. Is there any way to catch cells updating from Standalone VB?
1621. Excel 97 ADO
1622. Change printer paper source in VB > Excel
1623. About cells matching using VBA in excel
1624. Excel Object and Sorting
1625. changing 2 sheet names by input on one tab?
1626. Can someone look at this code pls ....
1627. Here's a real tough one needing help with
1628. Matching text strings
1629. excel shared files (max users)
1630. Excel Columns and SQL
1631. Run-time Error 6: Overflow
1632. *~* Please Help me *~*
1633. Cells Goups in new Sheets
1634. Need Code for timer control for excel???
1635. moving vba between office 2000 & 2002
1636. Need help - UserForm causes code in Macro to not execute???
1637. Buttons Enabled
1638. Automated excel .xls -> .csv/tsv
1639. Unexpected Error (32809)
1640. Wow, what a problem!!!
1641. Copy to a new file and export as CSV
1642. Help with Solver please
1643. Duplicate refs differing values?
1644. deleting double duplicates
1645. URGENT. Pls HELP..Thanks!
1646. Ugly text file into Nice excel spread
1647. ShellExecute
1648. Code to loop through a column and identify a particular string?
1649. Change mouse cursor for certain cells
1650. Need a way to see if any other workbooks are open...
1651. Dragging a group of cells
1652. Importing random *.csv files
1653. Opening excel documents
1654. Automatically resizing a ListBox
1655. Starting Cell issue
1656. Delete Key Listener
1657. Protecting Sheets with Password in a String Variable
1658. checking open [shared] workbooks
1659. fill in the blanks
1660. What is the CONCAT equivalent in Excel? Pleeease HELP
1661. Saving .csv as Tab delmited
1662. Iterating through Comboboxes
1663. create graphic autmatically with VB
1664. checking existance of shared wb??
1665. create graphic autmatically with VB
1666. Userforms
1667. User Defined Function Arguments
1668. Populate List based on Rating
1669. Excel Workbook Object
1670. Forms cause Excel to crash
1671. using a macro to create a commandbutton
1672. Save As (Today's Date)
1673. Choosing between files to open
1674. Disabling Menus
1675. Need code to delete duplicate rows.
1676. Method range of object "_Global" Failed
1677. Excel Merged Cell / PasteSpecial Issue
1678. Need code 4 OpenDialog w/ Adobe Acrobat
1679. activating a cell when a button is pushed.
1680. Help Find Last Value in Column and copy
1681. Need some easy help
1682. UserForm listbox question
1683. How Can I Export/Import Splash Screen
1684. relative selection (offset)
1685. A wierd simple one for ya
1686. graphs in excel..short question..
1687. using solver in an Addin
1688. Copy, paste loop
1689. Adding options to a pull down menu?
1690. Make Splash Screen Available To All New Excel
1691. open a range of files, but one doesn't exist
1692. Counting In a Macro
1693. Append from one worksheet to another
1694. Problems with paste
1695. Insert row where it should go alphabetically
1696. Command Buttons and Excel VBA
1697. Opening multiple .asc files & creating one .txt file
1698. Opening a Word Document
1699. Date
1700. Arranging this???
1701. Automating Excel in a VB app
1702. Help making object references dynamic
1703. Can I format a ComboBox List?
1704. Using Visual Basic to find Minimum
1705. Anyway to tell what format an activecell is?
1706. detecting #REF!
1707. End a Loop Macro at a specific row??
1708. Cant anyone help!!!!!
1709. XML to Excel
1710. Find (x), Range(bg1):(ta),copy,PasteSpecial,transpose & del. rows, loop until (endX)
1711. Error 1004 - Any help would be great.
1712. Adding Borders
1713. Force File Close
1714. Automation Error
1715. maximise
1716. How can I work around dialog boxex?
1717. compare excel sheets / find missing records
1718. Query_close
1719. Excel Object Library
1720. Error:Document Already Open
1721. Deleting Buttons based on location
1722. How can i filter this listbox with items from input
1723. Macro with a variable range
1724. Is this possible?
1725. Customized Buttons on the toolbar
1726. format date problem
1727. Overwrite file window for Excel...is it possible?
1728. Can you use Subscripts or Superscripts in Excel?
1729. Reading Data in Excel
1730. Copying data
1731. Hiding a sheet in vb with if statement?
1732. first and last non-blank
1733. Parsing data from local XML file til Excel
1734. Excel 97, start from vb and run macro... strange problem
1735. Copy / duplicate checkbox during run time
1736. Positioning the target cell after a hyperlink
1737. Date Format
1738. Re: MS Excel/VB and Pivot Tables
1739. What code could I use to determine if the AutoFilter is off?
1740. Can an external WorkSheet containing a document, be viewed in a UserForm?
1741. Can't save changes to userform.
1742. Can We Add Common Dialog On Excel Menu?
1743. Can We Insert A Picture into Excel?
1744. How Can We Format Font in Excel?
1745. Date selection
1746. combobox value = first of the list
1747. Accessing code modules of a different workbook
1748. Dialog box for users to enter column no's for code to actions on
1749. What's the code to check if a workbook is allready open?
1750. How to access the unbound columns in a listbox