I have 8 forecasting and calculation functions that are currently in VB in Excel spreadsheets. Currently the various processes are initiated by buttons for the macros. The solution would use programs to initiate processing. Some basic mathematical calculations would occur daily/intra-day. The forecast revision would occur monthly. The individual spreadsheets
...Put up an additional item on the File menu when viewing an email - Clicking on the menu item brings up a dialog box with some confirmatory text and into which the user can enter the name of the document to be saved - The macro then goes to a location in the HKCUSoftwareVB and VBA program Settings hive to recover the file path to save to.
I am a member of numerous online forums and need to send emails and private messages to the other members. It is a time consuming process which I just do not have time to do it. If done by hand it will take a considerable amount of time so I need some software so I can do it automatically. You will need to become a member so you can access
I ran into a program at [login to view URL] that is similart to what I'm looking in a link exhange application down to the automated link authorization process. Basically you can look at the features at [login to view URL] and you will know exactly what I am looking for. I would like to have full resell rights as well. Obviously I don't want it to be a complete
Overview: Build the frame-work to enter multiple Product Matrix which will be provided, and design a web based automated decision maker using the guidelines featured in the product Matrix. The Problem: Each day I recieve as many as 10 different Matrix that need to be reviewed one at a time. It is both time consuming and confusing. I want to enter
I have columns of excel data that give data for several different device. For example the first 100 rows has data of device a at a 100 different frequency points. The columns are the parameters that I would like to graph at each frequency point. The next hundred rows is the next device and so on. What I would like to be able to do is create a macro
I would like a program to run in windows xp that will automatically fill web forms and submit them. The program will search google using search terms input into the software. It will then retrieve all the pages found one by one and fill out the form. These are the forms it will need to fill. The form below where it says leave a comment. <[login to view URL]> The form below where...
...along with a lack of code so programmers weren't sure how much they needed to do. I am providing some code since peices of this are done. This project is to build an automated trading system. I'm breaking it into phases, a lot of the work has been done already. Included in the zip are: Rough design doc with screen shots, references to where
I need a developer to help me with logic in a excel spreadsheet already in place. I need help on debugging and correcting one bug. The developer must be available the next 5 hours. The developer must know fluent english and also must be available o. phone if needed.
I'm having a problem (that after much reading seems like a common one) with references in my vba app. I will be distributing a mde to any number of workstations running w2k or xp. I need to have my app use the dll’s and ocx’s that I copy to the machine during the setup program. I would rather not modify the user’s machine but it seems after looking
I want to call Excel xla functions in MS Access. For example: CUMPRINC function (you need to enable Excel Analysis ToolPak-VBA first) =CUMPRINC(5,5,5,5,5,0) =-4.1672 We want to call "cumprinc()" function in MS Access we tried follows, but both didn't work 1) Public Function xx(rate As Double, nper As Double, pv As Double
Automated Retrieval of Voice Messages from WebSite We are using a third party company to record calls on our behalf which are stored on a secure web site. We need to retrieve these call recordings on a daily basis and store on our own server. We need a simple system that will go through the login process on the web site, retrieve the list of recordings
I have VBA code in an Access 2002 db that is trying to use INET ftp. This feature works ok on pc where development is being done, however it will not work on other pcs with the database. Apparently (as I've been told) I need a custom dll that can be installed with this database. So ... for features ... I need to be able to pass the dll the ftp
We are migrating from Novell to Microsoft. We have 3000 Clients all running XP Our current network settings are (ie. right click network connection, properties) Client for Novell Networks Client for MS networks TCP/IP NWLINK Netbios NWLINK IPX/SPX/NETBios all ticked. I need an app or script that can run locally on each machine ( I will deploy this) to untick NOT DELET...
...wrong job type. I basically own and run a site for poets and writers in which I offer memberships and other services. I would like someone to incorporate an interactive, automated system. I have already built the site and have registration forms set-up, I would also be the one to design each members page once they register. I need someone to connect
Project: Provide VBA code to format data in ANSI 837-4010A for medical office billing, testing compatibility with one major payer to their acceptance of the file format. You should already be familiar with the format, or be prepared to teach yourself. I will NOT teach you the format, explain the format to you, interpret what the format means; that's
I need a VBA program to modify excel document, eg. delete certain row, fill certain cell, sort record etc., please review the [login to view URL] in the VBA_Project.zip. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run
...ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform WIN2K PRO, WINXP PRO, LOCAL MACHINE, MS ACCESS or VBA, or "wrapped DB" that requires no additional licensing on our part...
I have a five page DOT word document that has bookmarks in place of variables and pulls the data through a VBA script that is built-in to the document. The attatched documents explain things well. There is about 20-30 locations with variables, some are the same. Some of the variables are simply left as blank lines to be written in after they print.
I want a facility that enables us to write to MS exchange public and private calendar from an MSAccess v97 form (in VBA). The code should retrieve the calendar for a specific user based on what the user specifies on the MSAccess97 form (and for the time range specified as well) and display it in this access form. We should then be able to input/save
Need simple VBA program to run statistical analysis. 1. Need option to browse for input file. 2. The input file is in excel (file attached). The first row will always contain headers. The output file will be excel. 3. The first column is the date, (daily). 4. The second and third columns contain values and for this example, lead by the headings
The problem I have is that I need to return the final results from a site. The site has a number of protections (cookies/javaforms) to stop automated bots from getting through. I believe the site does the following. You go to page a. with a referer set from site x. This is something that i need to set The page sets a cookie and presents
I need a subroutine that will go to the a number of investment websites and grab specific data for a given symbol. This data will be returned in a datatype described in the attached file. This should be the subroutine call: Public Sub GrabWebData(ByVal Symbol As String, _ ByRef WebData As WebDataStruct, _ ByRef OnOrAfterDateTime As Date) For details on the WebDataStruct, see the at...
I need to update an existing spreadsheet (attached) with the formulas functions (attached) ## Deliverables 1) Complete and fully-functional working program(s) in executabl...components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP VBA
Need two VBA Macro driven MS Word templates to be used in a mail merge in order to automate a process for collecting strings of text or sentences and then printing each string on a separate 8.5x11" page in landscape layout. Effectively, this is an automated system for printing off "flash cards" that can be taped to a wall or bulletin board. Tempate
...automate tasks between outlook and excel. I am not too sure the extent of the VBA functionality but I am looking to see if there is a programmer out there who can make a few custom actions for e-mail processing. Perhaps it will be easier to design a custom GUI application to interface with Outlook and Excel. We are looking at receiving
...based. This needs to be finished within one day after the bid is awarded. Do not use Shell, any outside libraries, or worksheets (even if hidden)... it all MUST be done in VBA. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that
I need a Visual Basic program to automate software test processes. It is a basic test automation capture and playback tool. For automated testing of programs and web sites. Automated testing scripts can be created/edited/saved etc. using a color coded editor. Scripts should also be recorded using a built-in recorder feature. Using a Tree view format
I want to use the Excel Drawing tools and VBA extensions to draw floor plans and generate sq footage calculations. I need to define different areas (ie 1st floor GLA, 2nd floor GLA, garage, patio, porch, etc), draw, label and obtain info about them. The Excel Freeform shape drawing tool (with a few enhancements) should work ok for drawing the areas
Hello -- I have attached an XLS that needs three modifications... the first two should be very simple and the thrid requires some functionality. This needs to be done as soon as possible and I thank you for your response. Bebo ## Deliverables The attached XLS needs the following enhancements * **_Worksheet ‘Main Menu':_** I would like an underlying FORM created that...
I need the VBA code to create a new message rule in Outlook 2002. Simply put, mail currently comes into Outlook and is then sorted into folders. When mail comes into certain folders I need outlook to send an email to other email accounts (I would like to set these email addresses myself) that says "There is mail on the server". ## Deliverables The
My client: Lawyer requires printed copy of his trial schedule in a certain format. Currently his secretary enters all info by hand in WordPerfect. The office wants to use MS Outlook Calendar and all its features. The calendar is in a public folder. Solution: We created custom appointment form in Outlook that gathers all required info. It has 1 small coding bug to be fixed. We created a...
...specification will be provided as well as sample file extracts and support by phone in understanding this file format. All code should be developed within MS Access using VBA or as a VBScript in WSH. More information about BAI can be found at: [login to view URL] A sample BAI2 file has been attached. ##
Please help me write a Macro that I can use in Excel/VBA that will Import an Excel worksheet from one file into another file's target worksheet. The Macro will: 1) Be invoked by a control button 2) Produce a window that will prompt the user for the location of the source file. (Standard file navigation) 3) Add TWO hard-coded alpha fields
...access and the date on the files are in the "foreign format" "19800101" ""YYYYMMDD" I need a VBA excell function to convert all the dates and stick "/" in between the /month/day/year so the format should be converted into Access (after I edit it with Excel). The function should transform the format for the whole file and be ab...
OVERVIEW: I need two VBA macros, to be embedded in existing document template and excecuted from existing toolbar. At time of execution, user will have two files open, the first is the Word document based on the template with the embedded macros. This document is always Window 1. User will enter data in some fields of this document located on lines
...[login to view URL] . When the visitors has submitted this form i receive it as an email - a sample of an email created from the form is attached to this bid request. I need a program (preferably in VB) that is able to import the email and then store the data fields in a database that is accessable by the user and the program itself
Given is a excel file (see attached file as a sample) with 2 sheets. Sheet one is a overview sheet with projects and customers. sheet two has details to the projects and customer. what I need is a flexible way to give the user an easy way of handling the autofiltering. I think of an easy click to the customer, then excel should swith to sheet two, select
Excel tool to query a MS access mdb and return any new data into excel. The tool should query table check to see if a new EventID has been added, if so return the first 3 rows of new data into the next available Excel row Table Format Event ID/Name/Position/Price/Volume/Total Excel Row Format Price.1,Price.2,Price.3,Volume.1,Volume.2,Volume.3,Total
...into a spreadsheet to analyze. I need to automate this process to save time. Ideally you will have expert knowledge of Office Products and be able to to program in VBA, do advanced Excel 2000 macros, program in VB and know Access exceptionally well. I'm interested in giving you a small test job to assess your skills and then lots more work if you are
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are ex...
...price can be negotiated; however do not bid if you are not able to implement this system. Thank You all in advance. As can be inferred from this title, this system is an automated flash system. **Project Guidelines:** It should be created in Flash MX or MX 2004. It must be written in properly commented actionscript. The actionscript code
I found a few things I needed to add and delete from my last bid request so I want to re open it afresh. For details on the work I need done, refer to the attachment. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition...
...have written a complex Excel VBA program that I want converted to VB as a self extracting file that does not require excel to run. It includes graphs, and some complex formula's. I am in a hurry so 1-2 weeks conversion. We have a number of projects like this if you perform good work. I have attached the file. Please note excel 2k or higher needed. Program
The aim is for customers to create and maintain their own web site from a standard interface that steps them through the process. Firstly to Create their web site they would have a set series of templates to choose from initially and would then select colour combinations of a template they select, and then move on to fill out the various content text. An example of what I am seeking can...