Recent content by moswitch

You both have answered my question, thanks again.

I have a private SelectionChange and Change sub routine in my VBA code which works well once initiated, the problem I have is that I am having a hard time triggering these events when clicking on the pull down arrow of a "Data Validation" List. Excel does not seem to recognize clicking a list...

Okay, thanks I'll try it.

If I'd like to access my data from an Access database instead of an Oracle database would I need to change the subject function drastically? Or will I just need to change the connection string?

Thanks again.

In case you were wondering why I was having a difficult time yesterday, it was because there was a "/" in the User Id portion of the connection string which I did not know to exclude. cnn.Open "Driver={Microsoft ODBC for Oracle};" & _ "Server=" & sServer & ";" & _...

WOW, WOW, IT WORKED! Thanks I've learned a lot.

Okay this is starting to look even better, I'm now return the values I wanted except for the column headers.

By auto fill I take it you mean in the cell itself? I looking to hard code this whole process.

Great it worked but it's only export one value instead of the whole column and header. By the way please delete my previous post.

Okay so I've finally got this thing connected to my database. Now how to I modify the Where statement sSQL = sSQL & "WHERE ROUTE_CODE = '" & Trim(sPN) & "'"? I would like to say Where ROUTE_CODE = 'CAL0002'. Also I'm trying to return the value of my query to sheet1 of my workbook by calling...

Thanks for the help, it seems I'm going to have to back track here because I don't know how to use the immediate window, I've never had too. Up until now I've been using VBA to manipulate and compute data in Excel as a result importing to Excel from an Oracle database is foreign to me...

and this is the EXACT code that you are using and that is not workgin for you??????? Common, quit wasting time! Aside from the x's this is the exact code I'm using. It's kinda fustrating know because when I use the Excel wizard to connect to this server with my user name and password it works...

Per your request. Function GetPastDueRQ(sPN As String, Optional sNG As String = "") As Integer 'SkipVought/2007 Sep 06/ '-------------------------------------------------- ' Access: DWPROD.FRH_MRP.READ '-------------------------------------------------- ':this function returns Past Due...

Still getting the forlloing. Run-time '2147217843 (80040e4d)': Automation error I will continue in my attempt to make this work.