Tera Term Macro Tutorial
Tera Term (alternatively TeraTerm) is an open-source, free, software implemented, terminal emulator (communications) program. It emulates different types of computer terminals, from DEC VT100 to DEC VT382. It supports telnet, SSH 1 & 2 and serial port connections. It also has a built-in macro scripting language (supporting Oniguruma regular expressions) and a few other useful plugins. Configuring Serial Terminal Emulation Programs 7. Tera Term Pro. Configuring Tera Term Pro. After installing Tera Term Pro, the Windows click. All Programs Tera Term Pro. And click theTera Term Pro program (Figure 7). This displays the Tera Term Pro screen. Figure 7: Invoking Tera Term Pro 2.
Tera Term Macro File
I have a usb serial port which connected to another computer with tera-term on it. Is there anyway from vba to talk through this serial port using a macro? Thanks in advance, Joe Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar TopicsI am trying to calculate the average Talk Time into Minutes and Seconds. Every time I have tried, I get the wrong average. For example, if I have a total of 53 calls and the total talk time is 4:19:05, what would the average talk per call be? I tried doing everything in seconds (this would give me a total of 15545 seconds) but the total I was getting is 4:89. What would the formula be to get the correct average time?
Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. I've written a macro that is relatively simple. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. Nothing incredibly fancy but it works fine on my computer. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It is the same Operating system and the same version of Excel. I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware. I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out! Thanks very much for your time.
From limited experience I know that excel calculates dates via serial numbers. I have formulas to add a number of days to a cell containing an entered date and display the resulting new date (ie. 03/01/2011 (c34)+11 = 03/12/2011) I am seeking to leave resulting formula cell blank until a date is entered in the input cell. Currently when the input cell is empty the formula cell obviously displays 1/11/1900 using the above example. What conditional format would achieve leaving the formula cell blank until date data in entered into the source cell? Hopefully a simpler question for your experience level than mine.
I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg. What could be wrong? Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum ! I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals. While scanning the photographs, I have saved them serially i.e. 1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. Problem : I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed : Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards ::: Jack I have a problem sometimes. I will click on a cell to add information. The cell turns blue and then wherever I move, it highlights those to. No matter where I go on the page. If I Alt-Tab and work in another program on my computer, that excel page keeps highlighting wherever I move even in those other programs (I know this sounds confusing). When I return to excel thousands and thousands of cells are blue. The biggest problem is that the highlighting won't turn off, no matter what. I can't select anything from the tool bars, do any work on the sheet or close the program. I can close it only with the task manager but when I open it again, the cursor is still stuck in the highlighting mode and won't perform any other functions. Do you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. Is there some shortcut to turn off this highlight feature other than restarting my computer. Which is the only current way I can get rid of it. Thanks for any advice, Hello everyone!!!! Here is my situation. I have been trying to learn macros but have not made one yet. Need your help. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc.. *COUGH COUGH* ya ok.. LMAO We have a 'shared' work book we all work in. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a 'refreshed' copy of the workbook before they start writing in cells that already contain information. How to I create a macro button at the top of the page that is literally a SAVE button. instead of them saving by going to File - Save or cntrl+s ??? I just thought that MAYBE having a big button in their face will remind them. Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins??? I don't mean a save.. but a refresh so the screen actually updates in front of you. (although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) Thanks so much!!!!! Muchly appriciated. I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. Excel will not let me copy and paste a formula and will only paste the value into to workbook. For instance, if I make a very simple spreadsheet such as: A1 type in 10, A2 type in =A1 (calculated A2 to be 10) B1 type in 5 And then click the copy on B1, and then click paste special on cell B2, the only options it gives me are text and unicode text and so no matter how I paste, cell b2 will always be populated with a value of 5. I cannot imagine a simpler copy and paste and no matter what I do I can't make this work. All cells are formatted as general. It seems that all copy and pasting of formulas in my excel has been disabled. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem. Any help? If I am using sendmail in a simple macro, is there any code I can add to actually open Outlook? Some users of the macro are pressing the macro button and do not have Outlook open so the email isn't sent until they eventually open Outlook! Thanks in advance Dear All, I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout. Please provide me with any Formulas as micros are disable in my Computer... Waiting for an early reply.... I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse. I am also not able to click on the tool bars at all. I have to actually Ctrl-Alt_del to get out of the program. I'm sure this is something simple, but I don't know that much about this program. Any help would be greatly appreciated.
I am trying to get my macro to do this on open. Check if a1 is empty, if its empty run another macro (which is an input box to put something IN a1), but if A1 has something in it, DO NOTHING. I keep getting errors, saying I'm not formulating my if statements correctly. This is what I have: Code: I have an Excel workbook that was created by a former coworker. It includes a macro that, among other things, displays a message box about the 2008 file. The macro runs as soon as the file is opened. I'd like to access that macro to correct the date to 2011 and see what else, if anything, it's doing for me (it doesn't appear to do much). I can find references to creating macros to hide and unhide rows/columns and I found ways to delete all macros in a workbook, but I cannot find anything about unhiding a macro without knowing its name. Does anyone know of a way to unhide this macro? Thanks! Is there an on error exit sub command. I would like my Macro to just stop running if there is an error instead of an error message popping up. Thanks in advance Arcangelo from Italy asks: How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1? This macro is amazingly straight-forward: Public Sub SaveAsA1() ThisFile = Range('A1').Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I'm totally lost on this 'amazingly straight-forward' macro!!!! Could someone help if I tell you the SAVE location? It's T:COMMISSIONINGIJTTIMELOG projectStaff#1. I'm just not certain what value I'm replacing in the Macro above. Any help appreciated.
I am using XL2007 and have a macro that refreshes microsoft query connections. The issue is the refreshes only happen if you step through the macro using the debugger. When you run the macro normally, everything else functions properly, but the data is not refreshed. Any help is appreciated. Here is an excerpt of the code: Workbooks.Open Filename:='C:Profile.xls' Sheets('SELECTION').Select Range('F3').Value = SNR ' THIS PART ONLY WORKS IF YOU STEP THROUGH THE MACRO USING THE DEBUGGER..IF YOU RUN MACRO NORMALLY THE CONNECTIONS DO NOT REFRESH ActiveWorkbook.Connections('Connection').Refresh ActiveWorkbook.Connections('Connection14').Refresh ActiveWorkbook.Connections('Query from C_Profile').Refresh ActiveWorkbook.Connections('Query from C_Profile1').Refresh
Hello, I am new to using Excel and I am not very computer literate. I am looking for some help with a spreadsheet I am making. Here is the problem: I have a column of 14 numbers in cells A1 to A14. If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1. I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. For example, I have entered =IF(A1<2,'Pass','Fail') in cell B1. Now if the value I enter in A1 is less than 2, it shows a 'Pass', and if the value in A1 is greater than 2 it shows a 'Fail' in cell B1. How can I get this to apply to all of the cells from A1 to A14? If somebody could help me out that would be great. Thanks, Randy I am looking for the code to select the visible data after applying a data filter. Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!! I am using below code to Select the Visible rows in the target range: Code: Problems in this code a 1) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook. I need this to select the the data only till the last used row in the given range. 2) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table. E.g. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6 3) The Code is also selecting the 1st row which is a header row. How can we exclude it from selection. Some one please revert with the solution. Thanks in advance. Hi, I would like to send SMS from a VBA macro to my mobile phone. Do anyone know how to do this? I am ready to pay a cost per SMS if necessary. (I asked the same question at another Excel forum without getting any reply.) Hi guys, Looking for some help and would appreciate your help. I want to prevent people cutting/copy/pasting on a spreadsheet I have developed. A couple of users keep doing so which in turn knackers my formulas. There will be occasions where I will need to be able to use these functions for maintenance and updates. Ideally I would like have a private marcro which I can run to enable these features as and when needed. I've been at this all morning and feel like I'm going round in circles. I've tried various bits of code (sourced via google etc) & have ended up with a whole manner of outcomes but not the one I want. To summaraise what I am looking for is some vba code which will do the followingDisable cut,copy and paste when sheet is openedEnable cut,copy and paste when closedHave a macro which when run will allow me to cut/copy paste so as to implement updates when necessary. Can anyone help? Thanks in advance
Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one. Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename). I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. and input the macro I'd need to run in each file in the appropriate location. Is this possible? Any help is greatly appreciated!! Thanks, Jason Hey guys, I'm trying to write a macro which prints to PDF and saves the file name as the contents of a cell. I've been looking through all the posts currently on this forum to get something working. I'm using the following code - Sub PrintPDF() Filename = 'C:Documents and SettingssambMy Documents' & ActiveSheet.Range('Z1').Value SendKeys Filename & '{ENTER}', False ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ 'Adobe PDF:', Collate:=True End Sub The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter. Any ideas where I'm going wrong? Any help would be much appreciated!
Hi All, I have the below code which deletes all items from a listbox and my excel sheet which is the source for populating that listbox. I am using a option button style for my listbox and the selection style as single .i.e. you can select only one item at one go in the lisbox. I want my macro to delete the selected item from my worksheet .i.e. it's entire row so that it doesn't reflect in my lisbox any more. Below is my code : Code: Thanks a lot for your help in advance. Hello All, I need a macro enabled file to send HTMLbody email with pre populated text to list of receipents. Any Idea How can i do? Many thanks Ben Hi there, longtime user firsttime poster. Looking for some help as I am a non-expert with macros. Here's what I'm trying to do: We have to submit things to a certain regulatory body and we usually enter tasks in as soon as they come, do the submission, and then keep a record of that submission. So, I have a workbook with two sheets, one is 'TO DO', the other is 'ARCHIVE'. Both sheets have the same columns and everything. I am looking for a macro that will automatically cut a (row) from the TO DO sheet and paste it in into the ARCHIVE sheet once it is done, then delete the cut row from the TO DO list so it stays topped up. The trigger for archiving is the columns M and N which are titled 'Complete ?' and each has a validation drop down that says 'YES'. When both cells in columns M and N have the YES in them, I would like the macro to make the above mentioned actions. I ran a search on the forums and found something similar, but not quite what I was looking for. Any help? |
Tera Term Tutorial
Hi, I need to run a macro file for 10successive iterations, capture the log and close the file once log for 10 iteraions are captured. Home inspection software reviews. Later start running the next macro file for 10 iterations. Am looking for a script to close the log file after 10 successive iterations. Thanks in advance.
Teraterm Macro Help
I have a usb serial port which connected to another computer with tera-term on it. Is there anyway from vba to talk through this serial port using a macro? Thanks in advance, Joe Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar TopicsI am trying to calculate the average Talk Time into Minutes and Seconds. Every time I have tried, I get the wrong average. For example, if I have a total of 53 calls and the total talk time is 4:19:05, what would the average talk per call be? I tried doing everything in seconds (this would give me a total of 15545 seconds) but the total I was getting is 4:89. What would the formula be to get the correct average time?
Hi all, I've had a long search through your pages to see if this question has been answered before but having browsed through about 50 pages worth of threads I couldn't see anything, but if I am repeating prior information I do apologise. I've written a macro that is relatively simple. It just takes some information in one format, rearranges it, adds some formatting and performs some calculations. Nothing incredibly fancy but it works fine on my computer. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. Should be fine and in most cases it is, however there is one user who although they can open the file, can't seem to get the macro to run properly. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. I have checked Macro Security level and that is the same as mine, Tools - Add-Ins is the same, In Visual Basic, Tools - References is the same as mine. It is the same Operating system and the same version of Excel. I have even signed into this person's computer as myself (it's a big company network thing) and tried to run the macro and it works fine, so there is nothing wrong with the hardware. I've googled and searched and tried everything I can think of but I'm no closer to solving this problem, so if anyone has read through this wall of text and can come up with a possible solution, that would be greatly appreciated to save me from tearing ALL my hair out! Thanks very much for your time.
From limited experience I know that excel calculates dates via serial numbers. I have formulas to add a number of days to a cell containing an entered date and display the resulting new date (ie. 03/01/2011 (c34)+11 = 03/12/2011) I am seeking to leave resulting formula cell blank until a date is entered in the input cell. Currently when the input cell is empty the formula cell obviously displays 1/11/1900 using the above example. What conditional format would achieve leaving the formula cell blank until date data in entered into the source cell? Hopefully a simpler question for your experience level than mine.
I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg. What could be wrong? Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum ! I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals. While scanning the photographs, I have saved them serially i.e. 1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. Problem : I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed : Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards ::: Jack I have a problem sometimes. I will click on a cell to add information. The cell turns blue and then wherever I move, it highlights those to. No matter where I go on the page. If I Alt-Tab and work in another program on my computer, that excel page keeps highlighting wherever I move even in those other programs (I know this sounds confusing). When I return to excel thousands and thousands of cells are blue. The biggest problem is that the highlighting won't turn off, no matter what. I can't select anything from the tool bars, do any work on the sheet or close the program. I can close it only with the task manager but when I open it again, the cursor is still stuck in the highlighting mode and won't perform any other functions. Do you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. Is there some shortcut to turn off this highlight feature other than restarting my computer. Which is the only current way I can get rid of it. Thanks for any advice, Hello everyone!!!! Here is my situation. I have been trying to learn macros but have not made one yet. Need your help. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc.. *COUGH COUGH* ya ok.. LMAO We have a 'shared' work book we all work in. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a 'refreshed' copy of the workbook before they start writing in cells that already contain information. How to I create a macro button at the top of the page that is literally a SAVE button. instead of them saving by going to File - Save or cntrl+s ??? I just thought that MAYBE having a big button in their face will remind them. Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins??? I don't mean a save.. but a refresh so the screen actually updates in front of you. (although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) Thanks so much!!!!! Muchly appriciated. I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. Excel will not let me copy and paste a formula and will only paste the value into to workbook. For instance, if I make a very simple spreadsheet such as: A1 type in 10, A2 type in =A1 (calculated A2 to be 10) B1 type in 5 And then click the copy on B1, and then click paste special on cell B2, the only options it gives me are text and unicode text and so no matter how I paste, cell b2 will always be populated with a value of 5. I cannot imagine a simpler copy and paste and no matter what I do I can't make this work. All cells are formatted as general. It seems that all copy and pasting of formulas in my excel has been disabled. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem. Any help? If I am using sendmail in a simple macro, is there any code I can add to actually open Outlook? Some users of the macro are pressing the macro button and do not have Outlook open so the email isn't sent until they eventually open Outlook! Thanks in advance Dear All, I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout. Please provide me with any Formulas as micros are disable in my Computer... Waiting for an early reply.... I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse. I am also not able to click on the tool bars at all. I have to actually Ctrl-Alt_del to get out of the program. I'm sure this is something simple, but I don't know that much about this program. Any help would be greatly appreciated.
I am trying to get my macro to do this on open. Check if a1 is empty, if its empty run another macro (which is an input box to put something IN a1), but if A1 has something in it, DO NOTHING. I keep getting errors, saying I'm not formulating my if statements correctly. This is what I have: Code: I have an Excel workbook that was created by a former coworker. It includes a macro that, among other things, displays a message box about the 2008 file. The macro runs as soon as the file is opened. I'd like to access that macro to correct the date to 2011 and see what else, if anything, it's doing for me (it doesn't appear to do much). I can find references to creating macros to hide and unhide rows/columns and I found ways to delete all macros in a workbook, but I cannot find anything about unhiding a macro without knowing its name. Does anyone know of a way to unhide this macro? Thanks! Is there an on error exit sub command. I would like my Macro to just stop running if there is an error instead of an error message popping up. Thanks in advance Arcangelo from Italy asks: How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1? This macro is amazingly straight-forward: Public Sub SaveAsA1() ThisFile = Range('A1').Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I'm totally lost on this 'amazingly straight-forward' macro!!!! Could someone help if I tell you the SAVE location? It's T:COMMISSIONINGIJTTIMELOG projectStaff#1. I'm just not certain what value I'm replacing in the Macro above. Any help appreciated.
I am using XL2007 and have a macro that refreshes microsoft query connections. The issue is the refreshes only happen if you step through the macro using the debugger. When you run the macro normally, everything else functions properly, but the data is not refreshed. Any help is appreciated. Here is an excerpt of the code: Workbooks.Open Filename:='C:Profile.xls' Sheets('SELECTION').Select Range('F3').Value = SNR ' THIS PART ONLY WORKS IF YOU STEP THROUGH THE MACRO USING THE DEBUGGER..IF YOU RUN MACRO NORMALLY THE CONNECTIONS DO NOT REFRESH ActiveWorkbook.Connections('Connection').Refresh ActiveWorkbook.Connections('Connection14').Refresh ActiveWorkbook.Connections('Query from C_Profile').Refresh ActiveWorkbook.Connections('Query from C_Profile1').Refresh
Hello, I am new to using Excel and I am not very computer literate. I am looking for some help with a spreadsheet I am making. Here is the problem: I have a column of 14 numbers in cells A1 to A14. If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1. I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. For example, I have entered =IF(A1<2,'Pass','Fail') in cell B1. Now if the value I enter in A1 is less than 2, it shows a 'Pass', and if the value in A1 is greater than 2 it shows a 'Fail' in cell B1. How can I get this to apply to all of the cells from A1 to A14? If somebody could help me out that would be great. Thanks, Randy I am looking for the code to select the visible data after applying a data filter. Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!! I am using below code to Select the Visible rows in the target range: Code: Problems in this code a 1) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook. I need this to select the the data only till the last used row in the given range. 2) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table. E.g. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6 3) The Code is also selecting the 1st row which is a header row. How can we exclude it from selection. Some one please revert with the solution. Thanks in advance. Hi, I would like to send SMS from a VBA macro to my mobile phone. Do anyone know how to do this? I am ready to pay a cost per SMS if necessary. (I asked the same question at another Excel forum without getting any reply.) Hi guys, Looking for some help and would appreciate your help. I want to prevent people cutting/copy/pasting on a spreadsheet I have developed. A couple of users keep doing so which in turn knackers my formulas. There will be occasions where I will need to be able to use these functions for maintenance and updates. Ideally I would like have a private marcro which I can run to enable these features as and when needed. I've been at this all morning and feel like I'm going round in circles. I've tried various bits of code (sourced via google etc) & have ended up with a whole manner of outcomes but not the one I want. To summaraise what I am looking for is some vba code which will do the followingDisable cut,copy and paste when sheet is openedEnable cut,copy and paste when closedHave a macro which when run will allow me to cut/copy paste so as to implement updates when necessary. Can anyone help? Thanks in advance
Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one. Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename). I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. and input the macro I'd need to run in each file in the appropriate location. Is this possible? Any help is greatly appreciated!! Thanks, Jason Hey guys, I'm trying to write a macro which prints to PDF and saves the file name as the contents of a cell. I've been looking through all the posts currently on this forum to get something working. I'm using the following code - Sub PrintPDF() Filename = 'C:Documents and SettingssambMy Documents' & ActiveSheet.Range('Z1').Value SendKeys Filename & '{ENTER}', False ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ 'Adobe PDF:', Collate:=True End Sub The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter. Any ideas where I'm going wrong? Any help would be much appreciated!
Hi All, I have the below code which deletes all items from a listbox and my excel sheet which is the source for populating that listbox. I am using a option button style for my listbox and the selection style as single .i.e. you can select only one item at one go in the lisbox. I want my macro to delete the selected item from my worksheet .i.e. it's entire row so that it doesn't reflect in my lisbox any more. Below is my code : Code: Thanks a lot for your help in advance. Hello All, I need a macro enabled file to send HTMLbody email with pre populated text to list of receipents. Any Idea How can i do? Many thanks Ben Hi there, longtime user firsttime poster. Looking for some help as I am a non-expert with macros. Here's what I'm trying to do: We have to submit things to a certain regulatory body and we usually enter tasks in as soon as they come, do the submission, and then keep a record of that submission. So, I have a workbook with two sheets, one is 'TO DO', the other is 'ARCHIVE'. Both sheets have the same columns and everything. I am looking for a macro that will automatically cut a (row) from the TO DO sheet and paste it in into the ARCHIVE sheet once it is done, then delete the cut row from the TO DO list so it stays topped up. The trigger for archiving is the columns M and N which are titled 'Complete ?' and each has a validation drop down that says 'YES'. When both cells in columns M and N have the YES in them, I would like the macro to make the above mentioned actions. I ran a search on the forums and found something similar, but not quite what I was looking for. Any help? |