Programming
in [Excel]
|
Excel ODBC driver created table/inserted data lost on application Using native ODBC API I connect to an Excel spreadsheet using Microsoft Excel Driver (*.xls) 4.00.6305.00 successfully and I am able to create a new table and insert data into the new table and retrieve the inserted new data successfully. While my application is running I can disconnect and reconnect to the E... 19 May 2010 12:42
Track and write the number of times that sub is run into a cel Thanks, Dave. That worked well. ... 19 May 2010 10:28
File folder info. in Excel workbook? Good day all. Excel 2007. XP Pro. Is there a way to have all available excel files in a particular folder listed (updated in real time) in an excel spreadsheet where the user can click on one or more of them to open those files or at least retrieve specific data from them? I have a situation where files represe... 19 May 2010 09:21
Autofit row height in only some rows Is it possible to change this macro to only autofit the row height on rows 254-332 in the workbook? I am using this macro: Option Explicit Private Sub Workbook_SheetCalculate(ByVal Sh As Object) Application.EnableEvents = False Sh.Rows.AutoFit Sh.Rows("1.33").AutoFit Application.EnableEvents = True EndSub ... 19 May 2010 08:15
Bug Report: VBA runtime Access Violation Thought I'd report the following bug, the following (silly) code: enum x: Me=0 :end enum sub foo: end sub Will crash any office app when entered into the IDE. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this sugge... 19 May 2010 12:42
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file Hi, second try to explain what I'm trying to do here. For the last couple of years we are entering our Production Specifications into an Excel spreadsheet (PRODUCTION TICKET.xls). The last step we take after everything is filled in, is copying the sheet and saving it (values only) under the quality number (e.g.:... 19 May 2010 11:35
Search Option I have the below code to search and copy the rows that matched some criteria.. I want to add one more search criteria to this code which checks for matching words.. something like below line.. (Sheets("Details").Range("B" & lngRow) = .Range("G2") Or Len(.Range("G2").Value) = 0) But the thing is the word ent... 19 May 2010 09:21
convert to capital letters Jacob Many thanks Your code works great "Jacob Skaria" wrote: Try Sub Macro() Dim cell As Range For Each cell In Range("A1:A10") If Not cell.HasFormula Then cell.Value = UCase(cell.Value) Next End Sub -- Jacob "Shawn" wrote: I need a code that will search a... 19 May 2010 05:00
Application.OnTime - Macro Cannot Be Found - Internet Explorer Hi Everyone, I have an excel spreadsheet (excel 2003 SP3) that is opened from a link on the internet. It is set to open in excel, not the browser window. When it runs the Application.OnTime code, it tries to reopen the excel file and says some message about "The macro "C\ Documents and Settings\{name}\Loca... 19 May 2010 03:56
convert decimal to sexagesimal How can i type into an excell cell with decimal degrees and get common degrees minutes and seconds ... 19 May 2010 07:10 |