Search results for query: *

I have a standard workbook that we use for estimating. When the project completes, we take some of the worksheets, cut/paste them into powerpoint, add other slides and send out for review. I would like to write a macro to automagically copy selected sheets/areas/ranges from Excel into a new...

I wrote a program that we have deployed around a couple of people. However, about 1 in 3, I have to manually go in and fix the references library. It would be nice if I could run a query of the libraries, in the main db, store the results, then run a program to set them on the new client. I...

I have an excel file that basically contains a set of questions, followed by the answers. To help "mine" the spreadsheets, I've built an access db to pull them in, and manipulate. However when I do this, the text formatting in the memo fields seems to go away. Is there a way to preserve the...

I am trying for format some excel from Access and i keep having trouble with the formatting commands. So I have two questions... Periodically, someone suggests inserting the number code instead of the defined constants. Where do I look that up ? And; does anyone see what I'm going wrong here...

I am cleaning up a program and was wondering if there is a function or program that would identify the programs that are not "called" anywhere ? I've rewritten a lot of the code and I would just like to skinny it down to just the programs that remained. Any utilities that might do this ? Thanks

I am calling Excel from Access and I need to disable the macro functions on start. They are causing me to have an extra prompt at the save. I don't want to delete the macros, just stop them from processing and stop the system from prompting me !

I am opening an Excel sheet, writing some data, then closing the sheet. However, when I close the sheet, I am getting a "do you want to save...." prompt. Any way to avoid that ? I just want it to save quietly and go away. This is the current version xlApp.Save xlWS.Close Set xlWB =...

I'm linking to a table in another Access DB. But when I was running tests, it took longer than it should have. I realized it is effectively sweeping the table for each match. So I tried to define a primary key and it won't let me. Any way this can be done ?

I am updating an excel spreadheet from access. Before I export the query, I need to delete the worksheet thats already there. I seem to get sporadic responses to this code. Can someone point out what I'm missing ? I'm getting a 438 error. Thanks Function KillExcelSheet(szFileName As String...

Yes, this is a rookie question but since I am almost done with this project, hopefully close to my last idiot level question. How do I run a VB procedure from the Switchboard. I can't seem to get the RUNCODE to work. I've created a shadow macro to match each one, but there has to be a more...

This is really stupid, but I have to read a CSV file (name changes every month) then save it as the same Excel file. I need to do formatting and editing while I have it open. For some reason, I cannot save it as an excel file. I can change the name, but it is clearly saving it as csv. I've...

How do I run the linked table manager from VB ? I'm trying to keep the user from having to go to database utilities etc and I just can't seem to figure out how to execute this. I'm assuming I can do this using the DoMenu, but anyone know what command ? Thanks

I have a table that I exported from Access to Excel. Now I need to set up a subtotal on the table. I was hoping to use the excel subtotal command and created a macro. However, it just doesn't work. I've tried about 4 other techniques without any luck. Searched a few different topics. I get a...