Hi,
Currently for my project i am maintaing the shift records in excel. I want to create a C# application and want the same structure as excel into ACCESS or SQL Server database.
The data will be from 16th to 15th.
I am stuck in creating a table. Not able to figure out how to make the excel like structure in ACCESS or SQL.
Please check the attached excel screen shot....
rahulwagh
Last Activity: Jul 23 '14, 09:23 AM
Joined: Feb 3 '13
Location:
-
Create Timesheet application using c#
-
Find Text And Replace Entire Line in Notepad with New Text
Hi,
I have a notepad and I want to find a text into notepad.
Once I find the text in notepad then I want to replace entire line with new text.
This I want to do using Excel VBA.
I have written a code that searches in a file but replaces only the text which it finds but not the entire line.
Below is my code
...Code:Open folderPath & "\XXXX_VARIABLE.txt" For Input As iFile2
-
How to export the file uploaded on Sharepoint site using Excel VBA
Hi,
I want to export the excel file uploaded to sharepoint site using the Excel VBA macro. Could you please help me with this.
I tried WebQuery option but no success. -
How to Hide powepoint file using VBA
Hi,
Using excel macro I am creating powerpoint presentation and adding graphs on slides.
Similar to,
Application.Vis ible=False and
Application.Scr eenUpdating=Fal se
is there any way to make the powepoint and the screen updating false.
The reason I want this is to prevent the user from clicking the powerpoint slide while macro is running. -
Errors while creating Charts in Excel VBA 2010
I have written below code to generate a Graph based on a data in a sheet. But getting below errors.
1. The specified dimension is not valid for the current chart type.
2. Method 'MarkerStyle' of object 'Series' Failed
3. Method 'Delete' of object 'Series' Failed
4. Application Defined or object Defined Error
Below code creates total 36 Graphs first few graphs creats successfully but after that it fails... -
The issue was with the VBE7 DLL. As I mentioned in my previous to replace new DLL with old one. I cancelled this solution.
The issue was with VBE7 DLL. The DLL was not properly registered. I unregister and re-register the DLL and that resolved the issue. -
The issue is Resolved. The application were throwing errors because the VBE7 DLL was not properly registered.
I unregistered it and re-register it again that resolved the issue.Leave a comment:
-
Could you please tell me why it is short term workaround?Leave a comment:
-
zmbd,
I got the solution of all the issues. And now my macro is working fine on Windows 7 as well.
There is some problem with the VBE7 Dll i.e. Visual Basic For Application in Windows 7. I replaced this DLL with XP VBE7 DLL and it is working without any issue.Leave a comment:
-
Hi zmbd,
Thanks for your reply.
"thisworkbo ok" refers to the Macro but I want to save the file which macro is processing.
I have asked question under -
http://bytes.com/topic/excel/answers...s-perfectly-xp
Also have attached macro.
If possible could you please check it....Leave a comment:
-
Excel 2010 Macro not working on Windows 7 but same works perfectly on XP
This macro is written in Excel 2010 which works perfectly on Microsoft XP but it fails on Windows 7 and 8.
What macro does --- It gives 3 drop down options to user
Select Month ----This is the excel file for e.g. July 2013.xlsx it contains sheet from the date 1st July to 25 July
Select From Date --- Dates from 1st July to 25th July
Select To Date ----Dates from 1st July to 25th July
These 1st to... -
Hi zmbd,
I am trying to save the changed into current workbook into same directory.
When I replied to Killer42 I attached macro as well but don't know why it is not showing now.Leave a comment:
-
Expression is the object of Excel.
For e.g. Excel.Applicati on
But I am not creating object instead I am trying
Application.Wor kbooks(Dir(repo rtName)).Save
Purpose to use Dir(reportname) is since there are multiple excel files opened so rather than providing entire path just passing the name of the excel using Dir
I am trying to save the excel multiple times.
After 3rd it fails.Leave a comment:
-
Runtime error 1004 Document Not Saved
Hi,
I have written one macro in excel 2010.
I am trying to save the excel file using below code
Application.Wor kbooks(Dir(repo rtName)).SaveAs
Here report name is the compelte path of the file
But getting runtime error 1004 Document Not Saved.
Please help. -
zmbd, no idea how to declare the namespace.
Could you please tell me.Leave a comment:
-
Can you please tell me how to write it?Leave a comment:
-
Rabbit, Thanks for your comment.
Could you please tell me how to namespace and root element so that I can use "drm:".
Thank in advance.Leave a comment:
-
It's Excel VBA. Trying to create XML file based on the data in excel and getting the error reference to undeclared namespace prefix: 'drm'.
The line number where error is throwing is 141.
I want to add : after drm like <drm:></drm:>
If I am putting "drm-" then it is working fine but when I am putting "drm:" it is throwing an error.Leave a comment:
-
reference to undeclared namespace prefix: 'drm'
Please check the below code in child node I want to prefix it with "drm:" but I am getting error reference to undeclared namespace prefix: 'drm'
Please check the ConvertTexttoXm l procedure
...Code:'ForXML Dim objDom Dim objRoot Dim objField Dim objFieldValue Dim objcolName Dim objattTabOrder Dim objPI Dim objRow Sub GenerateXML() Dim -
Plotting Data According to Time
Hi,
Please check attached excel workbook.
The first sheet is the "RawData" the data in this sheet needs to be plotted into "PlotData" sheet according to the time Column E(Time). and Name (Column A)
In PlotData Sheet the frequency is given i.e. 30 min and 60 min.
For e.g. we will 1st check the Names in Name column of RawData sheet with the Names in Name column of PlotData sheet.
The Response of...
No activity results to display
Leave a comment: