Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. automaker

    curline problem migrating from excel 2002 to 2007

    combo, Thank you. That did the trick. I was really struggling with finding a property that I could set or a method that would move the cursor up a line. I don't understand why curline=0 stopped working. But then I can't understand why filesearch was taken out. Thanks again.
  2. automaker

    curline problem migrating from excel 2002 to 2007

    Anybody have any suggestions? Is this an Excel 2007 VBA code thing? What about some type of cursor up command? Thanks,
  3. automaker

    curline problem migrating from excel 2002 to 2007

    KJV1611, I think I have not explained the problem clearly. If I set curline=1 then the top line in the textbox is the second line of text. To see the first line, the user must click on the up arrow of the vertical scrollbar. Originally, I had curline=0 which showed the first line of text at...
  4. automaker

    curline problem migrating from excel 2002 to 2007

    I am running XP pro 2002 sp2. I created an Excel VBA program that had a form with a textbox. The text in the textbox required a vertical scrollbar. To make sure the user saw the text from the beginning, I had a statement like userform.textbox.curline=0 This worked fine until the "upgrade"...
  5. automaker

    Excel 2007 encryption

    Thanks Tony. This was confusing me on these two seemingly different paths that ended at the same point. Also, I understand the other passwords etc. offer minimal protection at best. Once the workbook is opened, the rest is basically just to prevent accidents. Very helpful, thanks.
  6. automaker

    Excel 2007 encryption

    Tony, Thanks and your statement about encryption and password protecting being the same thing is what I was thinking. So the process of Office button - prepare - encrypt is identical to Office button - saveas - Excel document - tools - general options - password to open? Is that what we are...
  7. automaker

    Excel 2007 encryption

    Glenn, Agreed and thanks. If there is a lock, there is also a key.
  8. automaker

    Excel 2007 encryption

    Genomon, Thanks for the reply. Your reply actually gets to the heart of my question. If you need a password to open the file and the same password is used by Excel to encrypt the file, what is the benefit in the encryption? Both methods of protecting the file (password to open and encryption)...
  9. automaker

    Excel 2007 encryption

    What happens in an Excel 2007 workbook when a user clicks through the following; Office button, prepare, encrypt document. It seems that the password entered becomes the password to open the workbook but is that all? Is the data within the workbook encrypted and if so, how does that improve...
  10. automaker

    VBA unable to save Excel file sometimes

    Gavin, Yes, I can save the file manually. Good suggestion. Because it seems everything is fine with the other files that I open, I decided to sort of get rid of the chart file. I manually opened the chart file and for each tab in the workbook I copied it to a new workbook. Then I had the...
  11. automaker

    VBA unable to save Excel file sometimes

    I am at work now using my work computer. I will take the files home and see if I have the same issues. If not, then maybe a fresh install is the answer. I will keep you posted. Mark
  12. automaker

    VBA unable to save Excel file sometimes

    If I go the route of repairing the office install, is there something I can run from my computer (such as checkdisk or system file checker or something like that) or are you suggesting I contact our IT folks and get Office reloaded? Mark
  13. automaker

    VBA unable to save Excel file sometimes

    I did the google thing and went to the MSDN site. Here is what is out there. Visual Basic Reference: Error Messages Error in loading DLL (Visual Basic) A dynamic-link library (DLL) is a library specified in the Lib clause of a Declare statement. Possible causes for this error include...
  14. automaker

    VBA unable to save Excel file sometimes

    Ok. I tried saving the chartbook before closing databook. Same "document not saved" error on the save line of code. Also, the wording of the dll error is "Error loading dll". I received that error when I followed the debug button to the editor and tried to make code changes. Mark
  15. automaker

    VBA unable to save Excel file sometimes

    Skip, Folder is not full. I am saving to my hard drive right now as I am developing the program. Thanks, Mark
  16. automaker

    VBA unable to save Excel file sometimes

    PHV, I did try the first suggestion. Same problem. It won't execute the save line. I have not tried the second suggestion. I will do that and get back to you. By the way, when I tried workbooks(chartbook).saveas [complete path] I get the message that the file already exists and do I want...
  17. automaker

    VBA unable to save Excel file sometimes

    I have an issue with a VBA program I wrote (that is the first problem) in Excel. The program is saved in its own workbook (call it progbook). The program opens two other Excel files. One file contains data (call it databook) and the other file contains summary tables and charts (call it...
  18. automaker

    Exceeding Excel VBA userform textbox limit

    strongm, Thanks for the info and the link. I appreciate the help. Mark
  19. automaker

    Exceeding Excel VBA userform textbox limit

    strongm, I'm not sure that a label with extra code is necessarily better, but it is another option. Also, as Skip has said, Textboxes are for users to enter stuff--responses. Lables are for information. Thanks, Mark
  20. automaker

    Exceeding Excel VBA userform textbox limit

    Skip, Maybe I wasn't clear or maybe it is the version of software that is causing some confusion. I am using Excel 2002 with VBA 6.3 In this version, a textbox control has a scrollbar property. It can be set to none, vertical, horizontal, or both. The label control does not have a scrollbar...

Part and Inventory Search

Back
Top