Entering Formula in VB

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Entering Formula in VB

FAQ

Thread Tools

Display Modes

09-02-2018, 01:27 AM

p45cal

Windows 10 Entering Formula in VB

Office 2016

Expert

Join Date: Apr 2014

Posts: 963

MyFileName = CurrentWB.Path & "\QBOUploads\" & Range("A1").value & Format(Now(), "dd-mm-yyyy") & ".csv"

If that cell is on a sheet called, say, Sheet33, then:
MyFileName = CurrentWB.Path & "\QBOUploads\" & Sheets("Sheet33").Range("A1").value & Format(Now(), "dd-mm-yyyy") & ".csv"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
entering name in outlook does not autofill	Franksplace2	Word	0	03-08-2015 04:10 PM
entering duration in months	ketanco	Project	1	12-17-2014 01:09 PM
entering lump sum costs	ketanco	Project	1	12-24-2011 12:56 PM
Entering Contact details	GemmaD	Outlook	0	12-18-2008 06:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 PM.