Search results for query: *

Hi guys, Just thought I would let people know I have identified the issue, the formatting has been lost as the spreadsheet is now being delivered in a CSV format that is losing all formatting and dealing with the data as a string.

Nope the workbook that is retrieved and then opened does not contain any independent code, all code is contained within the comparison spreadsheet.

TewksFileName = Application.GetOpenFilename("All Files (*.*), *.*", 1, "Load Tewkesbury file") If TewksFileName <> "" Then 'a file was selected so load it into a new workbook Application.Workbooks.Open TewksFileName strXLWorkBook_Location = TewksFileName Else Exit Sub End If The...

The code used to open the spreadsheet in question is below this is the only code that has been processed that references this particular spreadsheet before the breakpoint is encountered where I can then see the open spreadsheet and have identified that the cell format has changed. Set xlTewksWB...

Hi guys, Bit of a strange one here making me lose some hair, I have a macro in a spreadsheet that compares a list of 2 sets of files to check that all have been processed in both locations this now needs to be done only on files processed on a particular date that is in a column in each...

Hi guys, Just wondering if anyone has any ideas as to how I would dynamically loop through all forms within a project and then open each from a specific list of form names? All ideas greatly appreciated as I am new to VB.NET having more experience with VBA where to perform this I would have...

Hi guys, That appears to have found away round my problem thank you very much for your help. Have only just got a chance to put code in place and test but appears to sort all of the issues I was having.

Hi Mike, my code is as follows: Dim OpenFile As FileDialog 'Turn off screen flashing Application.ScreenUpdating = False 'ActiveWorkbook.ActiveSheet.Visible = False Set OpenFile = Application.FileDialog(msoFileDialogFilePicker) OpenFile.AllowMultiSelect =...

Hi I have developed a bit of macro code for excel that uses the filedialog object class. This code was developed on a machine with office XP and therefore the Office Object library 10.0 where this class is available. I have now transferred this code to the machine that is going to be using...

With a bit of further trial and error I have got the sourcesafe database to open, to do this I had to remove the username and password optional fields and this seems to have corrected the syntax problem. This will allow me to carry on working for now but has anyone got any ideas why the...

Hi guys, I am trying to create some macro code for outlook that will allow the system to open a sourcesafe database and search through the projects looking for files with a particular label. So far I am struggling with the early declaration bits of the code as I can not get the sourcesafe open...

Hi guys, thanks a lot for the help I now seem to have got everything working correctly. As well as using NextStoryRange that you suggest PHV, have a star. Also I had to make the code check the type of story that it was processing as the NextStoryRange is not available on a story of type main...

Hi guys, Thanks for the help so far, PHV the change to the execute line is now successfully highlighting all the text in the stories. My only issue now is that this has proven to me that word is not actually counting all stories in the document, despite the loop dealing with each story in the...

Hi Chris, Thanks for the help, can you give me any pointers on how to envoke the find next option? Thanks

Hi guys, I have got a piece of macro code in Word 2002 that uses the find function to search through a word document to locate a particular instance of a font with certain formatting. The code is going through each story correctly and is finding the font specified on the search form but only...

Hi chance, thanks for the help so far, has got me a stage further, had to make some slight modifications to the code you suggested which is as follows: Set myrange = oStory myrange.WholeStory With myrange.Find.... The code is now successfully highlighting the first sentence...

Hi guys, I have got a piece of macro code that uses the find function to search through a word document to locate a particular instance of a font with certain formatting. The code works fine on documents without textboxes but on any document that contains textboxes and multiple stories the...

Hi guys, Having a bit of trouble with some code I have been doing to allow the user to load up a word form that will then give them the option to enter a document file location. The code then checks through the document in the location entered and grabs all of the fonts that are used within...

Have found the problem. The item being returned was resolving as a taskrequestupdateitem rather than mail item. This meant I needed to use the created on date rather than the sent on date. many thanks for your help in correcting this.

I have now declared the DateSinceCompletion as a an integer variable and code has changed to the following: Dim myolapp As Outlook.Application Dim myNameSpace As NameSpace Dim myFolder As MAPIFolder Dim DateSinceCompletion As Integer Set myolapp = CreateObject("Outlook.Application") Set...