Search results for query: *

Hi, .xlsb is the file type that Excel 2007 creates when it wants to store macros available to all open sheets in excel. Excel will create this file if it does not exist the first time you go to create a macro. I have resolved my problem this morning by removing the old .xlsb file and...

Hi, Thanks for the responses, I have already checked the references as I thought the same thing. There is no indication to any missing references and it only happens when the macros are contained in the Personal.xlsb. If I move the macros to the Personal.xls they compile normally with no...

Hi, I need assitance to resolve the above issue, it happends when I am in the VBA Editior and attempt to compile my macro project (using Excel 2007). I can run my macro from excel ok but I am unable to compile it in the editor. This has been an ongoing issue and I have rebuilt my pc since...

Hi, Found the property, can stop it by using: Application.ScreenUpdating = False Regards.. Peter.

Hi, Thanks for that, it solves my problem. One other question though, is there anyway to stop the file temporarily being displayed as it loads. I am loading 4 files and as each loads it gets focus until the another file loads. I would actually like to load the pages in the background without...

Hi, Is there any way to switch of the problem dialog box in Excel 2003 when opening a workbook that is missing format files. To explain more I have several files that are downloaded from our intranet from web reports that are converted to Excel format, the issue is when they are downloaded...

Thanks.. that works fine now. From this I can manipulate the path to what I want.. Thanks once again. Peter

Thanks for the prompt responses. Neither of these work in my application, they look like they're for a web page. I am working on a script in an outlook form and want to open a text file that will be in the outlook application directory, I am assuming that if I can determine the current...

Hi, Can anyone please provide me with information on how to determine the current folder using VB Script. In VB you can use App.Path how is this done in VBScript, everything (example) I have seen you have to feed the FSO object information on the folder first. As I want to open a file and it...

Thanks for that, I was doing some investigation into using CHR(34) but couldn't find any reference on the internet for ANSI/ASCII codes. Anyway I tried both methods """" and CHR(34) and both worked perfectly. Thanks for all your assistance.. Regards.. Peter

Hi, I am trying to search for " in a string using the Instr function. When using the following syntax it returns an error stating that I neeed to have double quotes.. myCount = instr(mystring, """) Any help would be greatly appreciated