Find Jobs
Hire Freelancers

VBA Excel help

$30-250 USD

已完成
已发布将近 5 年前

$30-250 USD

货到付款
I have an excel file which needs to run a Before save macro based on the value in the dropdown. I am new and picked a macro from internet and customized it to save the file and export a range to text file. Now the plan is to have different worksheets in this workbook. The user will change the drop down and select the sheet name which should run the particular before saving of the sheet and export the data in a text file . This is the working code for before saving which needs to be called based on drop down value Sub Worksheet_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim ExpRng As Range Dim myTab As String Open [login to view URL] & "\[login to view URL]" For Output As #1 Set ExpRng = Worksheets("UPLOAD").Range("A1:T299").CurrentRegion FirstCol = [login to view URL](1).Column LastCol = FirstCol + [login to view URL] - 1 FirstRow = [login to view URL](1).Row LastRow = FirstRow + [login to view URL] - 1 For r = FirstRow To LastRow Data = "" For c = FirstCol To LastCol If c = 1 Then myTab = "" Else myTab = vbTab ' data = [login to view URL](r, c).Value Data = Data & myTab & [login to view URL](r, c).Value Next c Print #1, Data Next r Close #1 I am using this code to call the before save but looks like code needs some edit Private Sub Worksheet_Change(ByVal Target As Range) If [login to view URL] = "$F$11" Then On Error GoTo bm_Safe_Exit [login to view URL] = False Select Case [login to view URL] Case "Rogers" Call Worksheet_BeforeSave Case "BMO" Call BMO Case Else 'Do Nothing End Select End If bm_Safe_Exit: [login to view URL] = True End Sub
项目 ID: 19604370

关于此项目

7提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, I have done similar task just couple of hours back in vbs. This can be completed in short span of time. Please message me the excel file you are using. I will customise it accordingly.
$35 USD 在0天之内
5.0 (5条评论)
4.3
4.3
7 freelancers are bidding on average $123 USD for this job
用户头像
HI, I am good at Excel and VBA. I have reviewed the code. Please share the Excel file to review and discuss it further. Looking forward to work on the project. -Chandra
$150 USD 在2天之内
5.0 (879条评论)
8.0
8.0
用户头像
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD 在5天之内
4.9 (335条评论)
8.0
8.0
用户头像
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$120 USD 在1天之内
4.9 (230条评论)
6.9
6.9
用户头像
Hi. I read your description carefully and am very interesting in your project. I have experience in Web Development(PHP, PYTHON, NODE.JS ANGLUAR, REACT ect ) more than five years. Your satisfaction with the project is my top priority! I can start right now and can help you. If you hire me, then I will try my best level for your project to run successfully. Looking forward to hearing from you. Thanks.
$140 USD 在7天之内
4.8 (11条评论)
4.2
4.2
用户头像
Excel & VBA expert with the required skills. Can help to build a solution as needed & deliver on the expected lines. Thanks!
$111 USD 在3天之内
5.0 (10条评论)
3.4
3.4
用户头像
Hi, We have been working on excel VBA since a very long time now and have worked on several of the projects. We would be happy to help you get the work done for you. Hoping to hear from you. Thank you.
$55 USD 在3天之内
5.0 (1条评论)
0.6
0.6

关于客户

CANADA的国旗
Canada
5.0
1
付款方式已验证
会员自1月 12, 2015起

客户认证

这个客户的其他工作

SAP BPC project Solution
$30-250 USD
谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。