Recent content by math20

Thanks again.

Thanks I will give it a try.

Just one row for each group and I have 6 groups. I am thinking of using this code for each group to do the same.

Hi SkipVought, Thank you for your prompt reply. Let me provide a little bit more details for using macro and VBA. This is one of daily task as I run the data in access nad paste it in excel it has values for multiple groups and basically macro is useed to repeat process. I want it to lookup a...

Hi I am trying to write in a macro a vlookup condition. Basically i would like it to lookup a date match and paste a value. This is what I have now: Sheets("INV").Select Range("A4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False...

Hi lameid, It worked. Thank you so much.You are great. Have a Nice day!

Hi, I am trying to alter column type by using the following code: DoCmd.RunSQL "ALTER TABLE DATA-SP-09 COLUMN AIR MILES Collector #/ Numéro d’adhérent AIR MILES TEXT" It is giving me a syntax error, I believe it is because of the table name and column name which I can not modify is there any...

Hi PHV, Yeah, It Worked. Oh Thank you Thank you so much. Have a Great day. Thanks.

Hi PHV, No problem. When you say your XLapp you are refering to Book1, so that it will be: Book1.ActiveWorkbook.SaveAs Is this correct? Thanks.

Hi PHV, Thank you. It worked the first time but when I run the process second time for second transit it gives me the following error: Run Time Error 91 Object variable or with block variable npt set. This is where I get the error: ActiveWorkbook.SaveAs FileName:= _ "J:\cag\Network...

Hi Again, I ran into a problem while saving my file. Instead saving the new workbook (Book1) it is saving my excel template. I do not want to save my template I only want to save the new workbook that is created from this template. Here is my code: 'Copy and move Excel Sheet to new workbook...

Hi Roy, Thank you. It worked fantastic. Yes actually there is a comma in the file name, I will remove it and see if it makes any difference. I inherited this folder from my colleague who used to work in this position. Once again than you so much.

Hi, I am trying to save an excel file with access vb script code. The code I am using works the first time around but when I run it again it gives me an error: Run Time Error 91 Object variable or with block variable npt set. Here is the code: Set r1 = wbk.Sheets("CTAS Total...

Sorry yes. It is specified as MDY.

Preferably MDY as long as it is consistent and does not change. Thanks.