Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 09-06-2018, 05:07 AM
p45cal's Avatar
p45cal p45cal is offline Entering Formula in VB Windows 10 Entering Formula in VB Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by Khwaja View Post
I tried checking the file name and nothing happens after I added ?MyFileName in the immediate window.
Confirm the following:

1. you "Put a break point (or a Stop instruction) directly after this line (or its equivalent)"
2. That you left the yellow highlighting as it was (didn't stop the debugger).
3. That after 'adding' ?MyFileName you pressed Enter on the keyboard.

If you still get nothing, there is a problem with assigning a value to MyFileName.


Another way to check for a realistic filename is to forget all of the above and add a code line just after the line:
MyFileName = CurrentWB.Path & "\QBOUploads\" & Sheets("Analysis").Range("I1").Value & Format(Now(), "dd-mm-yyyy") & ".csv"

being:
MsgBox MyFileName

This will cause a message box to appear which will allow you to check the filename. Clicking the OK button on the message box will allow the code to continue.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering Formula in VB 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 Formula in VB entering duration in months ketanco Project 1 12-17-2014 01:09 PM
Entering Formula in VB 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 02:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft