Hi guys, Im trying to use an MID funtion on a string to create another string.
e.g. when I enter 11-05-10 in to a textbox, the date is entered as a string but I want to take the 05 and cast it as a differant string 'May_10' within a filepath.
Im getting a compile error that 'Month' is ambiguous.
Ive included some of my code below. any help would be apreciated.
Cheers
Please Login or Register to view this content.
The Ambiguous message means you're using something that already exists, or that you've used elsewhere in your own code for something else.
Try changing the Month variable to Mth, rename the sub itself.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Another suggestion:
Please Login or Register to view this content.
You can't use Month a sa Variable because it is "reserved" by Excel for the Month Function. maybe
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks