Search results for query: *

I'm using the following code to import data stored in a .txt file into an Excel (XP) file: With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & Filename, Destination:=Range("A8")) .FieldNames = True .PreserveFormatting = True .RefreshStyle = xlInsertDeleteCells .SaveData =...

I have an excel file (XP) that when I try to compile on another user's computer stops at lines using the UCase function. When I look at the list of selected References, all of them match what I have. Perhaps the problem is that the particular dll file is corrupted. However, I don't know...

I have some code (in Excel 2003) that takes a chart and converts it to a picture so that the user can copy it to another application (e.g. Power Point, Word, etc). The copy and paste works fine. However, when you print out the document the Axis Titles on the left and right sides of the chart...

A while back I created an .xla file using the instructions in http://support.microsoft.com/kb/211563/EN-US/ I need to modfiy the file's comments. When I try to go to the file's properties (as per step 2 in "How to Save the Workbook as an Add-In File"), it is not an available option. Does...

Is there a way to hide a .xls file that is opened using Workbooks.Open? After I open the .xls file from another .xls file it becomes visible; and I don't want it to be visble. Thanks.

I created a test xla file and wrote a simple function and subroutine which I call from another excel file. According to a book I have there are two ways I can call a subroutine: 1. Application.Run "filename.xla!subname" This method works. Another way is to just call the subroutine using...

I have an .xls file (winXP, XL03) that has the code password protected using the VBAProject password. Some of the users get asked for the password even though they are not going into the IDE. Sometimes it pops up after they have closed out the file. Anyone have any idea about this? Thanks.

The following code brings in data from a text file. It's supposed to just paste the data in the destination range. For some reason it's inserting columns (on some user's computers - right now users are using XP and XL03). Any idea what could be causing the columns to be inserted? With...

I have some ADO code within an Excel file (2003) to query data from another Excel file (see below). My question is, how do I grab data from within the same Excel file? What do I set as the connection? Dim cn As ADODB.Connection Set cn = New ADODB.Connection Dim rs As...

I have an external link in my workbook that I am trying to locate. I saved my file as an xml file and did a search for "C:\". I did find the link in the xml file (see below). It is within a <SupBook> tag and before a list of sheet names. Does anyone know what this means regarding where...

I have a range of cells that I iterate through and add hyperlinks to using code like this: With Worksheets("Sheet1").Hyperlinks.Add anchor:=Worksheets("Sheet1").Range("E9"), _ Address:=cHLink, TextToDisplay:=cName When the user clicks on the hyperlink, each time a different...

Can't seem to find an answer. What I'd like to do is be able to generate a list (full path and file name) of all open xls files. I'd like to be able to run this code in another xls file ... the fact that this sub would also list this file is fine. thanks!

I've been looking through some books, web sites, postings and can't seem to find an answer. Any links to sites / postings would be appreciated. I need to store various default settings values for a particular file (.xls in XP or 2K) so that when the file is opened it can read these values. I...

Is anyone familiar with / know of class libraries for statistics that can be used in Access? I've found a number that can be used in Excel but that's not what I'm looking for at the moment. thanks!

I have some code that I'm using to automate Excel from Access. After I run the code and close out Excel, it is still listed in the Processes window (in Task Manager). I've identified the following line as causing this problem: objxlbook.Sheets("Home").Range("A" & ROW_FIRST_SECURITY & ":" &...

I have the following code wherein I am removing all (but one) fields from a table. I am identifying the field names by iterating through the field collection of that table. Dim dbs As DAO.Database Set dbs = CurrentDb Dim t As DAO.TableDef Set t =...

I have a Excel file (2003) that has some filters on it. When I do "Save As" the filters get cleared. I added breakpoints to the various event-triggered sub-rountines on the ThisWorkbook object and the sheet object to see what is being triggered. However, none of those procedures were. Does...

Working in WinXP/2K3. I created a class module that I want to instantiate at Workbook_Open(). I want to be able to refer to it from any worksheet (or other class or module) until Workbook_BeforeClose(). Is this possible? I've tried the following (my class is called Message) in the Workbook...

Is there any way to do this?

I have the following line of code that takes a chart in Excel and converts it to a .gif file: ActiveChart.Export strTempFilePath, "GIF" I use Excel 2003 in WinXP. I've tested it in Excel 2K, Win2K and it worked fine. However, one of the users who runs the code in 2K had a bit of a problem...