My first question is located :
hereSearching a Word Document from Excel .
Edit: New questions Questions:
Am I still unwittingly using Hungarian Notation? I read the article but it brought up more questions than answers.
Is there anything that I'm overthinking and could simplify? I'm looking at my nested for
forloop and can't help but think there's another way to do it.
My first question is located here .
Edit: New questions:
Am I still unwittingly using Hungarian Notation? I read the article but it brought up more questions than answers.
Is there anything that I'm overthinking and could simplify? I'm looking at my nested for loop and can't help but think there's another way to do it.
My first question:
Searching a Word Document from Excel
Questions:
Am I still unwittingly using Hungarian Notation? I read the article but it brought up more questions than answers.
Is there anything that I'm overthinking and could simplify? I'm looking at my nested
forloop and can't help but think there's another way to do it.
As I was working with this, I came up with a few moreEdit: New questions:
When Word didn't close down properly it would give me a pop-up asking ifAm I wanted to open astill unwittingly using Hungarian Notation? I read only copy, a local copy, or wait to be notified when the file was available. I tried using
.Open(file, ReadOnly)article but it still gave me the error messagebrought up more questions than answers. Is there any way to bypass this to keep the program from stopping and waiting for input?The program isn't too "intelligent"Is there anything that I'm overthinking and would put invalid data in the cells. I wascould simplify? I'm looking at my nested for mm-dd-yyyy, but if that wasn't in the string it would put in part of the name. How could I keep it from entering any data that is not of the mm-dd-yyyy formatloop and can't help but still use the string? I attempted using And/Or with some pretty hilarious results, so I decidedthink there's another way to stay away from thatdo it.
So far, this script is FAST. It can enter over 5,000 cells of information in under 30s instead of the 5-10 minutes for 300 cells that the first version did.
As I was working with this, I came up with a few more questions:
When Word didn't close down properly it would give me a pop-up asking if I wanted to open a read only copy, a local copy, or wait to be notified when the file was available. I tried using
.Open(file, ReadOnly)but it still gave me the error message. Is there any way to bypass this to keep the program from stopping and waiting for input?The program isn't too "intelligent" and would put invalid data in the cells. I was looking for mm-dd-yyyy, but if that wasn't in the string it would put in part of the name. How could I keep it from entering any data that is not of the mm-dd-yyyy format but still use the string? I attempted using And/Or with some pretty hilarious results, so I decided to stay away from that.
Edit: New questions:
Am I still unwittingly using Hungarian Notation? I read the article but it brought up more questions than answers.
Is there anything that I'm overthinking and could simplify? I'm looking at my nested for loop and can't help but think there's another way to do it.
So far, this script is FAST. It can enter over 5,000 cells of information in under 30s instead of the 5-10 minutes for 300 cells that the first version did.