scheduling an email to deliver a vb created excel file
scheduling an email to deliver a vb created excel file
(OP)
BOE XI
I use BOE quite a bit to schedule .rpt files but am now looking to schedule an .exe that will create an .xls file to be emailed.
I am not a VB developer but had someone in the office provide me with a simple test .exe file that I have successfully added to BOE using the CMC. It runs and outputs successfully to a path on the network as the code defines the path.
The code is basically as follows which is very simple just for testing purposes:
exportFileName = "//Server1/Reports/Filename_" & Format$(Now, "mmddyyyy") & ".xls"
Open exportFileName For Output As #1
Print #1, "This is a test"
HERE'S WHAT HAPPENS
When I try to schedule & run the above .exe to be emailed in BOE, the .xls IS written to the path defined in the code (which makes sense). An email is generated with all of the content I setup in BOE (email body, email submtect filename etc) but the attachment is a blank .txt file... It's like each proccess is running independently as they both parts do work.
HERE'S WHAT I WANT.
I want to use BOE to schedule the .exe to run (which is working) and deliver the .xls via an email.
in BOE, there is not an option to define the output type (xls, csv etc) as there is when adding an .rpt. Is there a way to have BOE deliver the format of the file that is set in the .exe ? Do I need to add something to VB code so it 'talks' to BOE ? other ?
Thanks in advance.
I use BOE quite a bit to schedule .rpt files but am now looking to schedule an .exe that will create an .xls file to be emailed.
I am not a VB developer but had someone in the office provide me with a simple test .exe file that I have successfully added to BOE using the CMC. It runs and outputs successfully to a path on the network as the code defines the path.
The code is basically as follows which is very simple just for testing purposes:
exportFileName = "//Server1/Reports/Filename_" & Format$(Now, "mmddyyyy") & ".xls"
Open exportFileName For Output As #1
Print #1, "This is a test"
HERE'S WHAT HAPPENS
When I try to schedule & run the above .exe to be emailed in BOE, the .xls IS written to the path defined in the code (which makes sense). An email is generated with all of the content I setup in BOE (email body, email submtect filename etc) but the attachment is a blank .txt file... It's like each proccess is running independently as they both parts do work.
HERE'S WHAT I WANT.
I want to use BOE to schedule the .exe to run (which is working) and deliver the .xls via an email.
in BOE, there is not an option to define the output type (xls, csv etc) as there is when adding an .rpt. Is there a way to have BOE deliver the format of the file that is set in the .exe ? Do I need to add something to VB code so it 'talks' to BOE ? other ?
Thanks in advance.
RE: scheduling an email to deliver a vb created excel file
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
RE: scheduling an email to deliver a vb created excel file
I currently use BOE's 'specific email recipients' option which requires a 'TO' recipient and allows me to set the email subject, cc, body etc. for mass emailing to different clients with different instances.
I can't picture how having the vb code handle the emailing & pulling the email addresses via BOe parameter will change these other portions of the email.
I'm guessing I will not be able to use the 'specific email repients' option and the VB code will need to handle the email subject, cc & body as well.
RE: scheduling an email to deliver a vb created excel file
Good luck!
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
RE: scheduling an email to deliver a vb created excel file
Check this list for some of the available products: http://kenhamady.com/desktopschedulers.pdf
I guess it will be cheaper to use an existing and tested application instead of develop your own from scratch. There are some free options too.
www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.