wbname

Hey all, I have a workbook that after updating needs to be saved without any linked formulas and into a monthly file. Now i am in Portugal what means that when formatting text for my month it uses the Portuguese language in stead of English. Using formulas there is the [$-409] code i can use...

guys in newbie about macro, here's the problem i have 2 workbook named it A dan B i have add macro (module) on workbook A to open workbook B but when i click the macro workbook B opened as READ ONLY, i have to close both workbook and reopen workbook B if i wanna edit and save it. this is the...

Hello hello! My company has a bad habit of recycling spreadsheets instead of going back to source templates. We are running into a problem of having thousands (yes, thousands. don't ask.) of hidden named ranges that reference (1) nothing at all, producing a "#REF!" error, (2) a website link...

I have sort of painted myself into a corner with creating a pretty in-depth vba project and my "hack" is to hide the workbook behind the userform. I know, I know, I should have used VB Studio since I'm trying to emulate a "standalone" application. Regardless, what I have I can insert into each...

In the following code, I am getting error when saving the file...... Please help Sub Del_Column() Dim wb As Workbook Dim wbName As String wbName = "Book" For Each wb In Application.Workbooks If wb.Name Like wbName & "*" Then Debug.Print wb.Name...