Microsoft Office Forums - View Single Post - Entering Formula in VB

Thread: Entering Formula in VB

View Single Post

Old

09-02-2018, 06:19 PM

Khwaja

Khwaja is offline

Khwaja uses Windows 10

Windows 10 Khwaja uses Office 2016

Khwaja uses Office 2016

Office 2016

Novice

The original poster

Join Date: Aug 2018

Posts: 12

Khwaja is on a distinguished road

Default

Thanks a lot. I am using the following code in the light of changes you suggested. But I am getting runtime error 9. Subscript out of range.

MyFileName = CurrentWB.Path & "\QBOUploads\" & Sheets("Analysis").Range("I1").Value & Format(Now(), "dd-mm-yyyy") & ".csv"

Reply With Quote