Search results for query: *

I could replace the powerpoint bit with that (and yours is a better way than I was doing it, and I will change it to that), but it's the excel asking for me to click 'continue' and 'ok' that I am having problems as I want to be able to just leave it run with no intervention from me

I am trying to wrtie a Macro to update all the links in a PowerPoint (2003) file to excle sheets where there are various messages regarding updating links which need to have 'continue' or 'Ok' clicked on due to issues regarding the source files not being on drives I have access to. I need to...

Thanks, That all looks to have got it working, I have port the marco, but out of interest why was it worth doing this? Thanks Josh

Thanks for the help I have managed to get the second bit in no problem, but the first bit "Set xlbook = xlapp.Workbooks.Open Filename:=(ExcelLocation & ExcelName), UpdateLinks:=1" is throwing me back the error "Complie Error: Expected: list separator or )" Not sure why as it looks correct...

Hi, I am having problems with Access opening an excel file and running a macro, it seems to open excel in a non visible format but I have no idea why?, I am sure I am missing something simple, and would appreciate it if some one could point me in the right direction. Thanks Josh This is the...

try =SUMIF(C2:C6,"Y",B2:B6) for the example, then just alter the 2 ranges to suit your data (remember they need to cover the same number of rows)

Thanks for your help I will look into the date picker you sugguested, as I normally want to return todays date, it's only in exceptional cases I wish to change it.

I can't see any function for the format in the properties window for the object, or should I be looking to use format () in the code somewhere? Thanks Josh

Hi, I am trying to change the format of the date in a text box within a user defined form in excel, currently it is showing as mm/dd/yyyy, I need it to show as dd/mm/yy. If anyone could point me in the right direction it would be helpful as I can't see where the settings for this are held...

I have had a look at it this morning and was struggling to get it working so I ended up going down the route of creating a text field formated as required (eg >1 Fee& "%") in the query, this has worked fine apart from the colour which is not a problem as this will always be printed in black and...

ah, I understand what you mean now, I will have a look at that monday. Thanks

how would I change the properties on the fly as there are going to be all the diffenerent formats used each time the report is ran, and the only way I know of to change it on the fly would be to code it do one format (which could change based on some parameters) per run. Sorry if this is a...

Hi, I am trying to return a value which will be formated as a #,##0.0% above 0 and below 1, £#,##0 above 1, "No Fee" at 0, [RED](#,##0.0%) below 0 and above -1, and [RED](#,##0.0%) below 0 and below -1 I have tried looking everywhere and tried using =iif([Fee]...

I have tried it this morning and it looks to be working perfectly. Thanks again Josh

Thanks, I will give that a go Monday when I am back in work. I knew I jmust be missing something Thanks Josh

Hi, I wondered if anyone could help me I am trying to copy some sheets into a new workbook, and then paste them as values (basically leaving me with the originals as they where, and the new copies as just values in a new book) I keep getting runtime error '-2147217848 (80010108)' Method 'Value'...