Search results

Ok i am able to get this to work heres my code. my issue is, i cant get the file to stay open, it goes right into a close, and which i see in the code, what can i use to get it to stay open? if i ake out the wb.close, and xlapp.quit it wont do anything. Sub OpenPwdProtFile() Dim xlApp...

nevermind i found it, but its grayed out. this is in the VBA screen correct

im using access 07, im not seeing a tools menu?

when i run this code i get an error on the 2nd line on the DIM xlApp as Excel.Application Sub OpenPwdProtFile()Dim xlApp As Excel.ApplicationDim wb As Excel.WorkbookSet xlApp = New Excel.ApplicationSet wb = xlApp.Workbooks.Open("FileName", , , , "PassWord")wb.ClosexlApp.QuitSet xlApp =...

do you have any sample code for what im trying to do? i cant find anything similar for what im trying to do, specially to get data from the password protected file.

Ok, geting a little farther. where do i put this code in access, and how do i run it?

I posted this in the Macro Board and havent had any luck. heres my issue: I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non...

I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non password protected to work fine.

I have a scatter chart that is working the way i want, but when i want to add an average line to the chart, it runs, but my data changes. any ideas how i can do this? on my data tab on chart properties, i have an AVERAGE in the Values section. On the Y: axis expression i have...

I was wondering if anyone had any good ideas how to do this? I would want to use a macro in my access DB to get some data from a excel file that is password protected. Thanks

I am trying to convert a date field in sql to a DD:MM format example right now its 01-16-2007 and i want to convert it to 01-16 and forget the year at the end any help? again this is for SQL Query im working on in SSMS 2005

do you have a solution for sql?

I need it for sql server, i belive what you laid out was for access?

I have a field in my sql db that is called trucklog. This field has truck number and seal number seperated by a - sign. so example for a field is 123-123546 55555-44114 there is no definate number of characters before and after the - sign. what i want to do in my query is make these 2...

I go through the tutorials, and put in my data, and no matter what ways i do this, my chart always come sout wiht East, west, north, and data is on 4 quarters. That is in the design view, when i go to preview report it shows nothing. I dont get why that data would show up, no where in my...

this seems to work for older versions of access, but i dont beleive the new versions(07) works that way.

I am looking to add a small pie chart to my report. I have 5 fields that i want to display. I can not get it to work. when i go thru the wizzard and when it displays its just a blank chart. im using access 2007, and i want this chart on a Report. any info would be great.

I am trying to add text to a field in my report, here is my example on what im trying to do. ="This benefit statement is prepared for:" & [Fullname] when i have that in a textbox i am just getting #Error

I know but how do i use that with what im trying to convert? thats where im getting stuck? im not sure how to use what your giving me with my statement?

im having hard time with the synntax for what im looking for. This is what i want to convert to a date Cast(p_month as varchar) + cast(p_day as varchar) + cast(p_year as varchar) so would i have to use Convert front, and then something with formatting at the end?