double quotes

I'm running crazy on this, why doesn't example two work? Dim oShell As Object Set oShell = CreateObject("Wscript.Shell") oShell.Run ("https://www.google.com/search?q=yeah") Dim oShell As Object stringit = "yeah" Set oShell = CreateObject("Wscript.Shell") oShell.Run "(" & Chr(34) &...

Hi All, My colleague and I have created some VBA code to transform a standard report into semi-colon-delimited data, all within column A, which is then imported into our financial systems (SAP). SAP only handles numerical values in European format, therefore, as part of the transformation, we...

Hi all, Need to pick someone else's brain on this. The problem is very simple: I have a macro which is extracting information from a csv report and populating a spreadsheet. The problem I have is that when it does so the text populated on the cells are all double quoted: "14/07/2015 9:51:37"...

I have been fighting this for awhile and am at a sticking point. I have a workbook that contains many sheets, and I need to be able to: generate a CSV file for each sheet name each .csv file based on the sheet name. some fields contain a "," and I would like to put double quotes around that...

Hi everyone, A bit of a challenge with this one... The last couple of hours searching have not resulted in a working solution:confused:, so I turn to you. I have 253 cells in column AO that contain text, containing 1 to 6 chunks of text within "double quotes". Here is an example. This is...

I am trying to conditional format a section of a row based on the value of the a cell. Specifically I am trying to grey out a section of a row (A#:AT#) when the QTY cell (B#) is 0. I am been trying to create a formule that will test for this condition so that I could make a single conditional...