Search results for query: *

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.

Hi Lameid, As per your advice here are the three columns. 10/21/2008 04:07 PM Boucher, Nancy 12/16/2008 05:32 PM Thank you.

Hi lameid, Yes it does say Date/Time for that field unless I should be specifying it in another place. Should it be indexed as Yes (duplicate OK)? Thanks.

Hi lameid, Thank you. The table with date filed comes out blank. This happens only for the date field with time, I have other field that shows date they are without time and are imported correctly. The ones with date and time field are imported as blank field. Any suggestion how to fix it...

Hi, I am importing data from excel to access table one of the field is in date/time format. Within excel the date type is consistent with mm/mm/yyyy hh:mm format. When I import this data into excel using the get exteranl data method from access. This data field changes the format: all dates...

Hi GhostWolf, No I have not tried that. I will give that a try. Thanks. Have a Great Weekend! :)