notepad

Hello, I'm new to programming and have been tasked with creating a script that will represent a line on a map representing a oil pipeline. So far, I have been able to produce a script in notepad+ that will produce a line on the map, however, I'm in a need of a more efficient method. The problem...

Hi! I'm working on a program in VBA that requires copying and pasting from Excel to Notepad, and I could use a little help. In another method in the same worksheet, a program automatically generates the contents of a sheet, x amount of cells at a time (it's not fixed, it's based on user...

Hello;)!! Is it possible to import a my excel work in notepad++ so that the users of my website can use the excel formulas? (they will be using them without seeing the formula just by edding some details and they will get calculated formulas back.) Thanks! Karolien

Hello, i need help in the below. how i can migrate the data in excel row by row to a notepad template i already have ...

<b1><c1><d1><b1><c1><d1><b2><c2><d2><b3><c3><d3><b4><c4><d4><b10><c10><d10>Hello,i need help in the below.how i can migrate the data in excel row by row to a notepad template i already have ...

Need a macro, help appreciated. I have two files, test.txt and test.xls The requirement is that, specific text(word) from test.txt file must be replaced with a specific cell content from test.xls Like D1 text must replace with the cell content D1, D2 with cell D2, and so on….. pls help soon

I have a notepad containing tags. My requirement is to change the data as below: My input file will have 1000+ lines with the similar data to be replaced. Actual: <a xlink:href="javascript:alert('XGMC021D');" xlink:title="XGMC021D"> <ellipse fill="none" stroke="black" cx="1548" cy="-898"...

Hi everyone, I'm very much a newbie here. I have a spreadsheet that contains about 600 rows; in each row contains a great deal of text (several thousand words). I am trying to convert/transfer each rows into a separate text (.txt) file. By way of background, each of these rows contains a...

Hi, I am new to this forum and I have the following question. I can write a makro to open notepad, open a file, and than have it copied to excel. Sub notepad() ' ' notepad Macro ' ' Sneltoets: CTRL+n ' ActiveSheet.Paste Range("A11").Select ActiveSheet.Paste End Sub But what I need...

Hi All, I need your help to develop a Macro which will help me to eradicate a continuous task... I have output in CSV as below CSV FILE <tbody> Business Name Address 1 City State Zip Phone Tips & Toes Nail Salon 9430 W 191st Mokena Illinois 60448 (708) 478-7420 L A Nails 11322 Lincoln...

Hi All, I am a newbie on macro's and still learning :cool:. Hope you can help me out. I have a working sendkeys macro. Accept for one part that I can't figure out; ErrHandler1. Problem: No search result error from notepad if text is not present in notepad file Solution looking for: if no...

I have to confess I am a complete dummy when it comes to VB. I have an Excel spreadsheet which I would like to export to notepad. There are 4 sheets to the spreadsheet. The first takes input and runs some calculations and gives out figures. The following three take the information and translate...

Dear All, I want to open a notepad file from my excel file, paste a range of cells from my excel file to the current notepad file, name the notepad file same as my current file name and ultimately save it on either Desktop or the same path where my excel file exists and close the notepad file...

This question is similar to many "Notepad posts," but I've not been able to adapt the solutions to my use. Specifically, I'm not trying to write to a text file. I'm trying to use Notepad to strip out HTML formatting before pasting the resulting HTML-free text into a one-column Excel range...

Hi, I have an Excel file with 2 Columns and 1001 Rows. Row 1 contains the Column Headers: A1 = Name, B1 = CV A2 is the person's name e.g. John Smith. B2 is the whole of their Curriculum Vitae (just in text form). And so on A3, B3 ... A1001, B1001, a thousand names and a thousand CVs. I need...

I don't know if VBA can do this, but I have a range that I am trying to copy, and one of the cells has text data that I need to wrap at 40 characters. If I set the word wrap in Excel, it works fine as long as it is in a Microsoft Office program. However, I need the macro to wrap text at 40...

Sorry if this is a repeat, but I'm brand new to VBA, and after looking through the forums, I couldn't figure out what parts of which codes I would need to get this to work like I'm hoping. So essentially what I have is a workbook with 12 sheets. Sheets 1 and 2 have user input data which is...

When I click on the hyperlink to a file that has no extension, that I want to open in excel, it comes up with a "Cannot open the specified file" box. It would open in automatically with a .txt extension, but as the files are generated automatically this is not ideal - a work around in excel...

Hi all, How can I close Notepad from VBA and overwrite the file with UTF-8 encoding? ATM I'm using Shell "Notepad.exe" & filename, 1 to open the file the file are encoded with ANSI, I want to save it with UTF-8 encoding, how can I do that? thanks Anders

Hello, I have created a macro that pastes a range of excel data (via a loop function) into a .dat file, which is later FTP'd to another team. The only issue that I'm running into is that they cannot accept the file with a space at the end, which is unfortunately automatically entered into the...