Search results for query: *

Hi everyone - I have a problem accessing a table in my database from excel. When I run the sub procedure below, I get an error, presumably because I have a space in my table name. Is there any way to "fool" the computer into thinking of the table name as a whole rather than just as...

I have an access database on my company's intranet. I would like to access that database from an excel spreadsheet from any computer on our network. In other words, I want to know if I can use the OpenDatabase method with an IP address or computer name for the server ie...

I am having a problem inserting a filepath in a formula. There is some really nasty splitting going on. In VBA I am inserting a formula in a cell in the form: =someStuff...

I have a sheet that produces copies of itself and therefore, all of the named ranges are also copied. In another sheet I want to access a particular named range, but one in a specific sheet. So for example, if Sheet1 has a range named newRange and so does sheet11, I need a formula that will do...

I have a named range of rows (say, rows C:G) and I want to take it and add row A to it so that the range now covers rows A,C,D,E,F,G. Any ideas on how to do this in VBA? Thanks, Bryan Marble IEWS BAE Systems

In XL97, I have a workbook that contains a few sheets, and a few charts. In my sheets I have 3 or 4 special sheets and I need to find a way to loop through those sheets only. I'd like to set some sort of a flag to mark those sheets as special. I've tried creating a named range that will only...

When I try to open another workbook using VBA (it's not toooo large at 245K) Excel hangs (CPU goes to 100%) and I have to use the task manager to close excel and start over. When I step through the procedure doing the openning with the debugger (which then steps through all of the open events...