Recent content by BillDickenson

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

Outstanding, I see enough posts on setting it so I should be able to make this function. Thanks

Thanks. That sounds like the right idea. I've not seen the Application.VBE.ActiveVBProject.References() call before in Access. Thanks again

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

Thank you both for excellent suggestions. It's all working. Thanks again

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

darn, even better than what I was doing. Thanks

Actually, all code. Since I'm opening this up from Access, I get that annoying "do you want to save changes" after I have saved. On investigating this, I found out that it happens "live" as well because the existance of a macro forces excel to prompt. when I open it "live" i get the option of...

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 !

Ok, I found it (and feeling a bit stupid). It wasn't in Access at all, it was in Excel. There is an Excel macro that prompts "do you want to" no matter when/how you have saved. So what I really need to do is start Excel without the macros, or find some way to disable the prompt. 2 days of...

you would think so, but none that I can find. Lots of ones for SAVEAS but for saving it as the original, I just can't find it. If you can point me at the right place, I'd be very grateful. (this is driving me slightly crazed) Thanks

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'll try that. In addition to this, do you think I should delete both sheets first, then add both ? That way the number of opens would be reduced.