Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export mulitple worksheets to single large csv file
Thanks for the speedy replies... I've managed to import the data into Access and randomise the data there using a query based on Rnd(), which gives the same results, just on a larger scale (i.e. more records). Thanks very much for your help Phooey- Phooey
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Export mulitple worksheets to single large csv file
The data will end up in a large csv file for use by LoadRunner. I'm currently using the RAND function to randomise the data, but will not be able to do this when the number of input csv files grow beyond the scope of Excel. Looks like Access may be the way to go. Thanks Phooey- Phooey
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Export mulitple worksheets to single large csv file
I've been amending an Excel spreadsheet used for data conversion to be used in Stress Testing. Not my choice, I will admit, but the solution I've inherited. As a last step, Excel opens up all csv files found within a directory and copies the contents to another sheet, appending to the bottom...- Phooey
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access2K Runtime Setup Error
Make sure that you install the Access 2000 Runtime files to a separate directory to the current MS Office installation.. Example: All Microsoft Office apps by default install to C:\Program Files\Microsoft Office\ Therefore, your current MS Office installations will exist in the avbove...- Phooey
- Post #15
- Forum: Microsoft: Access Other topics
-
email using Lotus Notes R5 via Access
Write code to call SendLotusNotes. Recipients is an array containing all of the people that you're mailing to. Subject is the email subject. BodyText is whatever you're putting in the message body. Attachment is optional and is a file path. SaveIt is optional and is a boolean (True or False)... -
URL 's in Notes
personnally, I like to use the http:// format as it works across all apps. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom. -
email using Lotus Notes R5 via Access
Look through the Access help files. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom. -
email using Lotus Notes R5 via Access
You could try, because I'm sure that the same object sending functionality exists... If you're working in 2000, try Tools/Database Utilities/Convert Database/To Previous Access Version. This will create an Access 97 version of the database. You may have to test this to ensure that all of the... -
How to create an agent to send a non-Notes document
Forgive me, I'm getting a little confused at the moment. The process you're trying to describe is: User sends email to central location. Central location automatically sends out an email refer to Word document in some way. User fills in Word document. User send word document back to central... -
What do I need
have a look at http:/www.lotus.com if you're looking for specifics. HTH Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom. -
How to create an agent to send a non-Notes document
Redirecting people to an FTP site is too technical? How? If you include a link sent from a response agent, the link would be directly to the document itself, which would automatically ask for a place to save it to. All the user then has to do is fill in the details and send it back. Is... -
How to create an agent to send a non-Notes document
Do your users currently run a Notes database, or is this a project startup. Just wondering, because I may have an idea. Settting up a Web enabled database is not that much work. As long as you get the HTTP server and stuff right then all you need is a domino database with HTML in the forms. A... -
Hyperlink in Lotus R5?
The other option would be to just do: <a href='mailto:andrew.j.harrison@cgey.com'> Click here to send me an email </a> Where my email address is could be replaced with a field in order to create a dynamic email link. Hope this helps.. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known... -
How to create an agent to send a non-Notes document
Why not just use an agent to create an email object and attach the Word document to it in LotusScript? This would then be fired off when the specified email has been received. Hope this helps. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom. -
email using Lotus Notes R5 via Access
I don't see why not, but the code you're looking for would be in Access. It'd be along the lines of creating a mail object in access and sending it. Windows may handle the default email package, but you may have to launch a Notes session in code. Have a look in the Access forum for more... -
Export tools? Notes to excel/access
You could also download the NotesSQL ODBC driver and perform the required SQL actions using MS Query in Excel or link the tables in Access. This may prove worthwhile, but you won't have instant results. If you take this method then each view will effectively be a 'table'. Therefore if you only... -
Hyperlink in Lotus?
You don't use HTML much then? Have you tried mailto:blah@blah.com? As in: <a href=mailto:andrew.j.harrison@cgey.com>Click here to mail me</a> Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.- Phooey
- Post #2
- Forum: Lotus: NotesDesigner
-
Export Notes Document to MS Word
You could try exporting the document as a Rich Text File and use Word to open it. I can't promise fancy styling, but it may just do the trick. Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.- Phooey
- Post #2
- Forum: Lotus: NotesDesigner
-
Help me with terminology
Yep, you're on the right track. Relational Databases are, for want of a better word, relational. Domino databases are based of documents, kind of like an email storage system. That's the way I look at it and it helps me. As Domino databases do not have a relational architecture, most of... -
DECS, Domino Enterprise Connection Services
I was under the assumption that DECS is installed with the rest of Domino Server. It's only loaded when you ask for it. Either that or it's on the CDs. Sorry it's a bit of a lame reply Phooey Andrew.j.harrison@capgemini.co.uk Otherwise known as Windy Bottom.
