$$Excel-Macros$$ Use xlsm as backend for html page

Hi guys, I have a xlsm file in which it has file name, drawing folder name, revision and date updated. I was wondering whether could I use xlsm file as backend while using html page as front end. I would like to create a html page in which it has search, download and upload function where the d

$$Excel-Macros$$ control the macro commands in excel vba

Hi guys, I have 7 subs in my module. I would like to control that if the datelastmodified of excel vba is same as datelastmodified of the master file, then don't run the 7 subs. If the datelastmodified of both are not same, then run all the subs. What should I put in 'ThisWorkbook' and how do

$$Excel-Macros$$ PasteSpecial method of Range class failed error

Hi all, I'm getting error for my code. Can anyone help me analyze where is the error? Thanks in advance. Sub getnew() Dim Sheet1 As Worksheet Dim Sheet3 As Worksheet Dim lastrow As Long Dim i As Long Dim erow As Long Application.ScreenUpdating = False Application.DisplayStatusBar = False Activ

$$Excel-Macros$$ Re: overflow error issue

Hi Mandeep, I don't know how to use VLookUp function for my situation. I was wondering whether would you mind showing me how to use VLookUp function according to my code? Cheers On Monday, 22 February 2016 20:57:58 UTC+8, Mandeep baluja wrote: > > Will you please let me know why you're not u

Re: $$Excel-Macros$$ copy paste issue from one sheet to another

Hi Sky, Thank you very much for your help. Cheers On Monday, 22 February 2016 02:46:46 UTC+8, sk.yadav7186 wrote: > > check it...maybe this is helpful...because i m also learner :-) > > On Fri, Feb 19, 2016 at 11:43 AM, Kat > > wrote: > >> Hi guys, >> >>

$$Excel-Macros$$ Re: overflow error issue

Hi Mandeep, I have defined the variable to long for the whole program and it takes very long time for running. Also, for the code below, if I use integer, I will get overflow error. If I change variable to long, I will get application-defined or object-defined error. Can you help me on this is

$$Excel-Macros$$ overflow error issue

Hi guys, I've issue running the code below. Is there anyone can help? Thanks in advance. Sub dnew() Dim i As Integer Dim lrow As Integer lrow = Sheets("to").Range("C" & Rows.Count).End(xlUp).Row For i = 2 To lrow If Sheets("to").Cells(i, 2).Value = "up" Th

$$Excel-Macros$$ copy paste issue from one sheet to another

Hi guys, I would like to copy paste entire row from king sheet to queen sheet if the cells in range "B2:B" has the value of "update" in king sheet. However, I have copy area and paste area not same size error. May I know how can I solve this? Can anyone help? Thanks in advance. Cheers -- Ar

Re: $$Excel-Macros$$ to change cell value in Column A daily

; > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Wedn

$$Excel-Macros$$ to change cell value in Column A daily

Hi all, I have an xlsm sheet and would like to change the cell content in Column A at 9am everyday. If cell value in column A equals to "Yes" today, then it needs to be changed to "No" automatically at 9am tomorrow without opening the file manually. May I know how can I get this done? Please s

$$Excel-Macros$$ To insert new row below when the data is unmatched

Hi all, I'm trying to insert a new row below the matched data in trial.xlsm and copy the unmatched data and write 'New' in column B when the data is found unmatched. However, I can't achieve this. I've attached the pp.xlsx file in which the Sheet2 in pp.xlsx is the result that I want to achiev

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

> Sheets("sheet2").Cells(i, j).Value = Sheets("sheet1").Cells(i, > j).Value > > Next j > Next i > > End Sub > > -r.Karunanithi. > > > -- > *From:* Kat > > *To:* MS EXCEL AND V

$$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

Hi all, I have a workbook in which the row is fixed (eg. from column A to C) and the user will keep adding new column (eg. from adding data in Column D to E first time, second time adding data in column F to H) in Sheet 1. Everytime when new column is added in Sheet1, I want it to be automatica

Re: $$Excel-Macros$$ compare columns through for loop

It works perfect. Thanks a lot for your help. On Wednesday, 3 February 2016 15:58:48 UTC+8, era_kar wrote: > > Hi, > I enclose which may solve ur request. > > > > ------ > *From:* Kat > > *To:* MS EXCEL AND VBA MACROS > > *Sent:*

$$Excel-Macros$$ compare columns through for loop

Hi all, I would like to compare columns in two workbooks. If data from column D in fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If they are not matched, then data from column A to C in fortest1.xlsx needs to be copied and pasted to column C to E in tested.xlsm. Please

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > -

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

Hi Paul, If I run the command based on your comment that I use ThisWorkbook.Activate > MaxRow = ActiveCell.SpecialCells(xlLastCell).Row > MaxCol = ActiveCell.SpecialCells(xlLastCell).Column > For iRow = 1 To MaxRow > For iCol = 1 To MaxCol > Then the command below comes up with s

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

ot; & > eRow).Value = wbkA.Sheets("Sheet1").Range("A" & iRow & ":C" & iRow).Value > Exit For > End If > Next > Next > wbkA.Close savechanges:=False > End Sub > *Paul* > --

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

workbook. > > If you can send me a sample data file, I'd be glad to put something > together for you. > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the time

$$Excel-Macros$$ database copy paste issue from one workbook to another workbook

Hi guys, I want to copy paste database from one Workbook A to Workbook B. When new row data is added in Workbook A, the excel vba code will compare whether the data is exist in Workbook B. If no, new row data needs to be copied and pasted automatically to last existing row in Workbook B. I've h

$$Excel-Macros$$ Re: add date instantly when there is update in worksheet

Hi Mandeep, I've already got the database in the worksheet1. User can add data in row or column after the available data on current worksheet. When user add data in either row or column, I want it to automatically write the word 'new' in A column and compare worksheet1 with worksheet2 and add

$$Excel-Macros$$ add date instantly when there is update in worksheet

Hi all, I was wondering how to have the date being added automatically when there is new update in the worksheet either by column or by row. Cheers -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Assist needed

Hi all, I would like to copy master list from server to a worksheet name 'today'. When server update new row it needs to be appeared in the 'today' worksheet at the last row and shows 'new' in first column. User will update from the 'today' worksheet and 'new' needs to be shown in first column

$$Excel-Macros$$ new added file in folder to the current workbook

Hi all, I've make a code which listed the folder name and file name with the details. I was wondering how can I make the file name and its details appear in the current workbook automatically when there are new files and folders added in the folder. Thanks in advanced. -- Are you =EXP(E:RT)

$$Excel-Macros$$ update modified details in excel automatically

Hi all, I've created a vba code for extracting files from folder with its details. I would like to know how could I make the excel update the content automatically by itself if there is any changes in the folder such as a file is deleted, new file is updated, file is being modified etc. Than

$$Excel-Macros$$ open file from folder

Hi all, I was wondering whether could you guys help me figure out how do I open file from folder using vb code. My code doesn't seem working. Please see attached for the vb code and file location. Thanks in advance. Cheers -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ vba code help with revision times

Hi all, I need help with my revision time issue. The rule for the revision time code is after 8 character, if it's a number then it will show the number. Else, it will show error. However, one of the revision time format is REVI9_gif. It shows at EVI_gif in the cell instead of error. Can anyon

$$Excel-Macros$$ vba code for getting the date

Hi all, I'm trying to create vba code with corresponding date modified according to the file. Can anyone help me with the code? I would like to get just the date showed, not the time. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I a

Re: $$Excel-Macros$$ vba code for listing folder name and file name

ep Baluja wrote: > > Hey Kat, > > I am sorry but i didn't get the logic of this code which is totally > different from your above query,Things which i understood its just checking > whether file_name following the criteria or not, > > if 9th letter of the file name is equ

$$Excel-Macros$$ how to handle large data with vba code

Hi all, I was wondering what can I write for the code with large data in vba because the program always crash when I try to execute. The data I'm trying to deal with is more than 5GB. Thanks in advanced. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,D

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Mandeep, The revision time in my snapshot is the one I use writing. The real code isn't showing. It's not showing the folder name and file name as well. In terms of revision times, it's fine if the changes are done in certain interval. On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Abhi, Unfortunately, the code doesn't apply for my case. On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote: > > Please see if this solves your purpose - > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 > > On Mon, Jan 11, 2016 at 11:55 AM, Kat &

$$Excel-Macros$$ vba code for listing folder name and file name

Hi all, I want to create a xlsm file which list out the folder name, file name and revision times with its corresponding date modified. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I achieve this? Thanks in advanced. Cheers --

$$Excel-Macros$$ Re: vba code help for the open file location

Hi Baluja, It works well. Thanks a lot for your help. Appreciate that. Cheers On Friday, 8 January 2016 13:24:17 UTC+8, Mandeep Baluja wrote: > > Check this out !! > > REgards, > Mandeep baluja > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N

$$Excel-Macros$$ vba code help for the open file location

Hi all, I was wondering how could I make the open folder button for file name column instead of file location path column? For instance, from the picture below, when I point my cursor to C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, it will open the file 2F6KB026

$$Excel-Macros$$ vba code for integrating particular information from different workbook to one workbook

Hi all, I need help for vba code for creating a master file. I would like to create a master file which needs to be read only in Excel format. The information for the master fil

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

Jun 6, 3:22 pm, ashish koul wrote: > Sub test() > For i = 1 To Sheets.Count > Sheets(i).Select > > ' paste ur code here > > Next i > > End Sub > > > > > > On Mon, Jun 6, 2011 at 2:12 PM, Kat wrote: > > Hi all, > > > I have a large spre

$$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

Hi all, I have a large spreadsheet, ~200 sheets. For each of these, I wish to plot a series where the x values are D3:D103 and the y values are E3:E103, and the series name is the same as that of the sheet, all on the same chart. So far I have ActiveChart.SeriesCollection.NewSeries Acti