Search results for query: *

Sorry about the generic heading, I forgot to specify it when I was writing the post. : Bryan Marble IEWS BAE Systems

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...

Just as added info, I need to choose the sheet because the range isn't specific to one sheet. Bryan Marble IEWS BAE Systems

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...

Thanks a lot! Bryan Marble IEWS BAE Systems

On Error Resume Next ThisWorkbook.Sheets(&quot;sheet_name&quot;).Activate If Err <> 0 Then MsgBox &quot;Sheet sheet_name does not exist&quot; Exit Sub End If On Error GoTo 0 That should do it! Good Luck, Bryan Marble IEWS BAE Systems

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

Alright, I changed the implementation so that each sheet, on activation is given a range with the specified flag name, which works, because I just needed to know if an active sheet was of that type. Thanks for the help 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...

I've found that this is actually hanging, not in the open statement but in the first workbook's deactivate activities. Again, it runs through the debugger fine. I've gone through the deactivation routine and put a breakpoint at the very last End Sub before it returns to the code and it's fine...

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...