Search results

I have done all the necessary changes but still not publishing the crude, maybe the original 'publishcrude' function needs to be amended, this is held in referenced DLL file. As shown below Public Function PublishCrude(strReference As String, strShareID As String, strDescription As String) As...

Hi there, Ok this is my last day at doing this... i think i might know what the problem is.. I feel the 'publishcrude' function is working... but i think the problem lies with the data that it is submitting. The "strDBGUID = ActiveSheet.Cells(7, 3)" is displaying a unique GUID key that is...

It does begin submitting but when i check the database it doesnt contain the information i just submitted. Could be a problem on the database side not picking up information. How do i step through the code? sorry im still a newbie to excel.. alot of this code was originally created by someone...

i have one last query i promise its the last!! i've created a macro button with the following code. Basically it takes information from the worksheet and submits it to an application database installed on my pc. I am having problems with the 'if' statements, i want the button to perform both...

its working!!!! your a life saver.. thank you ever so much for taking the time out to assist me.. much appreciated! you are the vba guru!! :D

Hi there once again, I am running windows in english language. Could it be something to do with the fact that it is referencing blank data? as sometimes the data in 'ws.range("b2:b2005")' is filled and other times that whole column is blank. The same goes for the a2:a2005 range. Thank you...

sorry line should be as below ActiveChart.SeriesCollection(Counter).Values = ws.Range("b2:b2005") still i get the same error.

Hi there, Thank you for your prompt response, really appreciate it. I tried your suggestions but i still get the same error message and for the same line: ActiveChart.SeriesCollection(Counter).Values = "=ws.Rangeb2:b2005" Please let me know of any other amendments i could make? Thank you

Dear KeirnUS i am in need of some urgent assistance. Getting the same error as above "1004 Unable to set the Values property of the Series class" If you could kindly help i would be more than grateful.. Basically i'm running a spreadsheet that has a 'plot chart' macro, which then pulls through...