index > Visual Basic for Applications (VBA) > Automation error : Logon failure: unknown user name or bad passwo...

Automation error : Logon failure: unknown user name or bad passwo...


Good Day to all you VB guys !

I am currently dealing with VB Macros meant to perform automated functions on MS Excel file/report. MEANING - the code/appcn i am dealing with is V B A appcn not VB6 appcn - its the VB meant for Macros !!

I am getting this error from time to time in various excel reports' execution. Sort of confused about how to resolve this problem right at its root !

Error Msg written into the Error Log :-

"006-09-08 10:38:53#,"","Batches Completed by FIMP"

,"Automation error Logon failure: unknown user name or bad password. ""

I am sure there are many of you here who would have dealt with Macros earlier !!!

Can any1 help me ?

Thanks in Advance

DotNetDoctor

These forums are for VB.NET, not VBA.

Also, there's no way to say what the problem is without knowing what the code looks like. If the macro access another server resource such as a fileshare or database, ensure the current user has permission to that resource.

You should probably go to the Office development website and see if you can find some help there.




Reed Kimble - http://spaces.msn.com/reedkimble
rkimble
Moved to VBA forum.
nobugz
reply 3

You can use google to search for other answers

 

More Articles

• excel vba
• Using visual basic and DDE ( dynamic Data exhcange) to syncronize...
• Peak fitting program in VBA?
• Using a single variable to get a combined worksheet and range - i...
• Unpredictable (as yet) problem with DateAdd
• VBA Mail Merge Question
• Current open MS Project saved as XML element
• start Access Query Designer/Builder from VBA
• VBA in EXCEL - Connect to SQL Server
• Pass parameter to Form
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

• Security Warning
• combine 3 combo boxes values into one st
• Text wraping on edit box of dialogsheet
• Changing the color of a task using macros
• How to create a DLL in VB.net for MS Acc
• custom toolbar error
• Problem about the "Find" funct
• Urgent help regarding line chart thru Ex
• Application Hosted Scripting IDE in .NET
• Writing To Text File Without Quotes
• is it possible to get windows Services w
• transaction processing in an Access app?
• Runtime err 1004 when attempting to set
• Reading From excel spreadsheet cell
• can we do this in vba

Hot Articles

• how can i set password to the design vie
• Matrix syntax
• Assign Minimum and maximum values for a
• Summing on varying number of rows in Exc
• Access "ldb"
• Word 2003 Macros
• ADO Recordsets
• Autofilter criteria's
• How to declare activeX object in source
• Compiling Excel VBA-code?
• Office Word Macro - create file to a spe
• showing userforms in html format
• Modify .PRJ File
• VBA Out Too?
• VBA: read/write chinese words

Recommend Articles

• how to add CheckBox?
• Bound form
• Send Email via outlook through excel
• Special action required for one item in
• Office 97 / Windows 2000 Compatability
• Dialogsheets vs Userforms
• Activate a workbook based on a value in
• autocomplete
• Avoid message boxes during macro?
• Excel DDE Server
• create command button that holds a proce
• Web Page Components
• Loading Select data through the linked t
• Problem about the "Find" funct
• VBA Form in MS Word template to populate