This is entirely non-critical, but it's annoying me! I have a set of textboxes on a form, called sm1, sm2 etc, and I want to assign them to cells A1, A2, etc. Is there a way to put this in a loop, ie: for i = 1 to 100 cells(i,1).Value = ("sm"&c).Value next i Thoughts? ...
I made a test file, and ran through the excel file just fine, but whe nI insert one with a lot of data, I get the following error: The Microsoft Office Access database engine could not find the object 'Sheet1$' Which seems incredibly obvious, but 'Sheet1' is surely there, just like in my test file - I have checked about 30 times. The...
Any idea where the setting is hiding for turning gridlines off while using excel 2003 from interop? ...
I have to run few SQL queries and put the results into a spreadsheet. Since I am on a Spring/Java environment, I was about to run the queries using JDBC, iterate through the ResultSet, and use Jakarta POI to create a simple XLS. This looks like a very common requirement, so I was wondering if there is something already available - a pac...
Hi, I am a beginning in visual basic. What I am trying to do is whenever a box is clicked, highlight a specific range. Then, if another box is clicked after that, the previous range will unhighlight, and another range will highlight. Here is my code but it doesn't work right now. Dim FSelect As Boolean Dim myRange As Range Sub Rectan...
I have had this problem forever and never managed to figure it out. I am importing an excel (.xls) file into an asp recordset. Most of the time this works great. I have column with the following values 4 4 5,6 3 Asp reads those values in except for the 5,6. I have tried formatting the cells and this makes no difference. It appears...
Hi all We have a legacy ASP page that writes content to an excel file by generating client-side VB script based on data from the database. It uses set app = CreateObject("Excel.Application") to initialize Excel. The problem is that this is an "unsigned activex control", and some clients are now saying they wont change their IE settings...
Hi. I'm trying to do conditional formatting so that the cell color will change if the value is different from the value in the cell left of it (each column is a month, in each row are the expenses on certain object. I want to monitor easily changes in prices over months.) I can do it per cell and format-drag it, but I would like a gene...
I have a WinForms application that can call for and display a number of reporting services reports. I can call the LocalReport.Render("Excel", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings); method - writing to a byte[] array, but it throws an exception "The source of the report definition has not b...
This is driving me crazy. How can I assign a set of text values to an array? Nothing I try is working! Months = Array("Jan", "Feb",... etc does not work! ...
I have aset of account names in one workbook (the active one), and I need to use the .Find function to look for their ocurrences in another workbook/sheet. I don't think I'm getting the right Object handle for the other workbook/sheet, but nothing I try is working. For Count = 1 to 10 accName = Cells(Count, 1).Value AccRow(Count) = OB...
I have a Java app which reads CSV files which have been created in Excel (e.g. 2007). Does anyone know what charset MS Excel uses to save these files in? I would have guessed either: windows-1255 (Cp1255) ISO-8859-1 UTF8 but I am unable to decode extended chars (e.g. french accentuated letters) using either of these charset types. ...
I want to load a column in excel into a selectable dropdown menu using c#. I have access to the file, and can load the file in C#, but am not sure how to implement what I want. Suggestions? (I'm using Visual Studio 2008) ...
On e of my current requirements is to take in an Excel spreadsheet that the user updates about once a week and be able to query that document for certain fields. As of right now, I run through and push all the Excel (2007) data into an xml file (just once when they upload the file, then I just use the xml) that then holds all of the nee...
I am using .Find to look for a string, but the cells I want to search have formulae in them; what I want to compare in the result of those formulae. So far I have: cellrow = Range("A1:D4").Find("string").Row But it will return an error unless there is a genuine text 'string' in any of the cells. How can I modify this so that it is look...
I've been using a crude method to help the user update some cells - by having them in a sheet. Is there any way I can display the various ranges in a userform, one by one, then have the user update them, click a button and move onto the next one? Essentially, can I have Excel automatically generate an input form based on a range? The pr...
I need to know if a range exists, in my Excel addin. I use the Excel97 SDK (the Excel4() function). For instance, I have a range named: NotARealSheet!R1X10 When I set it to an XLOPER, it sets correctly, but when I use it, I get an untrappable error. At least, I can't figure out how to trap it. I would like to know, before I use the ...
I know only little how to make macros in Excel. ...
I've written some VBA code in an Excel workbook to retrieve data from an Access database in the same directory on a desktop. It works fine on my machine and several other machines running Windows XP, but when we tested this on a Vista machine, we encountered the "Could not find installable ISAM" error. I've done a bunch of searching on...
There seems to be some hysteria about SQL Injection attacks. Most recently, here http://stackoverflow.com/questions/505838/vba-simple-database-query-from-word If I'm creating a macro in Excel that connects to an Access database, do I really have to be concerned about SQL injection? It's not on the web, it's used in my office (you guy...