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

1751. Data Validation
1752. Running a VBA Excel program from an Intranet web link
1753. Can't get Excel Workbook to run maximized
1754. Using Set and Option Explicit Errors
1755. loading a macro into a toolbar?
1756. Adding macros to new workbook from a macro
1757. msoControlDropdown [alignment]
1758. Size of new window from Excel link
1759. Keep focus on MySheet1 while creating MySheet2???
1760. printing hidden worksheets
1761. More Data Validation Issues
1762. nearly racing now !
1763. show that everything is working not crashing
1764. Information between userforms
1765. How to open user-specified text files.
1766. saveas problem
1767. Excel form and textboxes
1768. How do I optionally, not have to enter the separators, when I'm entering a date?
1769. Excel Help needed
1770. Controlling Excel Solver under VB
1771. Splitting cellinfo with changing lenght
1772. Reading cell value from another XLS file
1773. Deleting a sheet without YES/NO button
1774. code help pls
1775. Programatically writing code
1776. set LinkedCell relative to location of Dropdown
1777. Error Handling
1778. Launching Excel VBA App from IE
1779. Hiding Macros in Excel
1780. copy from recordset to excel sheet
1781. How do I write to an open Excel Sheet?
1782. Dynamic and Selective Data Types Nuisance
1783. How to execute data using VB in excel
1784. How to use a String variable in a Range???
1785. Is there a way I can time a DesignMode Session, to revert back to NORM, in 5 minutes?
1786. Is it possible to Link to the Rows of a Closed WorkBook with a UserForm ComboBox?
1787. How to check if a .value contains a certain character
1788. Sending email from Excel
1789. Procedure too large
1790. Excel Error 429 in VB
1791. Help me, please
1792. Small fonts activated?
1793. Progress Bar
1794. Data Validation with a dynamic named range
1795. Password
1796. 2 questions about improving program
1797. IF "NO" then start over???
1798. Named range "problem"
1799. Newbie Question
1800. Newbie getting back into VB
1801. Interest Rates Calculations?
1802. How disable the scroll
1803. Need to detect specific characters & the presence of boarders, within a SelectedRange
1804. FTP code
1805. Executing Find using the Excel Object in VB
1806. Alert in Outlook mail via Excel VBA
1807. VB to Excel (list box)
1808. Unprotect a sheet
1809. Default excel messages
1810. Deleting repeated values
1811. Specific Error Trapping
1812. Assingning Range in Excel
1813. VB6 and Excel
1814. Getting started
1815. Optional argument
1816. Cell Formatting
1817. Macros cause Excel to crash
1818. Multiple Worksheets
1819. Excel converting text to unwanted date format
1820. I need some Help!
1821. Excel Macro Help
1822. Convert .xls to text
1823. Upadate Excel VBA Application
1824. problem in saving xls into text
1825. Compile Error. Can't find project or library
1826. Extract data conditionally from a list to a new list
1827. Excel vba active sheets
1828. Find top scores
1829. how to fill listbox entry list
1830. Search all instances of each item in a list
1831. Copy Columns to other Sheet
1832. Jumping to Column A
1833. Want to save file as cell name
1834. Excel date calculation - uses Julian Date
1835. Visual basic controls in excel
1836. Excel to Listbox
1837. starting a spreadsheet at machine boot
1838. ActiveX / ToolKit.SetUp
1839. How do I call a sub procedure from another sub procedure using variables?
1840. This a range, that a range Why vba no likem?
1841. empty cell/clear row if doesn't contain #
1842. How to transfer a var value from a form to a module
1843. W\ Embeded WorkSheet TextBox's, I need code equivalent to an OnKey Event
1844. Newbie: Listbox triggers macro using relative cell values (Using Excel 2000)
1845. Control Point of sale (POS) printer in VBA (Excel)
1846. Analysis Toolpak problem
1847. Add Data to Excel File
1848. Cells.Insert
1849. msoControlComboBox question
1850. Excel will not shut down for some reason....
1851. Showing/Hiding UserForms
1852. How to detect a function.
1853. Copy and Sort Data
1854. text file
1855. Lock cells in Excel
1856. changing data series in excel charts
1857. Locked/Protected Cells ?
1858. Frontend to an Excel spreadsheet
1859. Can't transfer Var value
1860. use item lookup to excel cell comments
1861. Anyone know ID for right click insert row?
1862. code help
1863. Need a crash course ASAP
1864. strange problem
1865. Add-In trouble
1866. counting occupied cells
1867. Macro required
1868. Cell Value based on Cell Range
1869. 'Tools\References - Path not found' Error
1870. Organise information automatically....
1871. Formula calculation speed issue
1872. using check boxes
1873. Trailing of user forms? Weird..
1874. Date formatting in .csv into Excel
1875. Control Source
1876. How to plot more than one equation in the same graph?
1877. Emailing a worksheet from a workbook
1878. Question about a few snipets of code
1879. list files in directory and subdirectories
1880. Date Validation
1881. xlCellLastTypeCell?
1882. Quick question, I'm stuck on something stupid but can't get around it
1883. Sequential file names
1884. If someone answers this, I'll be amazed....
1885. ComboBox object not activating
1886. Pivot Table calc; non-vba
1887. Printing an Excel sheet from a VB form
1888. creating a Web page with a workbook as a DSN
1889. Userform Loop???
1890. Printing to *.PDF file
1891. Adding Text after a Sum
1892. Pocket Excel
1893. codes needed to random select a column for calculation of mean
1894. codes which allows a user to randomly select a particular column
1895. How to calculate the difference between a range in Excel
1896. Excel Messages about read-only don't pop up
1897. Uppercase Textboxes
1898. Please Help!!! _Wierd_ Error...
1899. Global variables
1900. Need help in emailing data from a workbook
1901. How to save formulas as values?
1902. Autofilter Code
1903. Another stupid question by GoTigers
1904. Protect/unprotect and .Activate not working in Excel 97
1905. How can I list ALL worksheets in ALL workbooks?
1906. Help please! its urgent
1907. 1 more query
1908. export a datagrid to excel
1909. Sum Multiple TextBox Values
1910. populating excel spreadsheet from VB6
1911. Variable Datatypes
1912. How to read a spreadsheet? and where is the VBA DOC??
1913. where can I find....
1914. Array constants, and array variants vs "true" arrays
1915. How do you change the type a variable is?
1916. Dynamic Arrays vs. standard Arrays
1917. Problem with a Phantom C:\ Drive
1918. run an application when enter key pressed
1919. Excel Data to VB Object...
1920. parsing XML file to excel worksheet
1921. figures with "," or with "."
1922. copy a row from one excel sheet to another using vb code
1923. how to find a cells row and column
1924. Mill needs Excel help
1925. Allow Sorting and Autofilter on protected sheet
1926. How to limit button override.
1927. Shortkey in a userform
1928. Import Entries into Database
1929. Find cell that contains the value 4 and to insert two rows up
1930. Paste values for Multiple Sheets
1931. Avoid printing worksheets on new page
1932. how to deactivate excel selection
1933. The Big Red X
1934. how to add a button in spreadsheet and edit the command using vb6
1935. daft textbox question.....
1936. Method 'Charts' of Object '_Global' failed
1937. Help with functions
1938. Get range of Pivot Table output
1939. VBA code streamlining
1940. how to search text in excel application?
1941. How can I count hits to Excel?
1942. hide charts, name charts
1943. changing the value of a public boolean by calling a function from another Wb
1944. Count Word Tables
1945. Select Case / For Next / Loop
1946. VBA conventions for excel formulas
1947. Excel in Windows 95 vs XP
1948. Problems with variable's scope in VB/Excel
1949. Detecting filename of open Excel sheet
1950. Shared workbook error : "Catastrophic failure." !!
1951. xl97 Open Most Recent file
1952. run-time error 2147467259 on an excel file, read post for more details :D
1953. Add-in refusing to permanently alter menu
1954. Disable printer obtions
1955. Clear Content
1956. Renaming Worksheets
1957. How to close excel using macro in access.
1958. Excel 97 having trouble running code placed in a module
1959. Is there a V:\?
1960. Serial Communication from within Excel?
1961. help with small bit of code?
1962. Restrict Worksheet Change
1963. Delete sheets
1964. modify excel from access
1965. Using HPageBreaks.Location.Row with Application.ScenUpdating=False
1966. From EXCEL how do I initiate a VB sub I created
1967. Shape
1968. Emergency!! I Need Your Help Guys!
1969. global variables in modules?
1970. VB6 and Excel 97
1971. Rename sheets
1972. Database Saver by moving entries to the end
1973. Getting Cells Values into an Array
1974. Not recognizing cells as having equal data
1975. Hyperlinks and References
1976. Packaging VB App that Automates Excel
1977. how to save array data into excel spreadsheet?
1978. How to tell if any workbook is open
1979. How to get the next row of the cell address
1980. How to edit formula in a cell
1981. SUM occurrences of the Names: Kishawnda, Kishaunda, Nickey, Yona & Frank in Worksheet
1982. Writing efficiently from VBA to a worksheet
1983. Need to RemoveNumbers that FileNames may start with & add them at the end, instead.
1984. automate the assignment of subs/function to ole buttons
1985. How to change decimals in unlocked cells?
1986. Inserting Vlookups using code
1987. sysdate in excel
1988. basic problem: exit sub on init form?
1989. Need help using macro to input data into web based server
1990. 1 workbook copy on 2 workbook
1991. Language changes upon SaveAs
1992. animated gif in excel-userform
1993. Deleting Modules at run time
1994. Deleting sheets without confirmation
1995. Charting: Linking Y-axis min/max to a variable
1996. date notation in vba d-mm-yy
1997. Populating Excel Sheet From A Form
1998. Today’s date
1999. Excel sheets as Unbound Object Frames
2000. How to just say no ... to save file?