Hi all,
I have an idea in mind that I'm trying to figure out if it will work. Would the following be possible?
If I have 3 columns in use
A. Date
B. Name
C. Age
If one row is fully filled out from A to C, soon as it is saved, I need it to automatically create new word doc, place the new row data into the word document and save it as a new file inside the folder. If another row is filled out, same again, create new word doc, insert new data into the file and save it into the folder.
Give this a go...
On entering info into specific row columns A to C...If all columns of that row is populated then the code runs...
Please Login or Register to view this content.
Last edited by sintek; 07-30-2019 at 07:12 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi, thanks for putting your time and effort into this.
I have an error with this, comes up with compile error: User-defined type not defined. After I have typed the date in column A moving on to Col B.
EDIT
I have modified this:
Also, how can I start the proccess of saving when hitting CTRL + S or just by simply clicking save?Please Login or Register to view this content.
Thank you
Last edited by Eduards; 07-30-2019 at 08:22 AM.
Possibly as a Worksheet Change function...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks