Search:

I'm not sure how to ask this question, but there are times when you want to display a progress bar; e.g., to show the number of records that have been processed as a percentage on a moving bar chart....

Thanks. That's what I am beginning to understand.

Thanks. Your code is similar to what I mentioned in my initial post (Get/CreateObject) and it works standalone, but it doesn't work for me if I am connected to database via ADODB.Connection. I'm...

From Excel 2007, I'm connected to an Access database via ADODB.Connection. From here, I've retrieved some data from the database into a worksheet. Now I'd like to issue a command to the database to...

Thanks to both of you. Two things.
1) I've tried vbf's code and, at least in my tests, even though I use the 'True' arg to open exclusive, others can open and modify the database. That shouldn't...

Thanks, but I don't think I'm getting an answer to my basic question, which is, how do I make sure that no one else has the database open before I start the process. The way the process is written,...

Thanks. Here's brief description.

Launch Excel and start a VBA macro that does the following:

1) SFTP data into multiple .txt files.

2) Using 'New ADODB.Connection' (ACE) to database...

From within Excel VBA, how do I open a specific Access database in exclusive mode (to make sure others are not using the database), and then run a DoCmd to run a macro within that database?

I have...

Thanks, but how do I get (display, store) the count itself?

Need some help please. Running Excel VBA, I want to get the number of records in an Access table where the records have a certain value in a field and return that count to Excel. Thanks for any...

I like si's suggestion. Thanks.

Good thought, but if users launched the Excel report by double clicking from Explorer, instead of via icon or button, I'd miss the arguments, right? Thanks.

Maybe the wrong question, but here's the situation. I someimes develop VBA code and run Excel reports from home; i.e. remotely. The programs often SFTP data from a 3rd party server. If I am...

Thanks. Counting rows was the trick.

Can someone please offer some VBA code to import a table from Access into Excel with field names included. I don't want to use 'connections' as those seem to lock the database. Thanks.

I am importing hundreds of delimited text files into a workbook. Each text file can have anywhere from 1 to hundreds of records. So the rows in play would look something like this where 'n' could...

Is there a way to refresh an Access connection without locking the database, or a way to free the database after refreshing? Thanks.

I got around the problem by calculating the Sheet1.usedrange before copying. Thanks.

I am filtering Sheet1 and removing all rows that I do not need. Then I am copying Sheet1 using 'Move or Copy'. Then I want to replace all formulas on Sheet1 (2) by using...

Is there a dependable way to cause Excel to set the used range (i.e., last row, last column) of a worksheet other than saving the workbook? I have an application where I filter a sheet and then...

Thanks for all of your help. I redesigned my contract and pseudo contract (name and nickname) worksheet, and no lopnger have the #Value! problem. I still don't understand why I got it because I...

Thanks, Westconn1, but there are at least 11 columns. And thanks, 3com, but your code won't work for me. My function works but it returns #Value! in all cells that receive the FillDown formula. If...

Hope this one works for you.

vlook's won't work because the table is not sorted. I think you can match on a column or a row, but I don't think you can match to a table of multiple rows and columns (can you?). Maybe my function...

106317

Here is simply example of table. The custom function first searches for the first name. If not found, it searches for nick names. If a nick name is found, it returns the first name.

Short of writing a custom function, is there another way that I can find a value within a table using standard Excel functions? The table is less than 100 rows and 15 columns. Thanks.

Creating another workbook will take more work than I thought, so I have to think about how I'd do that. More info, though. It's only the FillDown cells that get the #Value! error. The formula that...

I'll try to create a workbook that recreates the problem. One more bit of information. The formula that uses the custom function is inserted in the column with VBA. If I remove the code that...

I wish I could but it contains sensitive info. I've tried to workaround by manually copying and repasting the column that contains the custom function, recalcing, but the only thing that works,...

Any ideas on this? Also, when I use this function in several hundred cells, even with calc set to manual, Excel reports that it cannot continue due to low resources. Please help.

Function Find_Contract(cNum As String)
Dim aNum As Object, pNum As Object
Dim searchRange As Range
Set aNum = Sheets("Contract Pseudos").[Actual_Contract_Number].Find(cNum,...

Thanks. No 'active's but a couple of Set and Find objects.

Please help. I wrote a custom Excel function that works great. However, when I create a copy of the sheet that uses the function, move that new copied sheet to a new workbook, and then return to my...

OK, does anyone have experience with Office 2013 running Excel 2007 .xlsm workbook macros? Thanks.

Does anyone have experience with Office 365 running Excel 2007 .xlsm workbooks? Thanks.

Will I have any problems running Excel 2007 VBA code on a server running Office 365 (without Office 2007 components on it)? Can someone please tell me where I can find more specific information...

More info. Seems like if you delete the external data query after you run it, you can run the same query to the same external file again. But if you save the workbook without deleting the query,...

I can't rerun the same data import query without either manually renaming the query within the properties window or deleting the worksheet. No matter what I try I cannot see the query anywhere, but...

I keep getting this message ("'A query with this name already exists on this sheet") even though I am deleting all visible queries within this workbook. How can I delete all external data queries so...

Is there a way to trap when a user toggles between 'Normal' view and 'Page Break Preview' view? There seems to be a problem with Excel 2007 where the zoom value is lost on Normal view when a user...