Hi friends,
I have an excel file named Budget.
After running following macro, there is a "Budget" in the A1 cell.
Then I change my folder settings that, yes show file extension name.
Please Login or Register to view this content.
After running following macro, there is a "Budget.xlsm" in the A1 cell.
I dont want to see Budget.xlsm in the A1 cell.Please Login or Register to view this content.
I want to see Budget in the A1 cell.
Any advice ?
Thanks in advance.
Last edited by HerryMarkowitz; 12-13-2013 at 09:27 AM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
UsePlease Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
You may use:
Please Login or Register to view this content.
Code sent by OllyXLS is not working.
Code sent by Izandol is working.
Thank both of you.
You did replace just the relevant section of your macro, didn't you?Originally Posted by HerryMarkowitz
As that should work...Please Login or Register to view this content.
Yes I run code and no result...
Last edited by HerryMarkowitz; 12-15-2013 at 02:25 PM.
My apologies - I was wrong.
The workbook I tested it on just happened to have an identical filename and document title...Good old SharePoint.
Olly
Title won't work with a workbook that hasn't been saved and it won't necessarily return the workbook name, you can set the title of a workbook to whatever you want.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks