Hi,
No one else seen this problem?? I have been using Firefox to get around it at the moment.

Regards..
Peter

Hi, Some time back I posted an issue with trying to obtain IE8 tab info. This was solved and had been working okay until recently when I installed Windows 7, since this time the tab solution fails as the code tabs past the required tab without stopping and processing subsequent code. I have posted m...

Marcus,
Thanks for the inforation, I haven't had a chance to implement as yet as I have had other problems that have preculded me from using IE8.

Thanks for the information.

Regards..
Peter.

Hi, I have been using Avant web browser and my script has functioned okay when trying to switch tabs from one window in the browser to another. Tonight I setup Internet explorer 8 and tried running my script against it to find different tabs in the ie8 browser window. For instance I have been using ...

Hi, Thanks for the help, I have produced the following script which has resolved my problem. Const xlTextFormat = 2 Set objExcel = CreateObject("Excel.Application") Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.GetFile("C:\Users\Pztydr\Documents\CAMs\Rpt-PClosed.csv") ...

Hi,

Hi,
Thanks for the update, I had a look at the link and it could be useful. I was going to revisit my problem later today hopefully so I'll update this post once i've had a chance to do that.

Thanks..

Regards..
Peter

Marcus,
Thanks.. I'll have a look and see if I can convert my Excel macro.

Regards..
Peter

Marcus, I am using Macro Scheduler to open the the file using Excel then save it as an xls file. This is where the issue is appearing as Excel is converting the date columns. VBSTART Dim xlApp Dim xlBook 'Opens the Excel file in Excel Sub OpenCSVFile(filename) Set xlApp = CreateObject("Excel.Applica...

Hi, I have come accross an issue which I am not sure how to resolve regarding dates in excel. I have a csv file that I am using MacroScheduler to open then save as an excel file, this part works fine but I have noticed the following issue. If I open the csv file using excel the date remains as dd/mm...

Hi,
Have resolved my problem, the issue was the definition of the file format to save in.

I had to use "-4143"

Regards..
Peter.

Hi,
Noticed a double c: in the save filename and removed it, still getting the error though..

Regards..
Peter

Hi, I am getting the above error when trying to open a csv file in Excel and then saving the file as an Excel file (line 14 column 4). Can anyone please advise a fix to resolve this, I have included my macro below.. VBSTART Dim xlApp Dim xlBook 'Opens the Excel file in Excel Sub OpenCSVFile(filename...

Marcus,
Where can I send the screen shots to is there an email eddress?? as it looks like i cannot upload them from here..

Regards...
Peter

Marcus, Thanks for the code, I have tried several diffferent ways today to get the macro to respond to the window when it becomes active and nothing seems to work. Here's a segment of my code.. WaitWindowOpen>Load Query wait>1 Send Character/Text>Tasks Closed1.vql Press Enter wait>5 SetFocus>CAMS - ...