TheMSsForum.com >> Excel Programming >> Archive Page 6 - The Microsoft Software Forum

view full version: back to formated view

1751: opening files in excel 2003 when 2007 is installed
1752: filter part info
1753: VBA Import Convert Data Type from Type 1 to Type 2
1754: VBA to select rows based on selection
1755: VB Form as Menu
1756: email Word DOC along with XL sheet?
1757: running 2003 and 2007 side by side
1758: Print to PDF
1759: How Write for RGB palette?
1760: Display charts on a userform
1761: Set DTPickers Data to Todays Date by Default
1762: XL2002 - I'm having a bad day!
1763: Using a Variable to point out a listbox.
1764: Test If Workbook is Open in Network and On Users Computer
1765: inserting and naming a tab with vba - any help please thank you
1766: How to control how much gets printed (prevent printing blank rows)
1767: Personal.xls macros will not work in any other sheet
1768: Problem jumping between tabs in a MultiPage
1769: HIDE / UNHIDE sheets based on user answers
1770: Starting a macro by changing autofilter criteria
1771: open save as from list
1772: Count If query within string
1773: CountIf query within text string
1774: CountIf query for words within string
1775: To assign list of number
1776: look up formula
1777: To assign month for a certain range of date
1778: Selactively read text file
1779: excel2003 trial still available?
1780: excel 2007 security
1781: scope of private function called from UserForm fails
1782: Compatibility mode
1783: Hidden worksheet problem
1784: Modify to only work with nominated range instead of entire sheet
1785: require cell completion before saving
1786: On Error action inconsistent
1787: Convert numeric field from type 1 to type 2
1788: Print Only Visible Rows Using AutoFilter
1789: Select a range based on Fill Color
1790: List box sort
1791: Combo Box row Source
1792: Opening the VB Editor via VB
1793: getting Cell2.value=empty when their are values in the column
1794: ActiveX error - multiple workbooks appearing in vbproject
1795: Code for insert .jpg file
1796: macro hangs if no data is found
1797: VBA
1798: adding rows to spreadsheet
1799: tool bars
1800: looking up data and using a combobox user form
1801: Can I use Select Case to do this?
1802: branches /loops
1803: VBA code
1804: Strip first 5 characters from a cell.
1805: Combo box should trigger another combo box
1806: Event macro does not run a Private sub
1807: How can I open an Excel workbook using a cell containing the path and filename
1808: Change event
1809: chart question
1810: API run program
1811: Run a program
1812: collect data from sheet and put into one row of csv file
1813: Teacher Substite
1814: Assigning values to dates
1815: block characters
1816: Use of Split
1817: combo boxes entering data
1818: Trailing zero's
1819: Reading the keyboard in VBA
1820: Moving a form using a button
1821: Why isn't this code to change the font colour working?
1822: SENDING SERIAL INFORMATION TO A COMPORT
1823: preset table
1824: predisigned table
1825: Disappearing Personal.xls
1826: Workbook change event when tab color changed?
1827: Selecting Radio Buttons by Using Macros
1828: Number Format
1829: Add multiple custom lists
1830: Printing Sections of Worksheet Using AutoFilter and ListBox Values
1831: macro to find data and filter it and copy to another worksheet
1832: Open a text file in a template
1833: automated cursor movement in Excel
1834: VBA Workbooks.Open - Suppress File Currupt Message
1835: comparing a column in two separate spreadsheets
1836: Selecting a group of tabs regardless of name and amount
1837: name of workbook...
1838: Private Sub Workbook_SheetChange
1839: inserting data in a column based on data in another
1840: goto last cell with data
1841: Userform - calendar control
1842: Revision Control
1843: need help
1844: Lock colon in textbox
1845: How do I insert a button in Excel 2007
1846: Swap trailing minus to leading
1847: CalculateUntilAsyncQueriesDone()
1848: Calculate Change
1849: Radio Buttons Created Dynamically
1850: Listing Active Directory groups that have directory access rights
1851: Iterating over a nested Dictionary object
1852: Cant find a Control
1853: BeforeSave macro
1854: Get Value of ComboBox in Menu
1855: How can I email a spreadsheet as plain text using MailEnvelope or
1856: Opening workbook - get error message : unreadable content, lost
1857: How to Print varied page numbers in a single print job without col
1858: Reverse axis problem between 2002 & 2003
1859: How to use excel vba to specify the path of a link table in access
1860: Delete Rows on Set Criteria
1861: How to let the formatting follow data during sorting?
1862: Auto fill Sheets
1863: Commenting out
1864: Format VB command
1865: CONCATENATE IF macro or function?
1866: Application.Quit
1867: Excel Macro to auto fill a webpage (Automation Testing)
1868: VB-How can I use a variable in a sheet reference?
1869: Hide all autofilter dropdown arrows
1870: Changing Cell Properties when sheet is protected
1871: Change Zoom Value of Window with ComboBox in Custom Menu Control
1872: Lock checkbox to cell?
1873: macro to lookup value and open tab based on lookup value
1874: goal seek is not accurate
1875: Macro not working on different computer
1876: Running Macros from Excel Saved as html file
1877: How to distribute addin with a reference library checked?
1878: OPtion Button
1879: Office 2007 get ribbon name
1880: Avoiding Invalid Inquery Message
1881: using a conditional formula from a drop down list and If Statement
1882: move data based on number of characters in a cell
1883: resize range
1884: Option Button Default
1885: Convert Percent Entered as Text in Wksht to Number in VBA
1886: Macro to fire button in external file
1887: Like Operator Error
1888: Fast code in 2003 = agonizingly slow code in 2007
1889: Testing under Office 07 and getting #DIV/0! and #VALUE!
1890: Macro not running when a change occurs
1891: Get info from first cell in row.
1892: Automation of Keystrokes in Populated Cells.
1893: Suppressing Input Box
1894: How to Protect the sheet, if few of the columns / rows are grouped
1895: Bypass Error Q
1896: script to replace data in csv file
1897: How can I filter a list with VBA?
1898: Save Excel Workbook
1899: How do you specify a sheet when using redirection from a webpage
1900: Pls help on Excel 2007 SDK sample!
1901: How to create sub-folder through specific cell value?
1902: sorting / formula
1903: OptionButton
1904: ISBLANK or NOT
1905: Sort data
1906: MACROS - Copy row from sheet to sheet.
1907: Shadow property
1908: Continual addition to Cell
1909: different formats on one sheet
1910: VBA open workbook xlxs in 2003 that contains a password
1911: changing parameter in SQL query from Excel
1912: workbook to access
1913: How to program a toggle control button
1914: auto fill
1915: Workbook numbering
1916: protect xls workbook (Vista)
1917: How to hide xls worksheet tabs (Vista)
1918: Mapping Mulitple Elements to The Same Cell
1919: Command buttons and Mac
1920: double click macros
1921: Columns Reference in VBA after inserting a new column
1922: Macro to add row and past values on new worksheet. HLP
1923: Inserting Row after data change
1924: How do I reference a Range of cells in excel using variable names
1925: Identify computer Login ID
1926: Thousand/Decimal seperator
1927: extracting data from a row
1928: Converting code to function
1929: code works on some computers, but not on others
1930: Help needed with modifying this code
1931: File Reference
1932: Search Box and 13 sheets
1933: Leave loop
1934: Selecting data with a specfic value only
1935: Refreshing a SharePoint list in Excel
1936: Wild card in formula
1937: File exists, but code doesn't find it?
1938: Delete blank rows
1939: Challenging - Can an existing SSIS package be run from Excel using
1940: Userform cancel problem
1941: variant sheet name to filter
1942: Declaring Command Bar Control
1943: Add a ' in front of all highlighted code in VBA
1944: Len(ZipCode)
1945: Stop Procedure when an Error occurs in another procedure
1946: Internet explorer
1947: Case Statements
1948: Populate a multi-dimensional array from Ranges
1949: import data
1950: Uncheck AutoFormat (Pivot Tables)
1951: Referring to last row with data in it
1952: display userform a certain time of day?
1953: Why activex calendar control 12 missing in Excel 2007 SP1?
1954: COPYING ONE ROW TO ANOTHER SHEET AFTER CELL INPUT
1955: Problem with Hiding Every Other Column - Still need Help
1956: If Then Else Pivot table
1957: Print?
1958: Return the Line Number where the Error Occured
1959: UDF - How do I include help to the user like the built in function
1960: Transferring date's from a calendar control to a text box on a use
1961: copy then paste to multiple ranges
1962: automatically get worksheet name
1963: Hidden rows reappearinmg when macro deletes rows
1964: Politics
1965: Repeats Help installation
1966: COPY DATA FROM 2 CELLS
1967: Yes No box no working properly
1968: Format input box
1969: vlookup and if function
1970: Excel NUmber format IN VC++
1971: Date problem
1972: Confirm SaveAs takes place.
1973: Cosine function
1974: Escape Key Interrupts Code Execution in Add-In
1975: Transpose problem
1976: Extremely slow sheet copy
1977: Prevent User from Changing Password
1978: worksheet tabs
1979: Create formulas in conditional formatting
1980: What are the common problems when app cannot connect to Excel?
1981: Page setup problems in VBA
1982: Creating custom toolbar
1983: Duplicate Count
1984: Customizing a toolbar icon
1985: Remove empty rows from a range
1986: disable workbook
1987: Most efficient way to loop through a folder and find all the XLS f
1988: Return the Module Location & Sub Procedure Name on Error
1989: Split an Excel file into separate files
1990: Resetting Activex comboboxes to blank
1991: Vlookup
1992: Merging Files using Employe ID Number
1993: Macro or code to insert Shape (Say Smiley face) in XL?
1994: current week, current month, current year
1995: Userforms & worksheets
1996: sendmail recipient
1997: Creating a Macro that saves over a protected spreadsheet.
1998: Adding Menus to the Ribbon
1999: Vlookup function
2000: assign a name to a cell using vb
2001: find row to use
2002: Text in a Rectangle Object
2003: Removing unnecessary rows through macro
2004: Minor Axis Numbers
2005: Copy value only
2006: Activate a workbook
2007: Problem with Hiding Every Other Column
2008: Checking my lottery numbers
2009: date comparison
2010: XL2003: Toggling "Extend" Mode with VBA
2011: Macro code
2012: Automating Web Query import
2013: Golbal Variable Failed
2014: Do Loop or If Then
2015: How many checkboxes can you have?
2016: publish xl list with more than 64 columns to sharepoint
2017: workbook name changes
2018: Change Link in batch of workbooks
2019: How to optimize column deletion in a large table of data
2020: Need help with a Formula
2021: reference tab value on worksheet
2022: Convert number to date
2023: Have code working but need to edit to use on multiple variable len
2024: reference error
2025: Print a Userform To Fit On One Page
2026: Combobox Events to Shrink and Expand Width
2027: How do I write a select case statement for range
2028: how delete old querytables?
2029: Textbox Data IsNumeric
2030: Search workbook for cells with white font
2031: Protected Data>Lists - and no VBA?
2032: Range.Delete Shift causing merged cells to unmerge
2033: Any ideas?
2034: Need help with respect to CDialog-based display of dialog in Excel
2035: Quick method to sort a list of strings?
2036: Change Colors in Charts
2037: Dsiable right click on objects
2038: Programming to create a report from raw data
2039: extract elements of strings
2040: Userform Combo box to mimick Worksheet Cell validation list range.
2041: XL2002 - SelectionChange Question...
2042: Convert number to date
2043: Highlighting Rows and Cut to another worksheet
2044: Sending SMS from excel
2045: Random Golf Foursome Generation
2046: Random Number Generation
2047: End If
2048: Application trim or rtrim
2049: multiple updates to database
2050: Excel VBA xlcountrycode always returns 1 = US
2051: How do I create my own functions in Microsoft Excell 2003
2052: Referring to BeforeDoubleClick
2053: Creating a variable of type Range
2054: What am I doing wrong with this VBA range?
2055: Variable not yet created in this context
2056: Please improve this simple implementation
2057: Letting user have temporary scrolling authority
2058: Need a date range
2059: Lock from moving cells
2060: range array
2061: TypeName function
2062: Pivot Chart Drill through / Hyperlink to detail report
2063: Saving a spreadsheet from .Net Web Forms application under Vista
2064: deleting characters from autofiltered cells.
2065: create mdb 2003 format by excel?
2066: Pivot table - consolidation range
2067: Rolling sum cell variable location input
2068: VBA Program
2069: Any Guru can figure out how to diisplay C++ MFC CDialog-based
2070: Running a Macro
2071: Disable Adobe save file prompt
2072: How to sort a selection of rows?
2073: Using datedif to format cell color
2074: worksheet change based on target range
2075: Deleting certain cells only
2076: Timed Display Alert
2077: Macro: selecting ranges from list of names
2078: Checking row for data
2079: Setting cell format based on format codes
2080: Change criteria for worksheet change code.
2081: calculated member analysis services
2082: How do you Find with data in hidden columns
2083: About Lisview control
2084: Data from Combo Box
2085: Change Excel hyperlinks from absolute to relative
2086: Creating xla file to clear junk and sort reqd data
2087: PivotTable - multiple sources
2088: How to find difference in cell contents visibaly looking same
2089: Adding hours
2090: Comparing a list of Records
2091: Excel as a Game Design tool
2092: Merging rows
2093: Microsoft Office Spell Checker
2094: Error help
2095: Custom Sort Routine
2096: StructureMacro.xla PASSWORD?
2097: Autosave
2098: WorksheetFunction.EOMonth
2099: Is there a way?
2100: ActiveX component can't create object or return reference to this