Recent content by bodmin

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