Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
File not found VBA6.DLL on compile VBAProject
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...- annandap
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Missing Files when opening Workbook from VBA
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...- annandap
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Determine Current Folder ????
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... -
Searching for " using Instr
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
