Code:
Sub Workbook_Open() end sub
bpremlatha
Last Activity: Dec 31 '14, 08:42 AM
Joined: Nov 19 '14
Location:
-
The error shown at line 48. I have use personal macro vba. Personal macro script available every-time we open the excel no matter which file. In my case, I have use batch file to run the excel file which contain data. After that, I use
to auto run the script. I have call Sub SaveFile() , Sub RemoveEmptyRow( ), Sub ConcatenateColu mn(), and Sub DeleteBlankColu mns() in Sub Workbook_Open()... -
Method 'Range of object '_Global' failed
...Code:Sub WorkBook_Open() RemoveEmptyRow ConcatenateColumn DeleteBlankColumns SaveFile End Sub Sub SaveFile() 'ActiveWorkbook.Save ThisWorkbook.Saved = True Application.Quit Application.ActiveWindow.Close SaveChanges:=True ActiveWorkbook.Close SaveChanges:=True 'ActiveWorkbook.SaveCopyAs ("D:\save\" & Format(Now, "ddmmyy") -
Delete entire row in excel if column A is empty
I'm very new in using VBA. The excel table has more than 500 rows. I would like to run vba code to remove row where column A is empty. I tried run this code.
...Code:Sub DeleteAlternateRow() Dim i As Long Dim DelRange As Range On Error GoTo Whoa Application.ScreenUpdating = False For i = 1 To 1500 If Application.WorksheetFunction.CountA(Range("A" -
Insert db paradox file to SQL server automatically
How to insert db paradox file to sql automatically in a readable format. The db paradox file can be read by using software such as gnumeric spreadsheet and paradox d-base reader. From gnumeric spreadsheet , I can manually export db file to other format to be inserted to sql server. I would like to know if there are automatic way to convert db to csv or excel. Thank you. -
Thank you.Utf-8 are format for text type file. For the dat that have unreadable content but have textual data inside. If we convert to utf-8,then the file can be read? Thank you again. I will try to find out too.Leave a comment:
-
Thank you. How to identify whether the dat file content is binary? After get know how the data stored in dat file, must write some code to read the file? thank you.Leave a comment:
-
Import dat file content into ms sql server in a readable format
Dat file generated by X application.Thi s file in paradox database folder of this application. The main output data from the machine saved in this dat file. But, I could not read the content. Help me on how to read this dat file. A part of dat file content:
...Code:£<,?síÂ;ù÷™=Âõ<wA?5)¼;M¡³=ìQ8=M@W?êMó;¡JÍ=Âu=i´v?mUÐ;öóæ=¸…= ±ƒƒ?áŠè;¥N >{®="”?§b<ù÷>=
No activity results to display
Leave a comment: