Hello, I have an excel worksheet that has the following data: Project Prj St Prj End Asset PlanDt AnalyzeDt Project A 01/01/06 05/01/06 Asset1 01/15/06 02/15/06 Asset2 01/15/06 02/15/06 Asset3 01/15/06 02/15/06 Project B 04/01/06 08/01/06 Asset2 04/15/06 06/20/06 Asset4 05/01/06 07/20/06 There are more date columns after Plan
I want two simple input forms in Excel to be created with some basic VBA code for handling the input. A detailed description with screen shots is attached. ## 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 condition
I need someone with excellent experience in Visual Basic for Application (VBA) with Microsoft Office Excel to complete a student project in "finance." This project necessitates good understanding of finance as well as VBA with Excel. Also, there is "urgent" need to finish the project soon. I had experienced programmers who do not accomplish the job
Hi I created a VBA Excel program to get data from our AS/400 It works on my pc but not my boss's. It says 'connection failed' He has Client Access installed. What would he be missing? It seems like from the connection string below that he would need Client Access Driver but isn't that automatically installed if he has Client Access. Is there
I run a restaurant and I need a easy way to connect my data and change my main schedule if an employee needs to change his/her work schedule (if an employee originally was scheduled 4-cl but now the can only work 6-cl so I need to change the time on the daily sheets, main schedule, and in the employee info sheet.) So it would be easier to just change the time on the specific employee's info ...
I have an Excel VBA workbook that takes 10 minutes to run with the dataset I have. It grabs data from websites and parses that data. I need it to run in 1/10th of the time (about 60 seconds on my computer). It grabs the data sequentially and that's probably the problem. If it could have multiple threads grabbing the data, I am thinking it would
...pushed, the app should invoke a subroutine in a new thread. This subroutine should raise a VSTA event where user input coding is executed. The classes must be passed into the VBA event. The user must have access to the class properties and methods inside the VSTA IDE. Everytime the button is pushed the process should be repeated in a new thread. Put delays
...entry proceeds manually via a multiple-page form in the database. What we would like to happen is integration of Outlook, Access and Excel activity What we would like to happen is integration of Outlook, Access and Excel activity. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code
Attached is an Excel Add-In which contains two a subroutine I need debugged. The XLA contains a module called ‘AddInCode’ that contains all the code for the Add-In. The sub which needs debugging is toward the end of the module and is called “CopyModule()??. The module performs the following task: if a spreadsheet contains custom functions contained
...algunas horas. y despues modificarlo para el nuevo diseno que sera entregado en un psd o en html. y modificar algunas formas para la informacion del usuario, y anadir algunas funciones. mas informacion a quien de ejemplos de su trabajo en php. pueden hacer bid por el proyecto que son mas mones 40 archivos. o por la semana entera de trabajo. me
...llevara algunas horas. y despues modificarlo para el nuevo diseno que sera entregado en un psd o en html. y modificar algunas formas para la informacion del usuario, y anadir algunas funciones. mas informacion a quien de ejemplos de su trabajo en php. pueden hacer bid por el proyecto que son mas mones 40 archivos. o por la semana entera
...activity of sites on monthly bases. Data needs to be generated automatically for the graph. There are constant Data feeds comming in every month. This needs to be done on Access / VBA. Also, need to use Access graphical utility to generate graph. This is on URGENT bases. ONLY BID IF YOU CAN FINISH IT WITH IN 3 - 5 DAYS. UPON SUCCESSFUL COMPLITION, CODER WILL
**Please see zip for full description** I have a database with one main table named “PCA??. This table has multiple records with multiple fields. A user needs to be able to look at these records through a form, and then populate some additional fields that get written back to the main table. New records are put into a table weekly. There are about 3000 records per week. In order to make...
...'Substitute the path and filename of the sound you want to play Call sndPlaySound32("c:windowsmedia[login to view URL]", 0) End If End Sub [end code] I tested this code through VBA and it works OK using run. The cell in question is part of a spreadsheet that takes data and decides if that data is higher or lower than a value range. Currently if it is
I am down here in Lima, Peru working on a web site, [login to view URL], using Bravenet as a host, I am not a webmaster and I need help auditing the site to insure search engine proper placement, audit of key words, meta tags, wordwrapping that sort of thing. The site is designed by me to be a fundraising vehicle benefitting a childrens home here
We have a small VBA for AutoCAD and want it converted to ARX application. See attached for snapshots, but it is essentially a very small VBA program to measure the total length of selected lines/arcs/circles of the current or selected layer on the active drawing. We need a toolbar with a button to appear and menu to launch the form. You
...6 L need a VBA xla which does followings: 1.) XLA should have a timer which I could set static (within password protected XLA)! 2.) Button bar with Icon “Analyse Start?? ??" When clicked ..do following 3.) Open a dialog window an request a project name, and browser for a project folder and/or add project folder 4.) Generate an EXCEL file with that
...format. The existing medical billing data should provide all the information that is required. This is an extraction / translation project primarily. We would like to request VBA based formatting functions that produce 837 from our existing database. We will provide a copy of our program, which consists of a compiled MDE "Front End" and an MDB "Back End"
Dane w arkuszu Excel w kolumnach : symbol data godzina cena wolumen ilość otwartych pozycji. Dane aktualizują sie poprzez interfejs DDE. Każda kolejna transakcja to kolejny nowy wiersz . Program ma tworzyć wykres o regulowanych przedziałach czasowych np. w ciagu 5 min ma obrazowac jaki wolumen był dla poszczególnych cen które były zawarte w 5 min. Poza
I need someone with excellent experience in Visual Basic for Application (VBA) with Microsoft Office Excel to complete a student project in "finance." This project necessitates good understanding of finance as well as VBA with Excel. Also, there is "urgent" need to finish the project soon so it is important to be sure to comply with time you specify
...txt?? contains the macro I created to show you what I need done. I need the [login to view URL] converted into an excel file so I can grab information from it and copy it onto another sheet. The complication here is that I need a loop or some other vba function so I can do this for about 3000 files. [login to view URL] is the type of file that I need converted
I have a large number of MS Word documents that contain several numerical figures which need to show the equivalent in another currency based on flags set centrally. This requirement stems from the adoption of the Euro by my country and the need to show both the currency existing currency as well as the Euro equivalent on all currency amounts. What I am looking for is a macro or code or whatever t...
I need a coder to code in vba/excel, creating pivot tables on the fly, based on an existing recordset...if you have experience with this, please submit and I will send you further information. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables
...class room setting. Photos would be of teacher with poorer class students (no uniforms). We will give more detail of project to interested bidders. Necesitamos fotografias por un sitio de web en construcion. Somos un compania de caridad que empece programas de educativo en America Latino. El proyecto es para 20-30 fotografias de un maestra y su estudiantes
...someone who can assist me in maintaining / improving / customizing the program on a LONG term basis. GOOD communication skills a must. Must be VERY proficient in VB 6.0, VBA, SQL and MS ACCESS database programming and management. High speed internet is a must files are LARGE Please respond with what you would like to see on an hourly rate
Hi - I need a quick function to run as an Event Procedure in MS Access that will do this: On a form I have a textfield [tel] that contains an unformatted telephone number. On DoubleClck I want to take the value in [tel], strip out all non numbers and system call the hyperlink sip://[tel] Thus: if [tel] = (0845) 00-00-00 then onDblClick will call sip://0845000000 Thanks! #...
...controls in use, specifically by dbi-tech and DevExpress. I would like these converted to a .NET equivalent. All of the OCX's that are in use are supported by classes built in VBA. I would prefer someone who can build an architecture so that the forms that are built are inherited from base forms that share common functionality, like DAL, error handling
Greetings, Inspiration Homes has created two MS Excel spreadsheet shells containing the records of all licensed subcontractors in King and Snohomish Counties in Washington State. The initial dataset record is keyed by each subcontractor license number setup as a hyperlink to the state's applicable Labor and Industries website page for each subcontractor
I have 2 vba procedures with the following names : 1)Add custom menu 2)Remove custom menu These 2 procs add within ms excel 2003 a custom menu in the built in menu system. I would like to create a setup program that allows user to add or remove the custom menu so I can distribute it to users and simply run it on there machine. Currently I have to send
Basically, the project invovles creating a simple VBA program, which will take in 2 excel files, compare its contents... and display out the line entries which have changed. Each file will have headers like: Name, Category, Serial No
Need a VBA module for an Access 2003 mdb that builds pass-through queries. 1. The SQL statement text will come from a table in the mdb. 2. The connection string parameters will come from a table in the mdb. End result: The end user can build a pass-through query and not have to know the SQL statement and the odbc login happens automatically
...Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Preferable language would be either VBA which is embedded in one Access Table which can reference another external Access Table using an Input Form or ASP 3.0 as a web application to do the same thing using ADO and
...UserControl to create a new VB 6 Form. However it does not have a function to process Multipage controls in VBA. I just need a module written that converts Multipage controls in VBA to SSTab controls in the VB form. In our current scenario, we have a VBA UserControlForm containing one multipage with five tabs, and each of those tabs have another multipage
Hello, we need to tool written in vba to duplicate data from several mdb´s (stored in an table) to mysql. Furthermore the data in mysyl has to be available in the access database. There must be a setup procedure to do all the settings as we don´t know to do something else with mysyl. Please contact me if you have any questions. I
I have manual process of entering data from txt files into excel. What I basically need is a macro to be able to open the text files extract the data put the data in the correct columns. The actual calculation is done by formulas already on the actual excel file. So its just basic data entry macro to save time that I wish to create. The number of
Hi, we need to have an tool for our existing ms-access database to manage, see and upload or remove pictures to an ftp. If an bitmap file is selected it should be exported to an jpg-file as well as it must be able to input pictures by an twain-scanner.
View [login to view URL] for a brief review of the requirements (attached specification has more detailed requirements) 1) The excel VBA macro reads in a directory of .txt files. 2) It then creates 4 sheets and places different information from the files into these sheets. Some simple manipulation of the data is required. 3) It compiles several
...mantenga el sentido y las partes esenciales. Idealmente busco freelancer con buen conocimiento del inglés que le sobren 2 horas a la semana para completar 2 entregas semanales. Pago a convenir (por todo el proyecto o por bloques de 4 o 8 entregas). Indicar modalidad elegida en la oferta. -------------- The job consists of translating and summarising
I am looking for a small VBA script to be written in Excel. Added to a button, of an Excel sheet. I want to click the button and the script runs and does it thing. The script must open a simple .txt file (Thunderbird email inbox), and parse through all the data searching for email addresses. When it finds an email address, write the email to the 2nd
...from a pari-mutuel site. The site provides this free to registered users via the Web Services Toolkit in Excel. Two class modules are downloaded into the VB Editor and example functions are provided but I cannot get them running. I need an Excel VBA solution if possible to integrate with existing code. My attachment gives the site details and the code
We need two routines that do roughly the opposite thing of each other: encode and decode a range of Excel cells. This needs to be implemented in Excel VBA. To give you a better idea, here's a sample of an encoded string in the format we need: 3,2,N:’654.82’,D:’5/13/2006’,T:’A piece of text with ‘‘ “ special chars’...
Hi, I need to have a web page designed. It's going to be for an online radio. The name of the radio is "Lima Infinita" and the slogan is "Sin limites!!". I want the following colors to be used: 1.- #EE2C00 2.- #6A6A58 3.- #000000 I don't want a real fancy design but a pretty one so that when people visit the website they're like "omg this is my
I have powerpoint presentation. I would like to insert combo boxes in the powerpoint presentation. The combo box would have a list. When you click on an item in the list, you will be sent directly to that item's slide. ## 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...
This a peace of a code in VBA (excel) that is much too slow. Can someone (maybe by using another language C++) help me to make this code much faster? Full code in attached excel file. As you can see I first retrieve 1 year or 260 days price data of 100 stocks. And construct all possible 10 stocks portfolio. VBA code: nbsec=100 myHighest = -50
...flash/java platforms and feed them into Excel to be able to run real-time analysis across different companies. Also, have a 'software' which effectively replaces the human 'click' when a trade is to be excuted on one of the betting platforms and performs this operation automatically based on conditions setup in excel via VBA etc. Please let me know...