Search results for query: *

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...

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...

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...

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]...

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'...