Xlsmemplois

...colonne " Achat fréquent" Ca me mette que son meilleur achat est l'objet G. Et ceci pour chaque client. J'aimerai aussi que mon tableau excel quand je trie par ordre alphabétique les clients, ou par meilleur client, les montant totaux des clients restent sur la même lignes du client. ( Avec le tri, les client se trient, mais les montant ne concordent plus). En pièce jointe en fichier XLS et en XLSM Merci de votre précieuse aide....

I need a solution to synchronize an Excel file (.xlsm) on my Windows computer with an online version stored in SharePoint that is an xlsx. This online Excel file is updated through a MS Form submission which I need reflected on my local system, and I would like this process to be automated. Key Project Elements: - Set-up automated synchronization between a local Excel file and a similar file on SharePoint - Ensure updates from a MS Form submission to the online file are accurately reflected in the local file Ideal Skills and Experience: - Strong knowledge of SharePoint and Excel - Proven experience with automation software - Familiarity with MS Form submissions.

...function in excel. Keep in mind that the number of cycles being performed is variable. Here are a couple of notes for this assignment: * In order to easily access VA in your Excel files, you should enable the "Developer" tab in Excel: go to File → Options -> Customize Ribbon, and check the box next to "Developer" in the "Main Tabs" list. * Your Excel file must be saved as a "Macro Enabled" (xlsm) workbook. The template provided is already formatted this way, but make sure not to change this when saving your workbook. * As you work through this assignment, be sure to save your work regularly and test your code often! I recommend decreasing the number of years, cycles, and projects in your input (e.g., 2 years, 2 starting projec...

...(Line 1, Line 2,... It can be populated up to 35 rows) On the user click on the selected combo box value (they click for example on Line 2) it should populate a list view or any other container by your choice with the Excel file on the corresponding path (see attachment "" column Path). Please note that all the excel files have the same structure, see example in the attachment ("Line 2.xlsm") List View should refresh every 15 minutes when the user is inactive. On refresh, it should re-read the Excel file as stated above(because the data is constantly changing) and it should archive it (see attachment "" Column ArchivePath)- It should override changes in the current list (if already exists in the Archive, if not it should just append it at the end) ...

I am seeking a skilled programmer to create a tool that consolidates various file types from a folder (xlsx, docx, docm, xlsm, pdf, outlook msg, txt, rtf, pptx, jpg, png, MS Office formats) into a sole, organized PDF. The resulting PDF should maintain the original order of the files in the source folder. Furthermore, this tool should also have the capability to extract and concatenate all attachments from outlook messages. Key features needed in the tool: • Merge files in their existing order. • Extract and concatenate all attached files. • Should skip any files that cannot be converted into a PDF format, such as executable files or certain types of media files. • Adapt the outlook .msg to portrait or landscape when creating its PDF equivalent. • Create a...

...content that Table 2 does not contain. - The determination of new content is based on the changes in multiple columns. - Specifically, Columns 1, 3, and 4 in Table 1 should be checked for alterations. - Table 2 is protected by a password (known) from the begining and must be protected after the oparation. - The name of tables must be easly configurable. - Table 1 or Table 2 may be or not at the same xlsm file (configurable). - A msg box must appear after the oparation: " [Number] new rows added." - An adept freelancer should provide a report how to configure the Macro, in case of increasing or reducing the number of rows, or doing the basic configuration. Skills and Experience: - Excel Macro Development - Visual Basic for Applications (VBA) - Experience in Data Transf...

CONSIDER: 1. Only if the .exe file is opened from Excel should this work without a problem. The file must work and have an opening password, the password is 123 Here the macros must work and be displayed 2. However, if someone changes the extension from .exe to .xlsm, the VBA codes or modules should be automatically removed. This is what is requested. In other words for SECURITY the file will only keep its VBA modules while it is as .exe if it is changed to .xlsm it must be deleted. Consider not using the method where the excel file is created and taken to the TEMP folder, because that is easy to find and hack The file is attached so that work can be done there. It is also requested that you teach me how to do it step by step so I can do it with my projects. If you have

CONSIDER: 1. Only if the .exe file is opened from Excel should this work without a problem. The file must work and have an opening password, the password is 123 Here the macros must work and be displayed 2. However, if someone changes the extension from .exe to .xlsm, the VBA codes or modules should be automatically removed. This is what is requested. In other words for SECURITY the file will only keep its VBA modules while it is as .exe if it is changed to .xlsm it must be deleted. Consider not using the method where the excel file is created and taken to the TEMP folder, because that is easy to find and hack The file is attached so that work can be done there. It is also requested that you teach me how to do it step by step so I can do it with my projects. If you have

Create A Microsoft Excel VBA script that adds custom text to 4”x6” PDF labels, the text would be provided inside the excel workbook. The xlsm file will be in a folder which will also have an ‘Input’ folder and an ‘output’ folder. The input folder will be supplied with the original pdf file (which will be of varying page lengths), and then this macro will add text to each page of this pdf, and output the altered PDF to the ‘output’ folder. How I will use this macro is, the PDF file contains 4x6 labels, which will be printed off and each one put onto a cardboard box (case), containing units of inventory (SKUs). Each SKU will have a certain number of cases, anywhere from 1 and up. The information that was added to these labels will h...

I am looking for someone who can help me modify an Excel Macro to copy values from one sheet to another. The specific requirements for this project are as follows: I have a xlsm file which takes data from another xlsx file and draw histogram, what I need is that the same data should be copied to another sheet in the workbook Data to be copied: Values Format: Same Format Frequency: This question was skipped Ideal Skills and Experience: - Proficient in Excel Macros and VBA - Experience in modifying and customizing Macros - Strong understanding of data manipulation and copying in Excel - Attention to detail to ensure accurate data copying - Ability to troubleshoot and resolve any issues that may arise during the process If you have the necessary skills and experience, please submi...

we need to include the cutting stock problem (where you calculate the best way to cut your required lengths form stock lengths to end up with minimal waste). its 1 dimensional meaning just linear length. we found the open source code in py i need assistance to include that into a xlsm so we can utilise it on required lengths and stock lengths from within our workbook.

a. Insert password as discussed so lock and unlock can be done when needed. b. Fix bug issues (macro) c. Hide sheets as per the original xlsm file

Making an excel graph based on changing data. I Have attached the excel file I need help with (time graph 1208.xlsm) I have attached a word doc we produce from the date in the spreadsheet (week end 0608) I have already made the spreadsheet but I need help with the Graph and getting it the correct size Each day we write in drink times each half an hour. We only currently are tracking 3 days (Thu, Sat & Sun) All days have different starting opening/closing times Thu 5pm-9pm Sat 10am-5pm Sun 11am - 5pm The date & data is entered on sheet "30 Minute Times" The graph is produced on sheet "Graph" We use the screenshot button to take a picture of the graph. I need the graph only to display the times for the day (see above Thu,Sat,Sun) as our problem is the ...

I have xlsm file which has some macro function to calculate the inputs and it generates result. Now I am putting details manually to process through xlsm. but now I wanted to get it done on the fly. for the same I required API which can push data to xlsm file and pull data from xlsm file. I have application in PHP . but you can develop API in any technology so that I can call to developed API and handled in my application.

I am looking for a freelancer who can help me convert my Excel application xlsm into a web application. The primary purpose of the Excel application is financial calculations. I require the web application to have real-time data updates, which is essential for my business needs. My preferred technology stack for the web application is PHP/MySQL. Ideal Skills and Experience: - Experience in converting Excel applications into web applications - Proficiency in PHP and MySQL - Knowledge of real-time data updates and how to implement them in a web application.

I have .xlsm file with Macros. It is working fine in Windows but not in MAC. I don't have code for this. I need someone who can help me to work it in Macbook Air.

I have an Excel .xlsm file containing Macros and it is not running on Macbook Air and giving compilation error i.e. "Compile error in hidden module: ModuleName. I am looking for someone who can help me to make it work on Macbook Air. Note: It is perfectly working on windows machine.

The file has 3 modules. Two of them are hidden. The process of hiding is: zip .xlsm, get into xl folder, edit with a hexadecimal editor the file .bin and hide the modules. If you know what i am talking about please tell me

Hi, Im looking for a custom python script that will do the following: It will add a watermark(custom text) to any of the following filetypes: 1. Pdf 2. Office docs - word(.doc and docx), excel(xls, xlsx, xlsm), power point(ppt, pptx) 3. Image file formats (JPEG (or JPG), PNG, GIF, TIFF, PSD,PDF, EPS,AI) No front end or gui needed. Using python libraries and not a third party application. 2 modes of operation: Mode 1 - if the file has custom metadata - then use the custom metadata as the text for the watermark. i will be guiding you on this. Mode 2 - if there is no custom metadata - then use the built in custom text - this will be editable in the actual script - so please document and comment where this is changed. Special Notes: The script will automatically apply the watermark of...

I have a xlsm file which has multiple spreadsheets. I need a macro to protect all the cells that has formulas in it so that users do not edit the formula and lock all the spreadsheets.

Hi, I have a spreadsheet that I need to create 3 to 5 macro buttons, to create a new worksheet, that involve coyping fields, extracting rows that has empty fields on a specified column, save as xlsm and csv format, & etc...

...{""Column2"", type text}, {""Column3"", type text}, {""Column4"", type text}, {""Column5"", type text}, {""Column6"", type text}, {""Column7"", type text}, {""Column" & _ "8"", type text}, {""Column9"", type text}, {""Column10"", type text}, {""Column11"", type text}, {""Column12"", type text}})" & Chr(13) & "" & Chr(10) & "in" & Chr(13) & "" & Chr(10) & " #""Changed Type""" Workbooks("Bets_v.02.xlsm"). "Query - Table 0 (2)", _ ...

...being at the same price as the third voice. I need to be easily able to change the value of x. I am on a very limited budget and only need the help as my disability means that I cannot work quickly enough. We must be able to communicate via WhatsApp. I need the time for creating text-to-speech voice samples, something that I can do more quickly than this Wordpress work. I have attached a safe xlsm file, the first sheet showing the website prices for Alinea Suite in green. I need separate variations for the UK and Ireland, such as the UK "Access to Work" licences and the Ireland / Eire "Workplace Equipment Adaptation Grant" equivalent. Anybody in the world can buy a Springboard PC-1 Keyboard or text-to-speech voice Only people in the UK and Ireland / Eir...

I have 2 different files that both need a few modifications each. They should be fairly simple as most are removing or reordering bits of current macros but they do require someone with a good understanding of Macros. 1.) Mailer Program Generate Availability V3.18.xlsm 1a.) Remove the functionality of button 5 compare live links and the button itself 1b.) Rearrange the buttons, the order should be 1, 6, 4, 2, 3. Obviously once reordered please renumber them to make it logical. 1c.) The run all button should be in the above order too with out the functionality of 5 Compare live links. Also on run all need to acknowledge the pop ups as want it to run all not keep stopping 1d.) When you click button 1 it leaves the file open which is good as we often check it. But currently it error...

I have microsoft excel .xlsm file saved in the google drive. i wanna make one excel sheet to be updated into google sheet excel everyday. Is it possible to using google app script only? i have budget $25 only

Move data in specific ways between an existing Google Sheet doc and an existing .xlsm file. Data transfers both ways.

I am looking to replace some of the columns of the current program/ .exe file which utilizes VB.NET. I have the new VBA code to replace the indicated columns, but I don't know how to replace the new/replacement column calculations without mess...exe" 2) "" 3) "" 4) "" The final output of running the .exe file with the attached accompanying files is found in the attached "". The new code to be utilized to replace the indicated columns of the .exe file / "" file can be found in the VBA code of the attached "Fractal Study Program_v3.0.xlsm" file. Data to be used if you want to run the "Fractal Study Program_v3.0.xlsm" file is the attached "Fractal Study " file. Please let me know if you ha...

Hi we have a single file VBA xlsm file that processes data into tabs and then outputs to a pdf service. we need the code documented into a type of developer map. as well as understanding VBA as you will need to understand what the code is doing, you will need some good business/documentation skills/disciplines. Part 1 is approx 20-30 hours work.

I need a code for Excel VBA to be created that exports all sheets within the workbook to a specified file path on my computer. This should take place every 40 mins. This should run in the background and should not close or affect the current xlsm file.

Modification of ‘Business Plan template v02.xlsm’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.

Modification of ‘Business Plan template v02.xlsm’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.

Needed are very basic samples for CMD (commandline dialog, black window) for Windows Rules: 1) read all instructions before you bid 2) Expert is needed that will do these tasks less than 5min per each task. If unexperienced programmer applies that is fine, however cost is still evaluated same ...be written in Windows Notepad, saved as BAT and should do what is in requirements (attached TXT file) 12) one bat file should not include other code that needed and should not call other dlls or similar. It should be pure bat for Windows 13) Excell macros should work in excell, part of Microsoft Office 2016 pro. Attached base excell file that you start with. 14) test attached excell file "Book1.xlsm" with built in macro 15) do not lock macro file at the end 16) if you bid you agre...

Needed are very basic samples for CMD (commandline dialog, black window) for Windows Rules: 1) read all instructions before you bid 2) Expert is needed that will do these tasks less than 5min per each task. If unexperienced programmer applies that is fine, however cost is still evaluated same ...be written in Windows Notepad, saved as BAT and should do what is in requirements (attached TXT file) 12) one bat file should not include other code that needed and should not call other dlls or similar. It should be pure bat for Windows 13) Excell macros should work in excell, part of Microsoft Office 2016 pro. Attached base excell file that you start with. 14) test attached excell file "Book1.xlsm" with built in macro 15) do not lock macro file at the end 16) if you bid you agre...

Needed are very basic samples for CMD (commandline dialog, black window) for Windows Rules: 1) read all instructions before you bid 2) Expert is needed that will do these tasks less than 5min per each ...be written in Windows Notepad, saved as BAT and should do what is in requirements (attached TXT file) 12) one bat file should not include other code that needed and should not call other dlls or similar. It should be pure bat for Windows 13) Excell macros should work in excell, part of Microsoft Office 2016 pro. Attached base excell file that you start with. 14) test attached excell file "Book1.xlsm" with built in macro 15) do not lock macro file at the end 16) if you bid you agree to all these terms 17) looking for long term cooperation, these are very simple programs, n...

We have an Excel spreadheet – an xlsm sheet. .There are a set of input fields, and a set of output fields. .The sheet is structured into 5 tabs. .We care about Tab1 (Kerosene) and Tab5 (Kersosene – Thermal Properties). .Tab1 calcs its output fields from its Tab01 input fields and Tab01/Tab05 constants. .The calcs rely on Excel Visual Basic (VB). .We want to convert the sheet and its VB into an equivalent command line php program

Hello I would like to create professional quality presentations in PDF format requirements: 1. the underlying data to contribute is in either csv, txt, or xlsm format. potentially also JPEG 2. i need filtering on the data to produce specific presentations 3. i need to be able to add qualitative data based on my own comments/analysis 4. the entire document will need professional formatting in order to look professional quality and presentable

I have a program that was dropped in my lap that will need modification. However, even though I can install the program and see the Add-In in Microsoft Excel, I can't edit it. Also, in the source the .xlsm file doesn't appear to show any reference to the program being used. I can't seem to open the .sln file in Visual Studio. It just says VS 2013 can't open the file. I'll provide the entire source and bundled install. I need to figure out how to edit the application. What are the requirements and what do I need to do to edit it? That's the first milestone needed. I need to understand how to edit and change the program. I have worked a lot with MS Office, macros, VB.NET, C#, etc, but this thing baffles me. The first milestone will be $50. Onc...

...and we should also support a simple command line that will also execute this immediately. lets assume for a minute just windows desktop folder. I want to run this exe and then it will sort all of the files on the desktop to folders. For example all of the images will go to a folder called IMAGEs. all of the spreadsheets will go to a folder called EXCELs, which is file types, xlsx, xls, csv, tsv, xlsm. We should be able to manage all of the file type associates in a simple csv that looks like this -if the extension is not in this csv then we leave it as is. -if the file is in use we should leave it alone and not try to use shadow copy etc.. now for the config of where to run. Ideally I can

This is a B2B website based on Wordpress woocommerce. The purpose is to lead gen. The data in the .xlsm format that the client have needs to be reflected on the website. In the excel sheet, the client has all images linked to their respective designs. This means if you hover your mouse over that design, you can see the image in excel itself. I do not want the work of one-by-one upload of product data and its images. That's why this projects is posted. If you are someone who knows API integration, Automation wyhis project is for you.

hi, we need a working xlsm file with vba code to create a custom ribbon in excel. this part 1 task is simply to show u you can do it, then we will have you work on this and other ribbon setc going fwd (we also have many other vba tasks) so we need a simple xlsm, you can create it, then add 1 custom ribbon to it called "TestTab" with 2 sections, each with 2 buttons in it. include all code in the xlsm you supply.

Hello we need to have this completed in excel xlsm VBA. We need script that will iterate through every currency and every Nodes value in the direct xml, not import. Please use following xml link to access currencies and values and link directly (not download xml and import): please write values into excel sheet like this: A1: USD, B1: 1.0523; A2: JPY, B2: 135.76; A3: BGN, B3: 1.9558, etc… Please do not apply if you are not skilled VBA developer, Do not apply with 0 projects. Please read carefully and write a solution. The budget is 20Eur, no exceptions.

...the rows with data in them. Do you have a better idea of what formulas could be used to work on a Mac? 2.) Mailer Program Generate Availability V3.18.xlsm 2a.) Remove the functionality of 5.) compare live links and the button 2b.) Rearrange the buttons, the order should be 1, 6, 4, 2, 3. Obviously once reordered please renumber them to make it logical. 2c.) The the run all button should be in that order too and also remove the functionality of 5. 3.) XML_Converter_v12.7.xlsm This macro automatically prints a page when it processes the file. The program works well I just need it to NOT print the page. 4.) Process Internet Orders_v2.xlsm 4a.) Remove the part of this program that checks is stock is available, if it is NA or negative stock and do not change the dat...

I want create an html web pages takes inputs and enters in an excel file (xlsm) and calculates the sheet and brings the output to web

Busco un buen programador-a de Macros que sea rápido y eficaz (para esta y otras Macros). En concreto, para esta macro, partiendo de una lista en formato Excel "*.xlsm" de operaciones financieras que ya han sucedido y donde cada operación tendrá su fecha de inicio y su fecha de cierre... Entre esas 2 fechas y en un momento dado habrán N operaciones simultáneas abiertas. Y entre esas dos fechas habran habido X ocasiones en que ha habido N operaciones simultáneas abiertas. Pues bien, esta Macro calculará: 1. El número X de ocasiones en que ha habido N operaciones simultáneas abiertas. 2. Dentro de cada una de las ocasiones anteriores, la macro calculará la diferencia de tiempo entre el inicio de la &...

In recent Microsoft updates, they set VBA macro-enabled workbooks from the internet with an attribute called "Mark of the Web". This attribute has caused my excel workbooks on my network drive to become unusable, as when I open the workbook, macros are blocked. A picture of the error is attached and I have tried everything that they have suggested in the below link without luck. Maybe I am doing somthing wrong, but setting my network drive to a trusted location and recognized as a trusted source does nothing. Setting Excel 365 to recognize my file as a trusted file yields no results. This error does not allow me to turn on macros regardless of excel policy settings for the file that I open from my network drive. I do not want to copy the files locally. The error does not ex...

Hi Waseem S., how are you? We can discuss any details over chat. Firstly congratulations you have been awarded for the fcc scraping job. I have a special offer for you. I prepared a proposal for the same job. But yours has been chosen I have scrapped all data you are trying to get now. It's fully ready. If you wish I can sell full ready data to you for 19 USD. You sav...congratulations you have been awarded for the fcc scraping job. I have a special offer for you. I prepared a proposal for the same job. But yours has been chosen I have scrapped all data you are trying to get now. It's fully ready. If you wish I can sell full ready data to you for 19 USD. You save time and money without spending any effort. If you accept, you will get a full set of data in an xlsm...

...como input una hoja en excel que tenga los siguientes datos: RUC, Monto, retención, Descripción de la operación y cuota, se pueda ingresar estos datos automáticamente y que antes de mandarlo a la base de datos de la SUNAT, el usuario pueda revisar la factura y luego le de click. Eventualmente podríamos obviar el paso anterior (adjunto Excel que tiene la data nates mencionada - Fact_May22-fact_v2.xlsm). link: 2. Automatizar la descarga de facturas recibidas y que se complete una base de datos que recoja la información necesaria para enviar la data al área de pagos: montos, RUC, fecha de emisión y código de la factura. (Adjunto un correo tipo de la información en el formato en que se recibe de REP). Los corre...

I need some basic edits to an existing VBA maco, probably 4-6 hrs max. With an option to pick up new projects afterwards. Must be co-working on a shared session, I only operate that way

I need some basic edits to an existing VBA maco, probably 4-6 hrs max. With an option to pick up new projects afterwards. Must be co-working on a shared session, I only operate that way

I need some basic edits to an existing VBA maco, probably 4-6 hrs max. With an option to pick up new projects afterwards. Must be co-working on a shared session, I only operate that way