JaseSt
asked on
Part 8 to: Import more data into spreadsheet
Continuing on from: https://www.experts-exchange.com/questions/28156647/Part-7-to-Import-more-data-into-spreadsheet.html
Now that an email is created when a value is inserted into Col N (with a value in Col K) I need this function to also do the following:
1. Open spreadsheet Blank - New Card Load.xls (example posted - its path is:
C:\Users\Michael\Dropbox\S overeign\M asterCard\ MasterCard LoadReques ts/Blank - New Card Load.xls)
2. In Col D of Blank - New Card Load.xls post the value from Col T of Applicant Status
3. In Col H of Blank - New Card Load.xls post the value from Col B from Applicant Status
4. In Col i of Blank - New Card Load.xls post the value from Col C from Applicant Status
5. Save Blank - New Card Load.xls as 'First Name Last Name - New Card Load.xls' to the same location Blank - New Card Load.xls came from
- example save as: Joe Smith - New Card Load.xls
6. And attach it with the other attachments to the email created
(My concern with these functions is what happens when multiple records are in an emailed xls spreadsheet, but guess we'll cross that bridge later.)
If too much for one question, let me know.
Thank you, gowflow!
Blank---New-Card-Load.xls
Now that an email is created when a value is inserted into Col N (with a value in Col K) I need this function to also do the following:
1. Open spreadsheet Blank - New Card Load.xls (example posted - its path is:
C:\Users\Michael\Dropbox\S
2. In Col D of Blank - New Card Load.xls post the value from Col T of Applicant Status
3. In Col H of Blank - New Card Load.xls post the value from Col B from Applicant Status
4. In Col i of Blank - New Card Load.xls post the value from Col C from Applicant Status
5. Save Blank - New Card Load.xls as 'First Name Last Name - New Card Load.xls' to the same location Blank - New Card Load.xls came from
- example save as: Joe Smith - New Card Load.xls
6. And attach it with the other attachments to the email created
(My concern with these functions is what happens when multiple records are in an emailed xls spreadsheet, but guess we'll cross that bridge later.)
If too much for one question, let me know.
Thank you, gowflow!
Blank---New-Card-Load.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
as you can see, it put the data into the row below where it should go
Well I saw this row and thought it was a sample so I deleted it fine no problem change the following:
In Module1 there is a Sub Called CreateNewCardLoad
change this line
MaxRow = WS.UsedRange.Rows.Count + 1
to be
MaxRow = WS.UsedRange.Rows.Count
gowflow
In Module1 there is a Sub Called CreateNewCardLoad
change this line
MaxRow = WS.UsedRange.Rows.Count + 1
to be
MaxRow = WS.UsedRange.Rows.Count
gowflow
ASKER
Works perfectly, gowflow, thanks.
I need the card number inserted into the blank xls (the newly created xls file) to be formatted so there is no spaces or dashes. Just one solid 16 digit number NOT in scientific notation. Do you want me to ask another question for that? Because I also need it imported into Applicant Status that way as well.
I need the card number inserted into the blank xls (the newly created xls file) to be formatted so there is no spaces or dashes. Just one solid 16 digit number NOT in scientific notation. Do you want me to ask another question for that? Because I also need it imported into Applicant Status that way as well.
Yes please as this is a complete different module and to incoroporate it wether in this file or in applicant status is no sweat.
gowflow
gowflow
ASKER
Gowflow is fantastic!
And I will add the formatting of the card number question here. Thanks once again, gowflow.
And I will add the formatting of the card number question here. Thanks once again, gowflow.
ASKER
here it is, gowflow:
https://www.experts-exchange.com/questions/28159139/Part-9-to-Import-more-data-into-spreadsheet.html
Thank you!
https://www.experts-exchange.com/questions/28159139/Part-9-to-Import-more-data-into-spreadsheet.html
Thank you!
ASKER
And I did delete everything from row 2 down for about 50 rows just to make sure. I cleared content and deleted the rows, but still came up with the attached.