I am trying to write a VB that will use the data from an exsiting excel spreadsheet to create a new folder in a specific location (using an input prompt) and create a text file (using specific data on the spreadsheet and from the input prompt). Attached are an example of the spreadsheet and the desired output, and below is an attempt at a VB. Am I close to getting this to work? Thank you.
VB
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 08-19-2015 at 04:33 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
works great, what is the correct syntax for CDate + 1 so in the "please enter scan date" is 8-20-2015
Also when the folder is created currently it is 25512_42235 (the date in the input box is 8/19/2015, the text is bold is that). Thank you
("Please enter scan date", "Scan Date", Date + 1, Type:=2)
What date format do you want for the folder name; It cannot be m/d/yyyy ?
I had later edited the mydirectory to this which you may not have gotten.
MyDirectory = "N:\1_DATA\MicroArray\NexusData\" & MyBarCode & "_" & Format(CDate(MyScan), "m_d_yyyy") & "\"
Last edited by AlphaFrog; 08-19-2015 at 04:59 PM.
Perfect, works great..... thank you very much
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks