$$Excel-Macros$$ Compile Error Hidden Module: This Workbook

I wanted to used this form send by bank to do all the transactions. But in the beginning only it show some error. I can not do anything as the macro is password protected and moreover I do not know much about it. I just want to know why this problem arise and is the creator only can help me. I

Re: $$Excel-Macros$$ sharing of excel workbook

Try this: If ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.ExclusiveAccess End If Insert your code here If Not ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.saveas Act

Re: $$Excel-Macros$$ sharing of excel workbook

Try this: Enter code here... If ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.ExclusiveAccess End If YOUR CODE HERE Enter code here...If Not ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Ok, is attached files. To test, hold the 2 files in the same folder Regards, Basole. 2014-08-29 11:58 GMT-03:00 Eugene Bernard : > Basole, > > Thanks for your solution. > > Can you please send me the working example along with excel file with > sample data. > > I tried your code with my data,

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Basole, Thanks for your solution. Can you please send me the working example along with excel file with sample data. I tried your code with my data, and i am getting an error message. Regards Eugene On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote: > > Hi, > > See this example