Convert A Lotus File

Sep 6, 2005

>I am trying to convert a Lotus file over to Excel, and am having some trouble
>converting an error handling dget function.
>
>=IF(ISERR(DGET(Databaseread,"Name","GROUP
>ID"=GroupNumber)),VLOOKUP(GroupNumber,Databaseread,4,FALSE),DGET(Databaseread,"NAME","GROUP ID"=GroupNumber))
>
>This is the function that was used in Lotus; it returns the name of a
>company by looking at the ID number. I need to keep it as pure as possible to
>the Lotus file.
....

Lotus 123's @DGET (and other database functions) are much more
sophisticated than Excel's counterpart functions. 123's can use
criteria expressions in the function calls. Excel's require criteria
ranges.

In this particular case, there's no need to use DGET at all. There's a
single criterion term, so VLOOKUP is sufficient. If the "Name" column
were the 4th column in Databaseread, then try

=VLOOKUP(GroupNumber,Databaseread,4,0)

Explanation: it appears you're just trying to find a particular group
number. DGET (and @DGET in 123) returns an error if there's more than
one entry. VLOOKUP returns the first matching entry. You're formula
makes it clear you want either the only matching entry or the first
matching entry. However, when there's only one matching entry it's also
the first matching entry, so VLOOKUP alone would have returned the
desired result.

I suspect you have other formulas that are more complicated, but you
believed the formula above would be a reasonable sample to provide. Not
so. If you have more complicated D-function calls, show them, not the
simple ones.

View 13 Replies


ADVERTISEMENT

Attaching File To Lotus Notes Email

May 12, 2006

I managed to create the attached macro with help from stuff I've found in the internet. With this code, I am able to save the file and then send an email cia Lotus Notes. I need two things:

(1) The code to attach the file saved into the email that it sends

(2) The code so that the file is protected so that changes are not made by the recipient.

HERE IS THE
ActiveSheet.Copy
ActiveWorkbook.SaveAs filename:="V:TFMCO8 ReportingHistory" & [c22].Value & " " & Format$([c20], "- (YYYY-MM-DD)") & ".xls"
ActiveWorkbook.Close False

Dim Maildb As Object, UserName As String, MailDbName As String
Dim MailDoc As Object, Session As Object

Set Session = CreateObject("Notes.NotesSession")
UserName = Session.UserName
MailDbName = Left$(UserName, 1) & Right$(UserName, _
(Len(UserName) - InStr(1, UserName, " "))) & ".nsf"
Set Maildb = Session.GetDatabase("", MailDbName)
If Maildb.IsOpen Then
Else: Maildb.OpenMail...........

View 9 Replies View Related

Excel Macro For Lotus Email With Attached File?

Aug 6, 2014

I'm trying to create an excel macro that can send emails with an attached file per row of my entry in excel I imagine it would be like the screenshot below. I've tried the code in the link below from a macro tutorial website but wasn't able to make it work due to error DataObject is unkown I'm using excel 2013 and lotus notes 8.5 as my email.

View 9 Replies View Related

Place Excel File Path As Link In Lotus Notes Email Body

Oct 29, 2013

I have an Excel sheet that I use as a mailing automatism for reports. As it currently is it attaches an actual copy of the excel workbook to the email and send them out. The mailer contains several different people, and they get different report each day. Due to the size of some of the files, I am starting to run into an issue where I cannot sent the emails anymore because they are too big, so I am wanting to switch to sending links to the files instead, and I have hit a wall.

I use Lotus Notes 8.5. The VBA will cycle through a range, and each cell has a list of report delimited by a ",". It takes the list and passes it to the mailer as a string. The mailer takes the string, turns it into an array and splits it out, and then checks to make sure the reports are current. One email could have up to 10 different reports in it. I have tried creating an HTML MIME email to include the links.

Here is the code I currently have:

Code:
Sub Send_HTML_Email(ByRef Name As String, ByRef Address As String, ByRef Reports As String)
Const ENC_IDENTITY_8BIT = 1729
'Send Lotus Notes email containing links to files on local computer
Dim NSession As Object 'NotesSession
Dim NDatabase As Object 'NotesDatabase
Dim NStream As Object 'NotesStream
Dim NDoc As Object 'NotesDocument

[code]...

View 1 Replies View Related

Convert Each Column Of An Workbook File To New Text File

May 30, 2007

I want macro which export each excel column to new text file. The data in excel file is number. The column has only 5 rows that means each new text file should contain five lines of one column. It looks simple but couldn't manage to do macro for it. I have very big data set in one excel file, and have to be splitted into text files. The file name in new text files can be any kind as long as it can be in some sort of order for each export.

View 2 Replies View Related

Convert Text Delimited File To .xls File Using Vba

Nov 28, 2008

how to word it but if someone understands then please help. I have two excel data files namely Book1.xls & Book2.xls. Both files have different data in it. Both files contain macros. When these macros run the files become **FINALIZED** version.

Originally, I get the above files in my email as txt. attachments. I then move these two txt files to my desktop in a folder called Folder-1. Then I open these files as an Excel and save them.

Basically, I need to know if two txt files are sitting in a folder-1 on my desktop. What can I do or what can I clik that....those two text files get converted into excel automatically, including running that macro I talked about in the above paragrah.

To put it differently, if I have two txt files Book1.txt, Book2.txt in a folder, how can I automatically create an excel **FINALIZED**version which sits right next to their txt version.

View 9 Replies View Related

Convert A CSV File Into A Formatted File

Jan 6, 2009

I tried many ways to convert a CSV file into a formatted Excel (.xls) file via VBA. I have a file with 5 lines (header included) and about 10 columns (delimited by commas).

How can I format it via vba on button click action?

View 9 Replies View Related

Convert CSV To XLS File?

Feb 2, 2013

Is there a way to convert a csv file to an xls file without using any software.

View 4 Replies View Related

Convert Each Row In Spreadsheet Into TXT Or XML File?

Nov 18, 2011

I have a spreadsheet with thousands of lines of code. Each row contains a complete code that needs to either be converted/pasted to a new .txt or .xml. Until now, just copying and pasting each line into a .txt file was necessary but there has to be a way to automate this. I would love to know if it's possible to extract each row(technically it is only a single cell per row, so its just a really large single cell) and add it to a .txt or .xml file?

View 12 Replies View Related

Convert CSV To XLXS File

Apr 7, 2013

I'm trying to convert a csv file but after conversion not everything is in place.

View 3 Replies View Related

Convert PDF To Excel File?

Feb 11, 2012

Is there a free program available to convert PDF files to an excel file.

View 1 Replies View Related

Convert Excel File Into Web App

Aug 16, 2013

Converting excel files into fully functional standalone and interactive web applications/dashboards? I have only worked with spreadhseetconverter before it converts excel files into interactive calculators but lacks the features which are available in the standard dashboards like gauges and widgets and the rest because it only converts the standard excel charts. I wonder if you have encountered a product which can converts excel files into fully functional interactive dashboards?

View 1 Replies View Related

Convert Workbook To PDF File

Apr 26, 2006

convert all spreadsheet in a workbook to one pdf file. I use PrimoPDF to convert, then I only convert 1 sheet to PDF even that I have select all sheets. My be it is a better PDF converter for free you use or other ways to do it.

View 4 Replies View Related

Convert Xls File To Stand Alone Exe

Aug 15, 2006

I am finishing up a program using excel that does a lot of nice things, and seems to be working. I want it to be used by anyone, even if they do not have Excel. I want it to be *my* program completely, w/o Excel being a part of it anymore. Is there a way to compile an excel file and turn it into an EXE file so there is no need for an excel program to run it?

View 5 Replies View Related

Convert Pdf File To Spreadsheet

Feb 23, 2007

Someone sent me a pdf file. It contains a list of items but the problem is I need to be able to copy and paste each item individually. I tried doing a google search to find a way to convert the PDF to a word doc but did not have any luck. So I think my only other alternative is to convert it to an excel (XLS) file.

Does anyone know of a way to do this so that I can successfully copy and paste words from the document individually and not just wind up with an excel file with a picture of the PDF file in it?

View 3 Replies View Related

Unable To Convert File Types?

Dec 11, 2013

I am having trouble converting file formats. I would like to convert a.xlsx file to a .xls file. It is password protected and everything I have tried to use to convert the file has failed.

View 5 Replies View Related

Convert XLS To Pipe-delimited TXT File

Jul 15, 2009

I have the following code (borrowed) which converts the current .xls worksheet to a tab-delimited .txt file. The problem is that i need to add a PIPE to the end of each row/record as well, so that the records would look something like this:

A|123|
B|456|

currently there is no PIPE following the last character (3 or 6) and i am getting this:

A|123
B|456

I was hoping there would be a way to revise the VBA to add a PIPE at the end of each row/record.

Here's the code:

[Code] ......

View 10 Replies View Related

Convert The Notepad File Into Excel

May 20, 2008

I have a notepad file that contains data. We need to convert the notepad file into excel and then segregate the data after conversion. Segregation point would be the point where in we can find keyword “Summary”. We need to create a macro that finds the occurrence of summary keyword. Then from the beginning till that summary point cut the entire data and paste in other worksheet. Name the worksheet as “Receivables” or “Payables” or “Fee Payable” depending what type of data that summary contains.


After creating different worksheets we need to format the worksheet in specific format.
For example: I have attached the “Recon1” XL file attached. Under Recon1 – “RECEIVABLES 1” contains the as is data converted from notepad. Later we need to modify the same data using macro as specified in “RECEIVABLES 2” and then as per the format available in “RECEIVABLES 3”.

View 14 Replies View Related

Convert .xls To Pipe-delimited .txt File

Jul 15, 2009

I have the following code (borrowed) which converts the current .xls worksheet to a tab-delimited .txt file. The problem is that i need to add a PIPE to the end of each row/record as well, so that the records would look something like this:

A|123|
B|456|

currently there is no PIPE following the last character (3 or 6) and i am getting this:

A|123
B|456

I was hoping there would be a way to revise the VBA to add a PIPE at the end of each row/record. Here's the ...

View 4 Replies View Related

Convert Sheet To PDF File Using Loops

Aug 14, 2009

Using a macro, how can i convert one excel sheet to one pdf file using loops etc.

e.g. Go to sheet named "sheet1"
save this sheet as "sheet1.pdf"..

Go to "sheet2"
save this sheet as "sheet2.pdf"

View 3 Replies View Related

How To Convert Excel Sheet To PDF File By VBA

Dec 8, 2010

How to convert Excel sheet to PDF file By VBA code.

View 9 Replies View Related

Excel 2003 :: Convert PS File To PDF?

May 24, 2012

Every day I create many Excel reports that I manually save as PDFs for distribution to my stakeholders. I'd like to automate this process using a macro. I've seen the following code online and have attempted to use it, but receive an error in the Dim MyPDF line of code indicating that the user-defined type is not defined.

I'm using Excel 2003 and Acrobat Distiller 8. I have no problem creating PDFs manually

Code:
Sub Create_PDF()
Dim tempPDFFileName As String
Dim tempPSFileName As String
Dim tempPDFRawFileName As String

[Code]....

View 2 Replies View Related

Convert Addresses From PDF File Into Excel

Sep 10, 2012

I am having a challenge at work. We have a client that emailed us an PDF file with addresses. There are over 200 pages and each page has 30 addresses (3 coloumns and 10 rows). When I try to copy and paste the addresses into excel, the addresses are all next to eachother and are pasted into excel as you would see an address on an envelope. But I need the parts of each address in a seperate column.

For example
column 1: name of company;
column 2: name of recipient;
column 3: address,
column 4: city;
column 5: state;
column 6: zip

View 4 Replies View Related

TXT File- Convert Using Text To Columns

May 15, 2007

I have a .txt file which i need to convert using text to columns in excel, obviously this is simple, however my .txt file is 325000+ rows of data

Is there anyway I can Excel can cope with this amount of data, I know that my row limitation is 65536, can i spread the data across multiple sheet tabs?

View 9 Replies View Related

One Two Seperate File And Convert Using MACRO

Feb 20, 2009

Take two separate excel files and convert into another format. I know it sounds crazy, but I will post a screen shot of before and after.

Input file called 2-qip-dnsdomain.csv which has several rows that look like: ...

View 9 Replies View Related

Convert Excel WB To Pdf File And Print - VBA

Sep 23, 2004

I want to put an Excel workbook to pdf format and print it out at the click of a button located in the book. However, when I try to record the macro to get a feel for how to control pdf with Excel, I get a pdf file but no printout and no code to veiw!

View 9 Replies View Related

Convert Text Imported From CSV File To Number

Mar 25, 2013

I am trying to convert a text imported from CSV file to a number so that I can further elaborate it.

I tried value, trim, clean but without sucess.

Cell values is -10 000,00 what I want to display is 10000.

How can i Do that.

I am attaching a demo file for illustration : Webistexpences.xlsxi

View 6 Replies View Related

Get Macro To Convert Without Format File To Excel?

Jul 25, 2013

I want a macro that will open a without fiile in a folder and convert without format file whose name is like

"cognos.701Z%27%5d&SA=propEnum,properties&ITEM=data&EA=&SS
=queryOptions,options&dataEncoding=MIME&ES=&EM=" to Excel (.xlsx).

Save excel file in same folder and delete above file.

View 8 Replies View Related

VBA Code To Convert Excel To Text File

Sep 20, 2007

to convert Excel file to Text (txt) file using VBA code.

I have data in range A3:C10 of Excel Spreadsheet and I need VBA code to read then write this data into text file and save as .txt file

View 9 Replies View Related

Convert The File Into Text Document With Out Changing It

May 22, 2008

I want to convert the excel file into text document with out changing it
file type

for example

in the wordpad i have the text document in this type
"Candy","1253563"

I want this to be open in excel and i can open in the excel using delimited option but i want only to change the number "1253563" and i can use autoofilter to filter and i want to change the number "1253693" in the excel and i want that excel should open in the format of text document without any change as i mentioned before

it should open in this format

"Candy","1253693" only the number should change and this action is repeated for many numbers

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved