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"...
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...
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...
I have an application for other users. I want to make an introduction of sorts available for new users. I created a userform with a textbox that contains the lengthy introduction. I understand there is a limit to how much text can be put in the textbox? Is that correct? Is the limit the...
I am at least minimally familiar with using DIR and Filesearch to search a directory for specific files. However, I am not familiar with accessing a directory referenced through a url. Can either of these be used in this situation or do I need something else? Below is some code that I have...
I think I have the proper forum. If not, somebody please let me know.
I am running XP Pro and office XP. I had my hard drive crash and had to replace it. I was able to recover the folder "Documents and Settings" which I understand is where Office stores things like bookmarks/favorites and...
My data and formatted charts are in Excel(2002). I need to copy and paste them as pictures into Powerpoint slides. I really want to do this using VBA as it will need to be done weekly. I have figured out how to launch Powerpoint but that is about as far as I'm getting. I need to open a file...
I have an application that can take a long time to run. Should the user want/need to stop during execution (press esc key), I would like to provide the option of saving certain parameters to a text file so the program can pick up where it left off and not have to start from the beginning. How do...
I have an application that can take a long time to run. Should the user want/need to stop during execution (press esc key), I would like to provide the option of saving certain parameters to a text file so the program can pick up where it left off and not have to start from the beginning. How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.