Replies

hmmm thanks for all the input. It is exactly like Gary’s scenario. I need it VERY simple, my users will not be able to cut out the slides they don’t want etc. from the slide sorter. They need a simple user form to come up that gives them only the “sections” they ask for.

I’m creating a “wizard” user form that asks them what “sections” they want and when they click on OK they get those slides in a new ppt. Gary, thanks for the code. How or where do I define the sections? How do i way that slides 1-5 will be “section1” and add those when they click on OK? thanks for your help

I’m also thinking of 2 listboxes and moving from 1 to the other to “build” the new presentation. That way they can move up and move down their selections in the rightside listbox to order them in the way they want. Any, vba help is greatly appreciated.

ok, yep that worked. I forgot the “new” in the dim stmt. thanks for the help. i’m on my merry way now!

Thanks so much. This is great. Do I have to select the whole worksheet and then call the macros? Do I have to make the UsedRange like A1:c200 or does UsedRange know what is used?

Also, is there a way to move files from one folder to another within Excel? the .movefile does not seem to work. Thanks

yes, i think i could use a conditional formatt in the cell. Yes, i need to do this for a whole workbook for every worksheet in it. thanks a lot for the help

I was looking at this code. I’m wondering if they open a textfile text.txt and I have Excel open already in j.xls, how can i got back to text.txt and do a saveas test.xls? thanks a lot

perfecto! thank you

wow! thanks so much for the quick help. i was right in the middle of working on this.

I want the excel filename to be the same as the cda filename. text.cda to save as text.xls so when i use

ActiveWorkbook.SaveAs Filename:=”text.xls”

i don’t have to type the “text.xls” in quote marks, i can use a variable. How do i extract just the “text” part of the filename to put it in a variable?

Thanks. I did finally figure it out. My form is bound and i’ve taken your advise about NULLs.

I want one of my field to be “calculated” from 2 other fields. I couldn’t figure out how to add a formula in Access so i have a cmdCalculate on my form that takes the two text box values and puts the result in the 3rd field. All 3 fields exist in my access database.

When i click on my save command.
private sub cmdSave_Click()
adoProject.Recordset.Update
…

it doesn’t add my calculated field to the database. Is my reasoning flawed? am i doing this correctly? thank you for the help.

Thanks for the messages. I am using an ADO connection to Access 2000. The mdb allows zero length and required is set to “no”. I want the user to be able to leave blanks in the form because they will not have all the information at one time. They will have to update the record as they go along and as more info comes in.

I’ll try adding spacebands to each blank field for the time being unless you can think of any other way to do this. Thanks for the advise. I really appreciate it.

I have the form done for my voting excel workbook. How can i make it appear when i double-clock on voting.xls?

Also, if I have 6 numbers in a row of my voting.xls, how do i check to make sure none are duplicates. For instance,…
60 43 55 60 17 22

I can’t allow two cells to have 60 in it. What is the formula to check these cells for duplicates.

I greatly appreciate the help to this problem. thanks a lot.

Ok, I am doing in Excel. When they open my voting.xls, i want the form to appear automatically. How do i do that? Also, can you help me with the code to make sure each txtbox has a different number in it. When they hit the SUBMIT button I can send a msgbox that they have duplicated a vote and they can’t do that. thanks a lot for your help.

thanks rory. that worked. it was my single and double quotes. Could you let me know the rationale behind the use of single quotes. thanks

ok, so you recommend i do this in excel and have a form box come up so they can vote. how do i supress the excel screen so they only see the form box. I don’t want them to see who’s winning the contest i only want them to hit a SUBMIT button and off they go.

If i do one row for each person, how can i stop them from entering the same number in any of the 5 category columns? i really appreciate your help. thanks

ick!!! hmmm, ok. Is there a way I can make Excel have the focus, break the links manually, go back and resume saving and closing ppt in my code? thanks for the help

Thank you so much. I can use this code for hyperlinks for sure. I wasn’t clear, however, that the links i need to break are links from Excel to Powerpoint. The only way i can find to change them is to go into links and one by one break the links. When i try to record a macro it won’t give me any code. Hope this clarifies things. thanks again.