Excel VBA Data Manipulation

$10-30 USD

Closed

Posted

9 months ago

$10-30 USD

Paid on delivery

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' [login to view URL] = False sheetxx(i).Select [login to view URL] (Now + TimeValue("0:00:05")) '[login to view URL] "({1068})", True 'DoEvents pdffilename = fname2 & "\" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "\" & sheetxx(i).Name & ".jpg" Shell ("D:\khalid\[login to view URL] savescreenshot " & jpegfilename) '[login to view URL] (Now + TimeValue("0:00:01")) Shell ("D:\khalid\[login to view URL] " & jpegfilename & " " & pdffilename) ' [login to view URL] = True sheetxx(i).Select sheetxx(i).ChartObjects(1).Activate For Each objCht In [login to view URL] [login to view URL] fname1 & i & ".gif", "GIF" Next objCht Next i Key Requirements: - Manipulation of data: The main objective of this project is to create a script that will consistently and accurately manipulate data within my Excel sheets. This includes sorting, filtering, and performing calculations on the data. Ideal Candidate: - Proficient in VBA: The ideal candidate should possess advanced knowledge of Excel VBA, able to write clean, efficient, and error-free code that can handle large data sets. - Experience with Database Interactions: The VBA script will need to interact with databases, so any experience in this area will be highly beneficial. - Time Management: The script will need to run at scheduled times, so the ideal candidate should have experience with scheduling tasks within Excel. If you have a proven track record with similar projects and can create a reliable and efficient VBA script to manipulate data in Excel, I'd like to hear from you.

Excel

Visual Basic

Visual Basic for Apps

Data Processing

VB.NET

Project ID: 38117768

About the project

38 proposals

Remote project

Active 7 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

38 freelancers are bidding on average $29 USD for this job

@axiomswb

Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

$20 USD in 1 day

5.0

(56 reviews)

7.0

@vsprybhanu

Hi, I can develop or edit Excel VBA Script as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra

$30 USD in 3 days

4.8

(148 reviews)

6.2

@snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh

$30 USD in 1 day

4.8

(54 reviews)

5.9

@janita24

Hi There Khalid A., Good morning! My name is Jane a professional writer and a designer with skills including VB.NET, Excel, Visual Basic for Apps, Visual Basic and Data Processing with over 5 years. I have extensive experience in the following areas; - Editing and proofreading - Graphic design - PDFs - Word fillable forms - Customized PowerPoints templates - Keynote templates - OCR - Latex - Adobe InDesign Therefore, I am confident in my ability to deliver high-quality results for this project. I am eager to discuss further details and see how I can contribute on your project. I am happy to offer a free consultation and a 10% discount for first-time clients. Please send a message to discuss more about this project. Regards Jane

$50 USD in 1 day

5.0

(16 reviews)

4.2

@freddyho

Hello, I'm a developer with over 10 years of expertise in VB.NET, C#.NET, VBA, and other programming platforms. For your task: - Create VBA, including the given code, and also sorting, filtering and performing calculations. - Saving to a database - Make the excel macro can be executed regularly at schedule times. I can do it excellently. However, please confirm/advise: - The macro will be used in windows desktop (instead of Android, IOS, etc) - What database that you mentioned? is it Microsoft Access database ? Mysql database? Thank you for considering my proposal. I look forward to working with you. Please let me know if you have any further questions about this proposal. Best regards, Freddy Ho

$30 USD in 1 day

4.8

(12 reviews)

4.4

@haniff0903

Hi, Excel VBA is my field of expertise, you may lean on me to deliver this project in a top-notch quality as I have worked with several projects involving VBA. Reach me out if you are interested.

$80 USD in 7 days

5.0

(8 reviews)

4.3

@ranadeep1

Hi Employer, As I can see you need help with modifying the existing macros to perform new tasks and also at time intervals. I can help you upgrade the existing code with out disturbing the current functionality. Please message me to start work immediately and deliver in the next couple of hours. Thanks Rana

$25 USD in 1 day

4.8

(14 reviews)

3.7

@webindia1984

As a seasoned Excel VBA developer, I understand the critical need for accuracy and consistency when handling large sets of data. I have had extensive experience in sorting, filtering, and manipulating data within Excel sheets - skills which would be directly applicable to your project. Moreover, my proficiency in VB.NET perfectly complements my Excel abilities as it equips me with the skillset needed to work seamlessly with databases which will be crucial within your project. One of the main benefits of choosing me is my time management skills. I have ample experience with scheduling tasks within Excel ensuring that your script runs at specified times accurately and efficiently. My approach to all projects is guided by the latest trends and practices, ensuring that my solutions are not just functional but also modern and stylish in their implementation. My track record speaks for me; I'm known to always deliver clean, efficient, error-free code that stands up to scrutiny even when handling huge datasets. Your project deserves nothing less than that. So, if you want someone who brings not only technical expertise but also diligent time management and a dedication to modern design principles, I'm confident that I am your ideal candidate.

$122 USD in 1 day

4.9

(3 reviews)

3.7

@Daksheshmahaur96

As a seasoned VBA and Excel expert with 3 years solid experience in MIS Data Management, I firmly believe that I have the key skills and insightful perspective necessary to address your needs. Throughout my career, I've been entrusted to fix intricate complications in Excel formulas, create dashboards and charts, automate processes through VBA, and establish core database interactions. Through consistent practice of VBA, I am confident your data manipulation tasks will be met with precision and efficiency, regardless of the scale or complexity. Being adept at Time Management, I can assure you that your script will be robustly designed right from the start to perform specific tasks at scheduled intervals. Moreover, my expertise extends to Power BI development as well. This affords me a deeper understanding of data presentation and management that enables me to think creatively to create avant-garde solutions. Finally, reliability is not just a term for me - it's an absolute necessity. I am committed to delivering only error-free code that can execute flawlessly even with sizeable data sets. In addition, I will be readily available for any troubleshooting or modifications arising from changes in data structure or future business requirements. Consider partnering with me for an enhanced Excel solution that guarantees consistent immpecable performance!

$30 USD in 1 day

4.5

(25 reviews)

4.1

@kavitadhingra

With over a decade of experience in the industry, a major portion of which has been devoted to VBA and Excel automation, I'm incredibly at home operating within an Excel environment. With my advanced skills and coding expertise, I'm confident in my ability to create a clean, efficient and accurate script that will consistently manipulate data within your Excel sheets as needed. Not only am I well-versed in handling large datasets accurately with VBA, but I'm also committed to timeliness and consistency. I understand the importance of tasks running at scheduled times and can assure you that the VBA script will be well-designed to achieve this goal effectively and minimize disruptions to workflow. Additionally, my significant experience with Power BI projects involving multiple data sources like SQL server, Oracle, Azure databricks, Excel sharepoint shows that I won't just complete the job but bring valuable insights and outcomes. Let's discuss your exact needs and embark on a project that ensures regular and correct exports every time!

$20 USD in 2 days

5.0

(9 reviews)

3.2

@devbaloni1983

As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as possible. I offer excellent software quality work and provide the best support for your project. If you give me this job, I will do my best to finish your job by your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss this with you about the task now. Thank you for the reading

$20 USD in 7 days

5.0

(2 reviews)

3.0

@syedalihassansh4

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA

$10 USD in 1 day

5.0

(12 reviews)

2.6

@smzaman01

"Hi I am an engineering professional having more than 15 years of working experience in different world recognized MNC company. I have gone through your requirement. I have relevant experience of excel. I know VBA in excel. So I can do your work perfectly. I am sure you will be happy to get my service. Lets have a chat on this. Regards, SM Moniruzzaman "

$29 USD in 1 day

5.0

(3 reviews)

1.3

@Asadalibajwaa

As a seasoned Excel VBA developer, equipped with over 10 years of experience, I have acquired advanced capabilities in data processing and management. My comprehensive understanding of Excel and VBA enables me to write clean, efficient, and error-free codes that can effectively handle large datasets. As evidenced by my long-standing career in domains such as Cyber Security and Machine Learning, I've honed exceptional time management skills which are crucial for creating a reliable scheduling system for your project. Furthermore, my proficiency extends beyond just Excel as I am also highly skilled in Python, C++, MATLAB, Proteus, AMPL and more. Notably, I'm adept at finding innovative solutions for complex problems; problem-solving being central to both the domain of Cyber Security and Data Manipulation. My research-oriented mindset – exemplified by patents, journal publications (IEEE COMST, IEEE Network Magazine) and conference proceedings (IEEE ICC) – also distinguishes me from others. This distinguishing attribute will enable me not just to create the VBA script you require but to also provide valuable research input as needed to improve the efficiency of your project. Considering these credentials,

$40 USD in 2 days

5.0

(2 reviews)

1.3

@aliY00

Hi, my name is Nor Aliya from Malaysia. With over 3 years of experience in data entry and a keen eye for detail, I'm confident that I can provide the professional handling, sorting, and manipulation of your crucial data within your Excel sheets. Having dealt with confidential information extensively, I understand the value you place on accuracy and security and can assure you that your data will be properly handled and verified. Where I truly shine is my speed and efficiency, which is crucial when working with large datasets. My fingers dart swiftly across the keyboard enabling me to quickly execute tasks like sorting, filtering, calculations etc, which are going to be central to this project. One aspect that sets me apart in this space is my background in Data Processing. I bring an adeptness for identifying and rectifying data entry errors - a skill that will prove invaluable as we work towards creating reliable VBA code. Additionally, my affinity for adhering to schedules aligns perfectly with one of the key requirements - the ability to manage time effectively by scheduling tasks within Excel. All in all, I'm excited about the opportunity to put my skills to use in solving your problem. I am looking forward to hear from you soon. Thank you. Regards, Nor Aliya

$20 USD in 7 days

0.0

(0 reviews)

0.0

@waznahas

I’m Waznah, an experienced Excel specialist with a proven track record in efficiently managing and analyzing data using advanced Excel functionalities including VBA. Over the years, I’ve honed my skills to become proficient in creating robust, efficient, and error-free VBA scripts that can handle large data sets. This not only includes sorting and filtering data, but also performing complex calculations – precisely the skills needed for your project. One of the key qualities I bring to the table is my extensive experience in creating and maintaining Excel spreadsheets for various purposes including data entry, budget tracking and project management. I am highly skilled in using formulas and pivot tables to effectively analyze data, which would be valuable when examining and manipulating your data. Furthermore, my solid understanding of Database interaction will ensure a seamless integration of your excel sheets with databases. Lastly but importantly, my proficiency in time management within Excel will enable me to execute the task according to your schedule without compromising on accuracy and efficiency. I am confident that my expertise combined with my excellent communication skills will make me the ideal choice for this project.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@harjotsingh1324

Details Proposals User Avatar Eight Veer Ltd T/A 8veer @EightVeer Flag of United Kingdom in 8 days Driving Innovation, Strategic Impact With a dedicated team of professionals and extensive expertise in data entry and processing, my profile as an 8veer consultant aligns perfectly with your project requirements. Seasoned in entering detailed information into Excel swiftly without compromising on quality, I understand the importance of accuracy and efficiency in data management. Mastery in Excel is a cornerstone of my skillset; I've effectively managed complex spreadsheets, performed formatting and analysis tasks, and utilized functions to streamline data. These techniques will ensure that not only does the information gets transposed accurately, but it'll also be presented neatly in an organized manner, allowing for easy access and analysis when needed. I am aware that reliability is another major component of a successful data entry project. My past performance records speak volumes about my attention to detail: my robust checks throughout the process would minimize errors or omissions, providing you with the desired output. Therefore, I guarantee to deliver an exceptional final product- accurately inputted data presented attractively in an Excel spreadsheet! Replies within a few hours

$20 USD in 7 days

0.0

(0 reviews)

0.0

@mdmizanur3

Hello sir, I have read your project details. I understand what you need just send me a message and I can do it. I have done similar things before. I have experience in this job, you can give me this job if you want. I am not a beginner. I always put clients first through my work. I love to talk friendly. Because if you talk in a friendly way, any work seems very easy. I am waiting to receive your positive feedback thank you Mizanur

$25 USD in 1 day

0.0

(0 reviews)

0.0

@saipavanik

Because my excel knowledge was advanced I can complete the task within the time limit and thank you

$20 USD in 7 days

0.0

(0 reviews)

0.0

@amrit539

“I think my attention to detail and accuracy set me apart from other candidates. I also have a lot of experience working with data entry and administrative tasks. I'm confident that I have the skills and experience necessary. I'm also very motivated to get the job done, and I have a lot of enthusiasm.”

$20 USD in 7 days