Search results for query: *

Is is possible to export an Excel file to XML so I can send it to the client and then have him open it on his Excel without losing the subtotals' outline? I have Excel 2003 and so far have not been able to accomplish this task. Maybe 2007 does the trick? Or am I just missing something here? (I'm...

Ok, at my workplace we have two third-party applications. We hired a temp to transfer data from app A to app B (its out of the question to get app B's provider to import data from app A directly from the database, so all we have is the two interfaces to work with and the data they show). Is...

Hi Guys Short story: Why when converting a Sub into a Function, execution of statements will no longer ocurr, even though vb runs through them? Long story: Is there a way to convert a Sub into a Function?. This Sub manipulates (insert, delete, etc) columns and its data, not only variables. I...

Hi everyone This is not the first time that I see Excel sorting a list of values in the wrong way. I'm sure it has to do with cell formatting or something like that cause if I copy an existing cell's value and paste it to the end of the list it will get sorted properly whereas if I directly...

Hi, hope someone can help: This is a VB6 program trying to get access to all the properties in a given MS Access Form's control (i.e. textbox.caption). I can connect a variable to the MS Access Object Collection (set accessapp = createobject(access.application)), but can't seem to find the way...